displaying empty column on YTD report

[pooja]

I am sorry if topic this has been discussed already....!!


Hi All,
For current YTD report, using dimensional package(cube)- how to display 12 month columns even if there are no data for some columns.
This is the expression that I am using now,-
periodsToDate ([CUBE].[IS Period].[IS Period].[Year],[time])
But it display only those columns which has data, not beyond. if there are no data on remaining columns I need to display those as blank/empty columns.
Pleas share any thoughts.

Ex- if we run for MAY 2014, then report should display all 12 months columns even if there are no data after MAY 2014

Thanks,
P

[Francis aka khayman]

first of all, make sure there are values for future dates (ex. Jun 2014, Jul 2014, etc)
second, make sure you are not filtering or suppressing zero values.

[pooja]

Hi Khayman,

Thank you.

1) There is not suppression zero on columns value.
2) We would like to display reaming months column, even if there are no values. So this is where actual issues is. Not sure how to achieve?


P

[pooja]

Hi all

Any thoughts??

[Lynn]

first of all, make sure there are values for future dates (ex. Jun 2014, Jul 2014, etc)
second, make sure you are not filtering or suppressing zero values.

Hi Khayman,

Thank you.

1) There is not suppression zero on columns value.
2) We would like to display reaming months column, even if there are no values. So this is where actual issues is. Not sure how to achieve?


P

Pooja, You didn't answer the "first of all" question that khayman asked. Do the future dates exist in your dimension or not?

I would suggest that periodsToDate does not sound like the correct function to be using based on your description of the requirement. Why are you using that function? Did you try anything else like the children or the descendants function?

[pooja]

Hi Lynn,

Yes we have future dates on our dimensions. Example- we have all the months available for year 2014 (Jan-Dec). This is MAY 2014 and we have data in our model till MAY 2014, but not from JUN- DEC. Now, when user run the report for MAY 2014 then report should display complete period for 2014 even though there are not data after MAY.

Please advise if this is clear.

Thanks,
P

[Lynn]

Hi Lynn,

Yes we have future dates on our dimensions. Example- we have all the months available for year 2014 (Jan-Dec). This is MAY 2014 and we have data in our model till MAY 2014, but not from JUN- DEC. Now, when user run the report for MAY 2014 then report should display complete period for 2014 even though there are not data after MAY.

Please advise if this is clear.

Thanks,
P

Once again you've only answered half of what was asked!