Hi, Nope, prompts (in all the views: table, pivot, chart etc.) are single values only. To have a multi choice list you have to switch to a "full" prompt (dashboard prompt for example) and filter your analysis by it.

Hi, "deeplink" don't exist in OBIEE and therefore no answer for 1-, 2- and 3-. Maybe it's worth asking that in a OTBI forum?

Good question ... I find the info about instanceconfig.xml in the XSD file defining all the allowed tags in instanceconfig.xml (I was looking at a 12.2.1.1 version, I don't think it changed in .4), you can see a screenshot of the part about the secure flag below. So instanceconfig.xml will accept that setting. The unknown…

Hi, Did somebody run a security scan/audit on your OBIEE and they gave you a long list of things being "unsecure" ? 3808468 wrote:the web application sends non-secure cookies over ssl in obiee ? What is a "secure" cookie for you? If you mean the "secure" flag of the cookies being set, you must also know that this doesn't…

If you are after what Christian guessed (restrict access to that URL), the question is: why? That URL doesn't give you anything, it's internal cooking of OBIEE, nothing you have to care about. Next you will ask how to prevent access to every single icon picture and any other "static" file like CSS and JS? Don't confuse…

As Christian said that's called Master-Detail in OBIEE. I would just question the choice: a pie chart? You don't want that, trust me! Your pie chart looks great when a user open only 3-5 different analysis/pages, it will be totally useless with more than that and just a nightmare for a user who opened 20-30 objects. If…

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…