Default value for value prompt

[Ammus1234]

Hi All,

I have a table with user login and 'report by' value. The 'report by' value must be the default value for a value prompt, when that user runs the report.
Is there any way to achieve this? Any input will be highly appreciated.

Cognos version: 10.2.1
Database: SQL server

Thanks in advance

[bvk.cognoise]

Hi Ammus,

As per my understanding you want to pass a default value to a prompt .To do this

Select the value prompt in Properties there will be an option called "Default Value" click there and then give "report by" as a value.So that when ever your run the report it automatically takes that value as default selection.

If i misunderstood your requirement please elaborate your requirement.

Regards
Bvk

[Ammus1234]

I want to change this default value for each user. Basically the default value is dynamic.

[bvk.cognoise]

Hi Ammu,

PFA XML .I have developed this with sample 'Gosales (Query) 'Package.Please open this in report studio  and see the output.Please let me if this is what your looking for.


Regards
Bvk

[Ammus1234]

Thanks for your help bvk.cognoise.

I think I haven't explained my requirement correctly.

I have a mapping table for each user with a default value for a value prompt.

Eg:
User    default value
abc      country
def       product

When user abc runs the report he sees country as default value in the value prompt and the report gets run for country.
When user def logs runs the report he sees product as default value in the value prompt and the report gets run for product.

The backend is SSAS cube and the report is built on this.
I have full control over database, cube and report so any solution will work.

I have seen some examples on making the date default. But creating an MUN with a value from database seems to be difficult.
I have also tried to add dataitems to the package (relational) and tried to get the default value. But nothing helped as of now.