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
Pls Help me
Have you tried running your target report(report studio report) with the input value 20110315 and checked if it is OK?
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.