Another Problem w/Cascading Prompts

[samiam07]

Using CRvXi-R2, BOXi-R2
I’ve been trying to get dynamic cascading prompts to work. The example from BO uses the customer tbl in the Xtreme sample db. They have a dynamic cascading parameter using the country, region and city fields and it works just great.

Then I tried this:
• Create a rpt using Customer and Orders from Xtreme. They’re linked on the Customer ID field.
• Create a dynamic parameter using the customer name field from Customer and the order id field from Orders.
• Drop this parameter into the Report Heading section and run the rpt.

I keep getting an error “Prompting failed with the following error message: ‘List of Values failure: fail to get values, [Cause of error: Failed to retrieve data from the database.” And then some more stuff about db vendor code -3079.

If I create this same scenario with a SQL command it works the way I thought it should. However, commands can’t be used in combination with universes or business views. Using the business view manager and LOV’s also gives an error.

I’ve searched through the threads and this issue seems to come over and over again.
Has anyone work out a solution? Suggestions?

 

[synapsevampire]

I guess I'd like to know what you need as opposed to working with the sample database. I tried the same thing using CR XI and SP 2 and it works fine here.

Universes and Business Views can be based on SQL, which is what SQL Commands are, although the complexity of each can be quite different, so please post specifics of what you're trying to do, but first make sure you've applied the service packs as something is amok with your install I fear:

http://support.businessobjects.com/downloads/default.asp

-k