Semi-dynamic prompt?

building semantic layer
1

I currently have a dynamic cascading prompt consisting of three values.

Prompt1, Prompt2, Prompt3. Currently you select a value for Prompt1 which filters what you can select in Prompt2 which then filters what you can select in Prompt3. This has normal dynamic cascading prompt behavior and was written using Business View Manager.

The report developer now wants Prompt1 and Prompt2 to not have a list of values, but make the user enter a single value for them. The report developer still wants the list of values for Prompt3 to be filtered by the values of Prompt1 and Prompt2.

The restrictions that I am working with are the report is a Crystal Report. It is accessed through InfoView by one group of users. It is also access through a web application by a different group of users. The values for all three prompts are passed in from the web application and therefore need to be accessible via the BO Webservice API. The prompts must also be accessible through InfoView.

I have tried several different approaches in both Business View Manager and Designer with no luck. I can build either Conditions or Objects for Prompt1 and Prompt2 in Designer but when I create an object for Prompt3, I get message “Failed to retrieve List of Values” when I click OK on the Query Panel. If there is a way to modify the dynamic cascading prompt in Business View Manager so that the first two prompts are only for entering a value, I can’t find the property settings for that change. I can’t use the nested prompt functionality that Designer uses because all of the prompts need to be accessible at once.

Any ideas anyone?

2

I logged a case with Business Objects on this issue. What they told me is that what I wanted to do was not possible. Dynamic prompts in Business View Manager must all be dynamic by design so you can’t combine them with static prompts. The only option they could offer was to schedule the list of values to be refreshed in Business View Manager. This may be tricky for us as the database is a replicated database from a transactional database that is updated frequently.