Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 49 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 286 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 110 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
OBIEE - excluding file type extensions on a dimension table
Hello,
I am creating an analysis - I want to exclude certain file extensions: .jpg, .htm, etc. I have tried using the filter method in the criteria but does that give me that option. Are there any best practices to go about filtering a dimension prior to generating a report?
Thank you,
Andrew
Answers
-
RIGHT('elephantridingmotorcycle.jpg', 4) is equal to/is in .jpg;.gif;.png;.htm;.omg
^-- this
0 -
@3427784 Did you give up on this? For the benefit of other forum users it is courteous to finish your threads. Sharing goes both ways.
0 -
Hi Christian, sorry for the late reply, busy on this end. I believe I pretty much took your method using the filter and filtering out the column to exclude the mentioned tag above.
0 -
So it works? If it does - all the better. Just close the thread please so that other forum users can benefit from it.
0 -
Not a "Like". Close the thread :-P
0 -
Sorry Christian, I believe it is closed now! Marked it as answered. Thanks again!
0