Report Studio & TM1 - selection by attribute

Post Reply
fcapell
Posts: 11
Joined: Wed Jun 13, 2012 6:46 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2007
Location: São Paulo, Brazil

Report Studio & TM1 - selection by attribute

Post by fcapell » Mon Oct 08, 2012 4:55 pm

Hi everyone!

I'm working with Report Studio (Cognos Express 10.1) accessing TM1 data. Please forgive me if my question is too basic, but I'm a newbie.

I'd like to know if is there a way of selecting dimension members in Report Studio using attributes. I was assigned to create a report which will receive a date parameter. The report has to present measures for the date identified by that parameter as well as other other time periods (like 'Last Year YTD'), which can be identified through attributes defined in TM1.

Any suggestions will be appreciated.

Thank you!

fcapell
Posts: 11
Joined: Wed Jun 13, 2012 6:46 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2007
Location: São Paulo, Brazil

Re: Report Studio & TM1 - selection by attribute

Post by fcapell » Fri Oct 19, 2012 9:14 pm

Hi,

Did anyone try to use roleValue function to retrieve the value of an attribute created in TM1?

For example, I have created an attribute called "Last Year". So, I have create a report in Report Studio, put a data item containing the following expression:

rolevalue('_lastYear', [Daily Sales].[Period Days].[Period Days]->:[TM].[Period Days].[Period Days].[@MEMBER].[2012-01-01])

But the expression returns nothing.

All your thoughts will be greatly appreciated.

Regards,

Fausto

Post Reply