Hello, I'm trying to filter on Months Attribute. Using report studio and querying against TM1 cube. We have an attribute called ForecastMonths with values of 'FM' or 'Act. This tells me what months are forecasting data or what month is Actual data.
I've been searching high and low to see if I can filter on a months attribute to only bring in FM or Act. Is there a specific function that calls an attribute?
Thank you
I'm a little confused by the way you're describing it. Can you paste a screenshot of how the dimension appears in RS?
It sounds like you have a hierarchy containing two members, FM and Act. If this is the case you should be able to just drag one of them into the query slicer.
If you say you have the attributes set. Then the attribute must be available under the Dimension > Hierarchy, same level as "Members" folder.
You can directly use them.
Thanks for the replies...I'm totally new to this. I'm trying to filter on the ForecastMonths for ACT or FM. So the first is the dimension in prespectives. and the second screenshot is from FS.
so you cannot see the ForecastMonths attribute in your cube source? Should be the same level as the folder named "Members".
TM1 cubes by default don't have named levels. In TM1 Architect there should be a setting somewhere to enable named levels. Set that and you should see the attributes in RS.
Then you can create a data item like:
filter([Cube].[Dim].[Date Hierarchy].[Month Level],[Cube].[Dim].[Date Hierarchy].[Month Level].[Attribute]='Whatever')
Thank you for the replies again. I see what might of happened. I was trying to build a report out of package that our consultants made. I created a new package and now I have everything I'm looking for. Wouldn't of got that without your help. Learning on the fly!!