Default 3 months data For Cube based report

[tgs728]

Hi All,

Cognos 10.2
Database SQL Sever 2012
My report source is Power play cube.
In my report i have chart with Month Key on X Axis and measure on series.And year and month value prompts on report pages which are optional.
Can anybody tell how to default give last 3 months to this report. When my report will run it only should show last 3 months data by default. Instead of all the data in Cube.
What is filters i need to use, i got this in relational model by not sure how to get it in DMR OLAP report.

Thanks,
TGS

[Francis aka khayman]

as the saying goes, there are many ways to skin a cat... though I think its inhuman, i perfectly understand why someone would want to do that.

anyway first it would be a lot easier if you change the prompt to display the months (members) as selection choices.
if you want to do that, then you have to do the extra step of finding the member using the year and month prompt.

the next step would be to choose from several functions which will do the job. i am only able to name 2. feel free to add more:

lastPeriods
lag + set

[tgs728]

Hi All,

Is there any other Solution for this.?


Thanks,

TGS

[sdf]

http://www.cognoise.com/index.php?topic=23939.0

Please have a look at this post. I think this is somehow similar to what you are aiming to.
You just need to adjust for the last 3 months from current month.

[Francis aka khayman]

i was the one helping on that post as well and my suggestion was to use lastPeriods

http://www.cognoise.com/index.php?topic=23939.0

Please have a look at this post. I think this is somehow similar to what you are aiming to.
You just need to adjust for the last 3 months from current month.

[cognostechie]

Hi All,

Cognos 10.2
Database SQL Sever 2012
My report source is Power play cube.
In my report i have chart with Month Key on X Axis and measure on series.And year and month value prompts on report pages which are optional.
Can anybody tell how to default give last 3 months to this report. When my report will run it only should show last 3 months data by default. Instead of all the data in Cube.
What is filters i need to use, i got this in relational model by not sure how to get it in DMR OLAP report.

Thanks,
TGS

Why not just save the report with a different name , delete the prompts and use the last 3 months from the Data dimension which is a standard feature in a Powercube. If your cube doesn't have it, you can add that as a Relative Category in Transformer.

[tgs728]

Hi All,

After following above link which was given , now i have 1 issue.

When i am using the new dataitem created is not able to  drill down in the chart but previously i can dril down, may be i am using item in the below dataitem  . I have tried to replace item to Members but it is throwing the below error.

  Invalid coercion from 'memberSet' to 'hierarchy, level' for 'tail .


CASE
WHEN (?Period?='Last 6 Months') THEN lastPeriods(6,item(tail([Dimensions].[MIS Time Non Daily].[MIS Time].[Month]),0))
WHEN (?Period?='Month') THEN ([Dimensions].[MIS Time Non Daily].[MIS Time].[Month])
WHEN (?Period?='Quarter') THEN ([Dimensions].[MIS Time Non Daily].[MIS Time].[Quarter])
WHEN (?Period?='Year') THEN ([Dimensions].[MIS Time Non Daily].[MIS Time].[Year])
WHEN (?Period?='Months on Books') THEN ([Dimensions].[Months on Books].[Months On Books].[Months On Books])
ELSE (NULL) END