Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Can you show a screenshot of what you are trying to do? Are you sure the directory is correct and the file is there?
-
Try: <img src='/shared/custom/images/home.jpg'>
-
So 2.6 really means 3? As I told you, your data is a mess an you should store minutes, not force a h:mm format in a decimal number. I've already given you all the information you need, did you try it? Hint: You can also nest expressions
-
Yes, that would be even better if you have those, but the OP doesn't make clear if timestamps are available.
-
First of all, This data is stored incorrectly in my opinion, It should not be stored as a decimal number because it is not a decimal number and it should be stored in no of minutes because that is your actual grain. So, if possible, adapt your ETL to include a no of minutes column. If you have this column than you can use…
-
Can you explain why you need to use a presentation variable in stead of an 'Is Prompted' condition? Have you tried to use the 'Is prompted' condition? Did you get the same result?
-
I'm not sure If I understand the problem correctly but if you want to pass the value to another analysis through an action link then you should have a 'store is prompted' condition in the receiving analysis. That will filter the analysis on the value that you click on in the analysis that has the action link.
-
If the arrow (image) sizes are fixed one way you can do this is using a narrative visualization with HTML. See: OBIEE TRAINING: OBIEE 11G Creating a Narrative View https://pravnobiee.wordpress.com/2013/10/21/how-to-insert-image-in-narrative-view-in-obiee/
-
Hey, I found this cool new site that you can use to find stuff! You should try it: https://www.google.nl/search?q=OBIEE+R+integration&oq=OBIEE+R+integration&aqs=chrome..69i57j0l2.8143j0j7
-
Why didn't you tell you did an upgrade when you first posted this? That is obviously important information. Also the warnings may provide valid information we need to be able to help. You may have hit a bug, See: I suggest you follow Ian's Advice on this . If there's only a few joins that have changed you can probably fix…
-
Well, It didn't create itself so probably you did this yourself by accident. You can just delete it
-
You'll have to use the evaluate function for that. I think this link describes it quite well: ORACLE BUSINESS INTELLIGENCE ENTERPRISE EDITION 100: Rank and Dense Rank Functions:OBIEE
-
Not sure what you want exactly A level Based Measure always returns data at the grain (level) that you set it to. Example of how your report will look like where Sales by region is a level based measure: Sales By region is summed by region (Oracle usually uses analytical functions to calculate this). That is what you want,…
-
You should set this in the Additional Formatting Options section : Have you tried that?
-
You will have to apply a format, Like Robert already said, this can be done in answers:
-
Step 1 before attempting to learn OBIEE is making sure you understand dimensional modelling. To many people fail at putting OBIEE to good use because they lack basic modelling knowledge. You may want to have a look here for that: https://dwbi.org/data-modelling/dimensional-model/1-dimensional-modeling-guide
-
I wrongly assumed the current_query showed detail records, hence your results are not correct. The 'By' is used to group by items, in this case Employee ID and HireDate. So it counts all the records in the result set that have the same employee Number and Last hire date If Position Description is always different among…
-
Try to add a filter on COUNT("Fact"."Employee ID" By "Fact"."Employee ID" , "Fact"."Hire Date" ) > 1
-
There should be a button to mark the question as correct. Not sure if you still see it after you already marked my answer as helpful.
-
In the Criteria section select Edit Analysis Properties (the XYZ button). In the popup select the 'Data' tab which brings up the following options: