Issue in Displaying rolling 6 months data in crosstab

[callmenagendra]

Hi,

I am using cube as source to create a report in report studio.
I want to display rolling 6 months data in rows.
I want it from january 2014  to june 2014.
But data is not available for last two months ( for may and june).
so it is displaying data from november 2013  to april 2014.
how to overcome this issue?
Can anyone help me on this?


Thanks in Advance,
Nagendra

[MFGF]

Hi,

I am using cube as source to create a report in report studio.
I want to display rolling 6 months data in rows.
I want it from january 2014  to june 2014.
But data is not available for last two months ( for may and june).
so it is displaying data from november 2013  to april 2014.
how to overcome this issue?
Can anyone help me on this?


Thanks in Advance,
Nagendra

Hi,

If May and June have not yet been added into the cube as members, they are not there for you to display in your report. What do you want to show - just 4 months worth of data?

MF.

[callmenagendra]

I want to display empty column if the data is not available.

[MFGF]

I want to display empty column if the data is not available.

Hi,

The issue is that the data you want to show isn't physically there in the cube. Your report can't show data that doesn't exist. If the month members were there but with no measure values, you could get the result you desire, but from what you describe, there are no members for May or June (or indeed July, August, September, October etc) so your report has nothing to display. To get the result you require you would need to modify the cube to have the month members included up to and including the latest month you wish to show.

MF.

[callmenagendra]

Thank You