Hi, So I guess you figured out it is possible, meaning there isn't a hardcoded limit to 25K rows or so. If you still have issues and limits (not seeing all your rows) just search here in the forum as there is around a post per week on how to set weirdly crazily high limits in terms of rows and cells. It isn't a single…

Hi, All you have is 2 RPD, the merge must be done by the Admin tool. No idea how the 2 RPD looks like but you have a big risk that they share common names as it's the same product (even if 2 different version). Names conflicts means lot of work by hand to resolve the conflicts or rename one of the 2 to avoid the conflicts.…

No, it isn't: http://www.oracle.com/technetwork/middleware/bi/biapps-11-1-1-9-2-2527682.xls It will never be I would say. For ODI 12c there will probably be a new release of OBIA (so maybe a OBIA 12c something).

A logical column formula isn't a SELECT LSQL. A logical column is attached to a logical table, a logical table has one or many logical table sources. The logical table source define the mapping between a logical column and a physical table or between the local column and another logical column. There isn't any SELECT ...…

Ok, so for Publisher in 11g it's maybe also related on the security implementation. For the header/footer of OBIEE I don't guess you can hide them, so your better option is the one Sherry George suggested (and the linked blog too): the GO url. Because it's an OBIEE (/analytics) link it will accept your nQUser & nQPassword.…

chillychin wrote:Im not privy to 10g, but I do see in the 11g enviroment that it did work for /xmlpserver - At least in my enviroment Interesting, I'm kind of sure Publisher wasn't cooperative in 11g That's why it didn't shock me that it doesn't work in 12c, and it can even get worse if you enable the "fake" SSO to not…

chillychin wrote:I am assuming that since the OBIEE 12c URL works, something similar should work for BI Publisher Your assumption is wrong. It always worked only for /analytics, from 10g already if not wrong. It never worked for /xmlpserver (Publisher). Publisher in OBIEE 12c (like in 11g) uses the OBIEE (fusion…

Aren't "Fact - Purchasing - Invoice"."Non-Compliance Spend" and "Fact - Purchasing - Invoice"."Compliance Spend" measures? Because they are called "Fact" but you do a SUM without setting any dimensional attribute (using "by") or by using an aggregation at a different level. So it sounds a bit strange to me and could…

What version of OBIEE? The chart related to the pivot doesn't like when you change the format to line in the XML, by default it makes all bars and the last measure a line. If you want to have the option to configure what is what (line and bar) you need to have a real chart by itself. You seems to say that in that case your…

The word "real time" not being mentioned but talking about "daily BI" OBIA is still a perfect match, but as said not worth the cost and work for just "few reports". OBIEE isn't aimed at star schema design, it is for any kind of data structure you have. Star schema sources are actually boring in OBIEE because there is…

As extension to AH R answer, there is actually a model but it's a different solution: OBIA (Oracle BI Applications). It comes with ETL and its own database warehouse model where your EBS data will be loaded by ETL and then the prebuilt RPD and analysis are based on that. Definitely not what you look for if it's just for…

And the limits of custom VB scripts is it only works on Windows installs. For a script working on all the OS on which OBIEE can be installed Java (EJB) need to be used.

Hi, Did you looked at Publisher? It does that out of the box without needed any weird script ...

Hi, Things start in the wrong way ... is for OBIA, Oracle Business Intelligence Applications. EBS can be a source for OBIA, but this forum is for OBIA, not EBS. So asking in the wrong place doesn't sound like a good start ... More in general the official certification page provides hints on the material to be used to…

Hi, look into CSS, it's your best option to turn the text. More in general OBIEE <> Excel, so there are things done in a different way ... PS: if the export doesn't rotate text it's perfectly normal because of what just wrote above.

If you are talking about the RPD it can be developed only with the Admin tool, and the Admin tool is a client tool for Windows only. It works on the main Windows OS desktop versions (7 to 10 if not wrong, maybe also some server version but for that I would suggest to check the certification matrix first). When you then…

Hi André, welcome For 1) I would say because that's what 95% of the users needs OBIEE try to find out which column goes where and place the columns in the various components of a view (prompt, sections, axis etc.). For most of users this just require 2-3 operations to move things in a different way and it's done. In your…

As said by George: https://dimensionality.ch/2017/05/06/installing-oracle-bi-on-windows-7-8-10/

It depends on your security setup. If you use an external authentication provider the list of users isn't owned by OBIEE. The groups/role also depends on your security setup. It can come from the external provider or from a database table etc.

Hi, You are facing a normal and expected behaviour .... The usage of "FILTER ( Measure USING Base Line Col = VALUE )" prevent OBIEE to pass these values when navigating because that filter isn't defined at the level used to navigate (row vs cell). If you add all the values in the URL it must work, how did you built the URL…