So you have a question about a chart in an analysis (instead of a graph in a report). You need an analysis showing the total number of opened "things" (UT tracks analysis executed or pages of dashboards). Next to that you want a bar chart showing analysis by what? What is your Y-axis?

First thing first: this is not a graph, it's a chart (sorry, spending lot of time on Graph Database I'm a bit pedantic on this one ) I believe Christian gave you what you are after. Steelbird wrote:Is there a way that I can restrict to display 2013 Q1, 2013 Q2, 2013 Q3, 2013 Q4 only once during the start of the quarter. If…

To enable them "easily" there is another way: https://gianniceresa.com/2017/03/scripts-to-use-agents-in-obiee-12c-mass-enabling-and-execution-from-a-page/ You can enable them in a click without having to deal with database table content export/import. So you can start with a clean state.

3808468 wrote: Is it compulsory to move OBIEE 11g scheduler tables data in to OBIEE 12c.? As Joel said you don't need to migrate anything which wasn't migrated by the migration process. Why would you want to migrate the scheduler tables content? Do your agents have some "smart" logic checking on their last execution…

You got the "Oracle" reply in the other thread in MOSC: Is Microsoft Edge Chromium certified for OBIEE 12.2.1.3? Practically Edge Chromium share the same core as Chrome (that's also why Chrome extensions can be installed in Edge Chromium), which means it must to work and there is no reason for Oracle to not certify it at…

mchorazy wrote:Must I set something else? Something else? What did you already set? Isn't this just the exactly what you asked in Error with start obips1 service ? You don't have to open a thread for every message you want to post, you must keep replying into the same thread if it's the same issue and still you are trying…

If you get rid of one of the PERIODROLLING calculation, you can just use the one PERIODROLLING you are left with and it will work. You can achieve the same result as PERIODROLLING by modelling a join not with fact.date = date_dim.date, but as a BETWEEN. In this way the joins will return a PERIODROLLING value by default…

It isn't calculating the reverse difference, it is just doing what the function is supposed to do. By using it as you did, you will get the number of days between OPEN_DATE and ACCEPTED_DATE, and that supposed that OPEN_DATE is an older date than ACCEPTED_DATE. Thanks to the fact that an Oracle database can use…

Hi Joe, You will need to do an extra effort ... First by being explicit on the product and version (OBIEE and Publisher are packaged together while being 2 very different products). Joe Choueiri-Oracle wrote:... for some reason I am getting the total number of orders, basically, the filter is being ignored.Any idea? No…

Answered the same thing 2 days ago: Turn rows in columns or filter columns by another column

Set an aggregation rule at the column level into the pivot view for "value" and it works. If you know all the possible values of "type" you can create as many copies of "value" as needed and add inside a CASE WHEN condition to display the value only if "type" is = to every single value. With this you can keep your table…

Use a pivot view instead of a table view.

Sangeeta Pandey wrote:This OBIEE repository will be part of DB server and can be different than OBIEE server. OBIEE server will connect with DB server to access metadata reps to refer these metadata? No, the import is a real import. But only an import of metadata. More than an import you can see it as looking what the DB…

Sangeeta Pandey wrote:import metadata through Connection point at physical layer of RPD, I guess it brings the object from DB server to OBIEE server? It's called "import metadata", therefore the only thing which will be retrieved is metadata, no data will be moved.

Sangeeta Pandey wrote:transferring objects to physical layer is taking a great amount of time. I selected only 5 tables and waiting for last 1.5 hours to get it transferred. Nothing is being transferred! The menu is called "import metadata", not "import data" or "transfer data". Only metadata is collected, nothing is…

Hi Sangeeta Pandey wrote:1) I can see 2 connection points at RPD, OHI Analytics CP and OHI Analytics Language CP. Why 2 different CP required and what is purpose of each? Your RPD is yours, nobody else has the same. OBIEE comes with an empty RPD. Therefore it isn't possible to tell you the meaning or reason for those…

If you check MOS or even just Google, one of the first hit will be the DISPLAY variable. Maybe somebody had it set when restarting OBIEE and that's your issue? It's generally the first thing to check when no charts is visible in OBIEE ...

Weblogic is supposed to encrypt the password the first time it will open the boot.properties file. Try the "simple" one first, just replace the content of the boot.properties file (they are maybe 2, just check the folders searching for those files and check what they have inside and update all the required one). Enter your…

Aggregate using COUNT and sort that counting column in descending order.