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.