Hi ,
I need Daily sales and Week to Date sales values for each departments but my expression gives value for only 1 department.Here is my Tuple expression ,can some one suggest
tuple ([Hierarchical].[Sales].[CMP Member Net Sales Amount],[Hierarchical].[Fiscal Calendar].[WTD_AS_OF_YESTERDAY].[WTD_AS_OF_YESTERDAY(All)]->[all])
I am trying to achieve
Dept Daily Inc WTD Inc
11 130.9100 26.67% 633.8800 -10.68%
12 35391.1600 -4.44% 273991.3200 4.64%
13 67612.8600 -8.62% 533159.7800 5.61%
Its DMR i know its not good practice to use detail filter but we have used below:-
roleValue('_businessKey',[Hierarchical].[Company].[Location].[Location] ) = #prompt('pmt_Location','string','110')#
can some one suggest how to i achieve my requirement
Why are you bothering with tuple expressions at all? Assuming your facts and your time dimension have the granularity required, I am not seeing anything that is not achievable with regular drag-and-drop operations into a crosstab and some dimensional aggregation functions. Or am I missing something?
Its a List report and Expressions for fields in the report i used are:-
Dept
substring ([Hierarchical].[Department].[Department].[Department].[Dept Num],1,2)
Daily Sales
tuple([Hierarchical].[Sales].[CMP Member Net Sales Amount],[Hierarchical].[Fiscal Calendar].[Yesterday].[Yesterday(All)]->[all])
WTD Sales
tuple ([Hierarchical].[Sales].[TY Member Net Sales Amount],currentMember ([Hierarchical].[Fiscal Calendar].[WTD_AS_OF_YESTERDAY]))
Inc
tuple ([Hierarchical].[Sales].[CMP Member Net Sales Amount],currentMember ([Hierarchical].[Fiscal Calendar].[WTD_AS_OF_YESTERDAY]))