It's difficult to tell you something precise as the concept works, the theory of dimensional modelling too. So ... try to keep it simple: practice with just a mini-star being that and find out how to make it works, then you can integrate it with your existing model.

Hi, This is generally known as degenerated dimension as it's mainly a fact table containing attributes than the opposite. But it end up being the same thing in the end. It must be modelled using the object twice to have it as dimension and fact as well. Not sure why you set the content levels to Total and for what, so you…

Hi, As a fact table must not have attributes inside but only aggregated columns (that's the theory of a dimensional model) then your idea 2) isn't really a good idea Which means you are left with idea 1) Depending on the relationship between NC Type and shipping you maybe also can use 2 separate fact tables defining…

As OBIEE isn't an opensource tool there isn't a public available recipe on how the IDs are cooked. But as Christian said they are generated when you add the columns in the analysis, their main usage is to uniquely identify columns in the context of the analysis itself. It doesn't look like these IDs are used outside the…

As it's part of the same functionality (go to the beginning, go to the next 30, go to the prev 30 and load all) not something you can enable with a checkbox I would say. Is that only for a unique single analysis or more something generic that you don't want to see that "load all" arrow never again?

Well ... what Christian said You use the 2 system variables to reference the user credentials and use that in the connection pool for the DB. For the first part it's about integrating your AD with OBIEE, the doc cover that as well as ton of blogs.

Martin van Donselaar wrote:I'm pretty sure you will not impress your client with a demonstration that you didn't even make or do yourself. I'm even less sure if he will impress the client with a video of a demo using a tool he has apparently little idea about, but that's a different topic @2693347 : get yourself a copy of…

user8465380 wrote:Yes, your understanding is correct. We want all the user should use their own credential for authentication and further able to create report, view report etc.. based on their OBIEE application role and acesses provided. Actually this part is a bit confusing ... Keep in mind the various layers where…

From the doc: Select this option if you want all users whose queries use the connection pool to access the underlying database using the same user name and password.If this option is selected, then all connections to the database that use the connection pool use the user name and password specified in the connection pool,…

You need to keep in mind that this thing is a piece of code ... < = < > = > And you are also supposed to remove the doctype, html and body elements as you are already inside a webpage. You maybe want to git familiar with the basics of HTML and javascript. Or look inside Sample App (OBIEE Samples ) which has examples of…

Well, a CASE WHEN is just a condition. CASE WHEN '@{pvMyVariable}{#DEFAULT-VALUE#}' = 'Your value for col 1' THEN "your table"."your column 1" ELSE "your table"."your column 2" END The difference is that the values of the radio button are more "friendly" than the real name of the columns. But it's the same thing in the end.

Hi, You aren't providing enough info to get an answer: Is your install certified? (right version on supported OS) What does the logs tell you?

Well ... it does have it: TO_DATETIME('string1', 'DateTime_formatting_string')

Your examples is weird ... It works except for the end: 2017-01: billing = NULL, to date billing = 25 2017-02: billing = 35, to date billing = 40 25 + 35 is supposed to give you 60 as to date billing for 2017-02 So if you explain how your to date can be 40 instead of 60 then it will be possible to solve your question.…

2969185 wrote:Can you list some other limitations? Any single kind of interaction where the chart would change or react to your interaction. You know there is a mobile app (iOS and Android) for mobile devices, right? https://itunes.apple.com/us/app/oracle-bi-mobile-hd/id534035015?mt=8…

I'm not sure the wizard support variables, so in the wizard replace the reference to variables "VALUEOF(...)" by the value itself. Once imported you can switch back to variables if you want, or just copy/paste the imported objects in the existing database if that's what you are looking for.

No, that's not how the product works for now. There has been something similar announced when 12c was about to be released, a concept of pluggable BI, but it isn't coded or available now. So 1 OBIEE instance = 1 RPD for any OBIEE version (12c, 11g etc.) You can of course merge your multiple RPD into a single one. If you…

Good luck, and remember that the columns when they are there they can still not work because joins are missing or content level isn't set right ... That one will be the last minute surprise

Not from a Subject Area to another, from the "Core" business model to the subject area Keep in mind it still doesn't mean it will return you the required data, but the tool will let you do it.

As far as I remember OBIA has a single huge model, so with some luck your new columns can already work in the analysis where the users ask them (otherwise it's a different thing and ... it will require lot more work). Quickest option would be to drag & drop the 2 columns in the subject are you want them inside. If the…