Dynamically set report prompt

[dbomrrsm]

We are using Webi 6.5.1 and in some reports we have user prompts asking the user to select the year_weeks they want to see.

We want to set the default value in the selection box to the current year week so that week on week it increments assuming that users are usually after the current week this allows them to run the report without having to enter anything in the year week but allows them to change it if needed.

We have a database table that hold the current year week value so I could create a dimension based on this but how would I then use it as the default value in the selection box.

TIA


[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[blom0344]

The general consensus seems to be that you will need the SDK for this. You can fool around for prompts to take wildcards and use OR constructions but you cannot adjust the contents beforehand in a dynamical way.
Anyway, what the prompt will show is always a local value on the client.

The closest you can get is to build an OR construction that results in either 1/ the current year-week
2/ current year-week + additional year-week

Ties Blom