Skip to Content
0
Former Member
May 27, 2008 at 06:01 PM

Using queries from another universe in Webi; Functionality currently works in Deski

27 Views

Post Author: ck1938

CA Forum: WebIntelligence Reporting

I have a report in deski that was built using 2 queries and 2 universes. One query is from a calendar universe since there is no calendar information in the reporting universe. In deski I have the option of selecting the operand Select Query Results (All) and using the calendar universe to build a filter in the reporting uiverse that uses the results found in the calendar query to define a start date in the reporting query. I'm trying to automate the report in Webi but am having issues since the operand is not available. I only have the options for Constant, Values From List, Prompt, and Object. Object will only give me objects in the reporting universe. It apparently can't see the calendar universe query. I've tried writing some sql statements but have had no luck so far. Does anyone have any guidance they can offer.