Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Math operations in result column of a UNION (combined analysis)

I need to know a % of UNION result, for that I added a column result to UNION operation. If i only select that it show me one column and it Works perfectly but when i try to make math operations the result is incorrect.
Can i make math operations in result column of a UNION?
Answers
-
-
Passing the UNION from the presentation server to the BI server is about the most inefficient and least functional way to do things. Try changing the logical and/or/ physical data models to achieve the requirements -- the use of information drives the model (both logical and physical) design.
BUT here's how one person was able to do some simple calcs with UNION in Answers: OBIEE in IL: OBIEE - Calculation between results of a union
0