COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: wildtopiwala on 31 Oct 2014 08:42:13 PM

Title: Open Data Item from a CUBE in Report Studio
Post by: wildtopiwala on 31 Oct 2014 08:42:13 PM
Hi, I want to know, Is there a way to open the data item in Report Studio expression editor from a cube package? As you know, we can open up any data item from a framework package to change/edit the expression.
Title: Re: Open Data Item from a CUBE in Report Studio
Post by: MFGF on 02 Nov 2014 05:46:16 AM
Quote from: CognosDev007 on 31 Oct 2014 08:42:13 PM
Hi, I want to know, Is there a way to open the data item in Report Studio expression editor from a cube package? As you know, we can open up any data item from a framework package to change/edit the expression.

It depends on how you have your preferences defined for Report Studio. The default is that when you drag in something from your package, Report Studio will figure out if it is a level, a member, a set etc, and it will use an appropriate extended data item to represent this. As a result you don't end up with an editable expression. If you wish, you can select Tools > Options, go to the Report tab, and uncheck the "Always create extended data items for new reports" option to turn off this default behaviour. It won't affect existing reports, but anything new you create after this point will have expressions you can edit.

Cheers!

MF.