If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Drill through from Analysis studio to Report Studio

Started by jahnavi, 22 Mar 2011 01:51:23 PM

Previous topic - Next topic

jahnavi

Hi Friends,

I have created a cube based on Iqds from FM. My cube has time dimension,error dimension and few other with one measure

In Time dimension I have Year,Quarter,Month,day

I am able to pass Year,month,day from analysis studio to report studio

But I am facing trouble ony for Quarter

My  Quarter Values are

20110301-20110331

Its like that

In My report I am using a filter where [date] between 20110301 and 20110331

the value in date column is 20110315

when I am running the report from analysis studio to report studio. the report iss giving me blank. If I clicks quarter in analysys studio.

Please let me know any wrong


jahnavi


PRIT AMRIT

Have you tried running your target report(report studio report) with the input value 20110315 and checked if it is OK?

MFGF

Typically you would need to filter your target report on a single parameter for time in order to pass values from AS.  An example would be

[Your date column in the database] in_range ?your date param?

Regards,

MF.
Meep!