Hi all,
I modeling a dimensional package in FM10.2. When I tried to customize the attribute using the following code. It does not give any error message then doesn't display result too only blank space were display while test the query that is.
case when ([Business_Namespace].[WorkEffort].[WORK_EFFORT_PURPOSE_TYPE_ID] = 'RF_RETAINER') then ('Retainer')
when ([Business_Namespace].[WorkEffort].[WORK_EFFORT_PURPOSE_TYPE_ID] = 'RF_FEATURE') then ('Change request')
when ([Business_Namespace].[WorkEffort].[WORK_EFFORT_PURPOSE_TYPE_ID] = 'RF_SUPPORT') then ('Support')
when ([Business_Namespace].[WorkEffort].[WORK_EFFORT_PURPOSE_TYPE_ID] = 'RF_BUGFIX') then ('Bugfix') end
Here WORK_EFFORT_PURPOSE_TYPE_ID belongs to the level of work_effort in work hierarchy.
Thank you in advance.
Try adding an 'else' clause to see if things are falling through the case. Review the domain of values in your data.
Hi lynn,
Thanks for your response I was tried IF..ELSE statement too but I can't get the result while test the query. Blank space only display on that time.
Try this and put this in the Business Layer, not in the DMR layer, then use this in the hierarchy in the DMR layer as a regular column. You may have to set this as membercaption and WORK_EFFORT_PURPOSE_TYPE_ID as the businesskey.
case
when ([Business_Namespace].[WorkEffort].[WORK_EFFORT_PURPOSE_TYPE_ID] = 'RF_RETAINER') then ('Retainer')
when ([Business_Namespace].[WorkEffort].[WORK_EFFORT_PURPOSE_TYPE_ID] = 'RF_FEATURE') then ('Change request')
when ([Business_Namespace].[WorkEffort].[WORK_EFFORT_PURPOSE_TYPE_ID] = 'RF_SUPPORT') then ('Support')
when ([Business_Namespace].[WorkEffort].[WORK_EFFORT_PURPOSE_TYPE_ID] = 'RF_BUGFIX') then ('Bugfix')
else ('Other')
end
Thank you for your response cognostechie,
I made it. Thanks for your valuable information.
Have a nice day.