Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 19 Oracle Analytics Lounge
- 222 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 83 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Add division parameter to OTBI Report
Answers
-
Hi Trent,
Please follow the below steps,
Add a new column to the analysis (It can be any column from the subject area)
Click the Properties button & then click on Edit formula
Copy & paste the expression which I have provided as per the below screenshot (i.e SUBSTRING('450.100.16300.7500002.000.00000' FROM 5 FOR 3)
**Replace '450.100.16300.7500002.000.00000' with the actual column name.
Click OK to come to the analysis workspace.
Hope this helps, please let me know if you have any further questions.
Regards,
Sovi
0 -
Thank you Sovi. That worked great.
Appreciate your help with this!
Trent
0 -
Hi Trent,
Glad to hear it worked for you & happy to help you.
Regards,
Sovi
0 -
Hi Trent,
From where did you got the Department column in the "Expenses - Expense Transaction Real Time" Subject area. Please share your thoughts.
Appreciate your help.
Regards,
Ajeez
0