I have created a WEBI connected directly to a BEx query in BI 4.0. When I refresh the WEBI, I am prompted with the BEx variable and the data is refreshed correctly. I added that WEBI to Live Office, but it does not prompt me with the BEx variable. I only get the data that was last saved in the WEBI. Is there anything special I have to do to get the BEx variable to prompt me in Live Office 4.0?
No I didn’t, sorry don’t know how to do that but I did create a universe ontop of the BEx query and the prompts are now working but my hierarchy from the query is now being displayed differently.
(BOB member since 2009-04-02)