Hi all,
I want to create a crosstab with product line as rows and in columns in want to add the Quarter input by user and prev three quarter to that. The user should have to option to input the frequency of previous quarters to be shown in the column.
I am using DMR (Sales Data Warehouse ) Package.
Plz suggest the possible way to achieve it with the sample package.
Thanks in advance.
Unfortunately I do not have a report studio in front of me.
In order to get the selected quarter create a data item (named Selcted Quarter)with the following expression
[Quarter Level]->?Quarter?
For having the last three quarters create a data item with the following expression
lastPeriods ( 3, [Selected Quarter])
Thanks Pricter for replying...
When i created the report with the given code it is throwing the error DPR-ERR-2056 : The Report Server is not responding. (Though i can run other report)
Please check the attached XML and suggest some solution.
As I said I do not have a cognos installation infront of me.
But you can try the following.
Instead of using parameter ?P1? try to use a macro to fetch it. For example
lastPeriods (#prompt('P1','integer','3')#,[Selected Quarter])
I managed to get a report studio in front of me with the sample.
You wrongly used the Quarter Key. Instead of this you should use the Quarter Level
For example replace the (in both queries)
[Sales].[Time].[Time].[Quarter].[Quarter key]
with
[Sales].[Time].[Time].[Quarter]
and your report will work
Thanks a lot ... You solved my problem :)