Hi Everyone
Looking for some assistance with a crosstab I am building using a TM1 cube as a datasource.
I'm building a monthly P&L report which simply shows the months across the top ( Jan - Dec ) and a total for the year.
The crosstab is a page within a report which also has reports based on the month and YTD. The month is selected by a value prompt.
The issue I am trying to resolve however is on the monthly P&L page.
When a user selects a month, let's say "Feb" for arguments sake, but there maybe some underlying data for "Mar" in the TM1 cube, how do I stop the "Mar" data appearing in the monthly P&L, so that only "Jan" and "Feb" are displayed in the report ? I still need to show the columns "Mar" to "Dec" but they should be blank.
Many thanks
Ajay
Quote from: AJAYC on 04 Aug 2017 03:00:20 AM
Hi Everyone
Looking for some assistance with a crosstab I am building using a TM1 cube as a datasource.
I'm building a monthly P&L report which simply shows the months across the top ( Jan - Dec ) and a total for the year.
The crosstab is a page within a report which also has reports based on the month and YTD. The month is selected by a value prompt.
The issue I am trying to resolve however is on the monthly P&L page.
When a user selects a month, let's say "Feb" for arguments sake, but there maybe some underlying data for "Mar" in the TM1 cube, how do I stop the "Mar" data appearing in the monthly P&L, so that only "Jan" and "Feb" are displayed in the report ? I still need to show the columns "Mar" to "Dec" but they should be blank.
Many thanks
Ajay
Hi,
A slicer filter sounds like exactly what you need here. It filters the measure values while leaving the member sets on the crosstab edges intact.
I'd suggest that if you're prompting for a specific month, you use the periodsToDate() function in a slicer member set within a slicer filter,
eg
periodsToDate([your Year level], <your prompted-for Month member>)
Cheers!
MF.
Hi MFGF
That did the trick nicely....saved me a lot of heart-ache.
Cheers
Ajay