Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 210 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations 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