Page 1 of 1

Report Studio & TM1 - selection by attribute

Posted: Mon Oct 08, 2012 4:55 pm
by fcapell
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!

Re: Report Studio & TM1 - selection by attribute

Posted: Fri Oct 19, 2012 9:14 pm
by fcapell
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