Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
When you say "it hangs" , it suggest to me that the report might have too much data and that slowing down your browser's response time. I would try to limit data and try again.
-
What are the prompts you have in dashboard. Make sure that the column filters in the analysis not replaced by dashboard prompt. Check if filters are "Protected" whenever required. Thanks Arijit
-
You can have 9 graphs displayed in 3 rows. Have 3 similar(related to check box) graphs in each rows in a section. Display a particular section based on checkbox value. i.e. When check box 1 selected only one section is visible. For check box 2 , 2 section will be visible. This way the look and feel will be consistent.…
-
Do you mean the space between X axis and Feb'18? That should be dependent on the value of Feb'18 for yellow line. My guess is the red dot is from another value that has only 1 value in Feb'18. Put the values in a table, you will see it. Thanks Arijit
-
If you are looking for something like this with D3 ...I have shared the code here ... Oraculam: Take your OBIEE graphs and charts to new level with D3
-
More on this you can read here Doc ID 2352581.1
-
I am wondering if this is related to cache setting. Can you check what value being present in the OBIEE instanceconfig.xml (location = $DOMAIN/config/fmwconfig/biconfig/OBIPS) file. make sure the "RefreshIncludeBIServerCache" variable is true in the OBIEE instanceconfig.xml file <ServerInstance> <WebConfig> ... <Cache>…
-
EVALUATE('regexp_replace(%1,%2,%3)' AS CHAR,"Cost Center Attribute"."OWNER",'[[:punct:]]','')
-
You need to provide more information on this as Joel said before. Like, how you are drilling down on the report. How your report looks like. What evaluate formula you are using with your database. If the evaluate formula in the formula section of the analysis or in the filter section. etc etc. When you use evaluate you…
-
I am not sure if the question is about filtering Year or orientation of X axis. If it is about filtering Year, then you can add another year column in the analysis. Add a filter on that column. Hide the column.
-
I have seen this in (OBIEE 12C) direct connection. This is a bug. You change something in the editor and click save. go back , it goes away. So, what I do is after adding something in the direct connection editor , I change something else(like column wrap text, etc) and save. Change it back. Try that trick Thanks Arijit…
-
Horizontal axis in obiee has option to change the level orientation.
-
Is it running in a dashboard? or just analysis ?
-
Try this £#0 ; £(#) To Set the color RED you need to use conditional formatting.
-
Robert Angel 's answer , I read it again. You can do what Robert said, but that will show 1 empty line. Other option is using selection step to eliminate null Service value. More about that is here... https://docs.oracle.com/cd/E28280_01/bi.1111/e10544/filter.htm#BIEUG131 Thanks Arijit
-
Have a filter on Service column thats says "is not null"
-
In column formula add something like Count("Column Name" by "Column Name") and also add the column. Then use pivot table. Example...
-
I was able to make it work(though not consistently) when there is no measure columns. Seems like OBI sends sum, avg etc first before the columns. So, solution in the blog only works for selected cases not always. So that gives you 2 choices. 1. setting a alias table for the physical table and set hint on it. In that way…
-
Can you copy that logical SQL and change the column position to make the hint column as first column. Then try to add that back in the advance tab(New Analysis). See if that helps. I will play in my environment to see if I can make that work. I have always added parallel hint in RPD. I will get back to you. Thanks Arijit
-
Check this blog section 1.3 if this helps. Let's OBIEE: Using Hints in OBIEE RPD and Answers Thanks Arijit