I have a multiprompt report (dimensional) which accepts single input values for each prompt. Since the job was to accept only one value for each prompt, I didn't have any problem to tuple that with other members.
Eg, My prompts are City ([Retail_Reporting].[Retail_City].[Retail_City] -> ?pCity?) and
Store ([Retail_Reporting].[Retail_Store].[Retail_Store] -> ?pStore?) and
Year.
Calculation :
tuple([Selected Year], [Selected City], [Selected Store], [RET101 - Direct Costs], [Selected Currency] )
Now I have been asked to burst this report for city and store combination which means the city and store are no longer single values.
For each city and store combination, I have to get a burst report output in PDF format.
Therefore I had to convert my existing report like the following,
In my query, I have used dataitems like,
City : Set(multiple city members) , Store : Set (multiple store members)
Calculation :
total( tuple([Selected Year], [RET101 - Direct Costs], [Selected Currency] ) within set [City Set], [Store Set]).
For some reason, this isn't producing the right result. I have compared my previous output with the burst output but it is not the same. Please let me know if you have any idea on this. It should be something simple but I am struggling to find out. Please let me know if you have any clue on this.
Thank you.