Posted: Thu Apr 30, 2009 6:51 am Post subject: Union Vs merge dimensions at report level
The Union, intersect, minus functionality is not available in Interactive viewer and we use interactive viewer. Since users want to create it ( it is not possible to do it in the universe), What are my options?
Is merge dimensions (report linking) an option? Is merge the same as full outer join and similar to a Union? Can a merge be converted into a left or right outer join?
How can use merge dimensions to do intersect queries?
What can I do to mimic minus queries since this is not available in interactive viewer? User wants to do it at the report level hence universe level changes are not possible.
Since subquery is not available can I do an inlist?
Posted: Mon May 04, 2009 12:53 pm Post subject: Re: Union Vs merge dimensions at report level
JOIN and UNION are not logically the same thing.
I would say your options are:
A. Get users training on Rich Client or Java client
B. If there are only a certain number of union combinations they need, have someone with the full client access create template reports and let users play with those.