Error when using Prompt

[masilabalu]

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.

[vijayab]

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