Hi All,
I am creating prompt using static choice, in the use value i put formula like
[Report Layer].[Run Date Hierarchies].[Year-Month-Day].[Year]=?JobRunYear? ,
[Report Layer].[Run Date Hierarchies].[Year-Month-Day].[Year]<>?JobRunYear?
this 2 working....
but i try to put
[Report Layer].[Run Date Hierarchies].[Year-Month-Day].[Year]>?JobRunYear? this is not working its return the error, i attach the error.
pls help me this...
Thanks
Balu.
Hi ,
Plz go through the doc given below.............................
Description:
In a cross tab report against an OLAP data source divide a category amount by a number in a parameter.
For example, in report showing the revenue and having the products as column and the sales territory as rows, divide "Northern Europe" by the number quarters selected in a parameter. If 2 quarters are selected, divide by two, If three, divide by three.
The parameter is populated by static choices.
An example query item:
[Great_Outdoors_Company].[Sales Territory].[Sales Territory].[Sales territory]->:[PC].[@MEMBER].[7199] /?SouthernEuropeRatio?
Error Message:
QE-DEF-0480 The operands of '[Member]' / ?parameter? cannot be converted to consistent dimensional object.
Environment:
Using an OLAP datasource. Cognos 8.1 BI lets the original report run.
Root Cause:
Stricter validation in 8.2 and 8.3 gives the validation error.
Solution:
Set the parameter to be in a macro:
[Great_Outdoors_Company].[Sales Territory].[Sales Territory].[Sales territory]->:[PC].[@MEMBER].[7199]/#prompt('SourthernEuropeRatio','token')#
Related documents:
Chapter 4 of the Framework Manager user guide covers macros and parameters.
KB 1027950 : How to dynamically determine and display the previous and current Month and the variance in a cube
Thanx
:)
vij