Well, sqlplus has its own dedicated connection, OBIEE use connection pool shared by other things in your system, that's why the info in the logs can be not correct because of the way it's measured and it really depends on what else is happening on your system, how your "pipes" between OBIEE and the DB are setup and also if…

Hi, Honestly don't even try to compare a command line thing with OBIEE ... Can you just imagine how many steps OBIEE execute for a query more than sqlplus? I would suggest to make a proper analysis of what happen when you run your analysis: https://www.youtube.com/watch?v=0W34l2O9GMo And don't try to compare incomparable…

Hi, If you expect to find a "pleaso_go_fast_AGO" no luck it doesn't exist ... 3016375 wrote:It seems to be the main issue of bad performance. Actually it would be better if you clearly find out if it is or not the main issue, because having the feeling it is to find out after 2-3 days of tests of possible alternatives it…

As Christian already said you can use a) because if not in-line prompt ( b ) it will not disappear. And your actual column in the prompt section can only display the values of your column: so if you don't have a value "all values" it will never display all values because it's not a filter and it's just about showing or…

Yes for the AD string, for the other one it's not remove the Authenticated User app role but remove it as member of BIConsumer. As you see in this screenshot BIConsumer has 3 members : BIConsumers (a group coming from a LDAP), BIAuthor (an application role), authenticated-role (another application role). You simply edit…

Hi Robert, This happen because in the AD authentication provider you just point on a high level branch of your AD containing all users and don't have any extra conditions to prevent every user to login. What you see (app roles assigned to these new users) it's because of the "authenticated user" application role. This is a…

Hi, For purely Informatica questions an Oracle forum isn't probably the best place. Informatica is not an Oracle product, it's was just packaged into OBIA as the pack required an ETL, in current versions of OBIA Oracle moved to their own ETL: ODI. So there must forums about Informatica on their site I imagine ...

You can also just add a count on one of the keys and that is your measure. In your tables there must be something countable or that can be aggregated, if you don't have anything you can't really do analysis but just reporting on your data.

Well ... You must define a measure somewhere as the BMM must be a perfect star, so there must be a measure and dimensions linked to it.

Hi Robert, I couldn't try your scenario (lack of time), but I have projects where I used a partitioned FACT table and just that, nothing else is partitioned. In other projects I have some dimensions partitioned and only that and finally other projects with a some facts partitioned and some not, some dims partitioned and…

But fragmented by what? What is the fragmentation rule?

Hi, First I would like to say AGO working with fragmentation (there some limitations but it would mean you have a really special fragmentation rule). You can just model it in the RPD to have some extra LTS returning you the previous month data (changing the join between the fact and the calendar table).

Hi, 12c changed all these things, forget the 11g way of doing things. The RPD file itself doesn't exist anymore, this is because of the coming support for multiple RPD etc. so they had to change things. 12c introduce the BAR file: it contains RPD + catalog + security, the migration JAR create a BAR file for example and you…

Well ... that's how it's supposed to be I would say ... On the screen you see the result of your JS because your browser execute it, for the export OBIEE doesn't take the content from your screen but process it directly on the server side, so they implemented methods to render colours and formats but they didn't implement…

Mmmhh, is that a question? It isn't really clear what you expect from this thread ...

Hi, You are trying to connect to the DB using the "weblogic" account? There is no "weblogic" account in the database... Have a look at the doc of SampleApp to see the existing DB accounts you can use to connect, but it's 100% sure that weblogic doesn't exist at all in the DB (it's only a Weblogic / OBIEE account). What are…

If I was you I wouldn't play with Oracle licenses agreements ... they are quite good on that ! So yes, you have to download all files, extract all files to get the virtual disk. I guess you can probably invest few minutes of your life to do it knowing Oracle give you that for free. Asking to upload and share it means…

The only place where you can get the SampleApp 506 RPD is from the SampleApp 506 itself: http://www.oracle.com/technetwork/middleware/bi-foundation/167534-v506-copy-2798097.html As you must accept some licenses agreements you can't get it from other places.

Well ... as your is the server install version not sure if it really works in a different way ( didn't installed OBIEE on a Windows server for 4-5 years ...). My shortcut of the client only install is: "C:\Oracle\OBIEE 11.1.1.9 Plus Client Tools\jre\bin\javaw.exe" -DnoJNI=true -jar startup.jar and it's started in :…

Hi, You mean this Catalog Manager here ? Because if this is the one you try to run I'm not really sure if you are using the right way to run it ... Your shortcut in the Windows menu must be something like ...\javaw.exe" -DnoJNI=true -jar startup.jar (for OBIEE 11.1.1.7 or 11.1.1.9, only in 12c it is something like…