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…

I hope for your it's already the right subject area as it would just take 2 minutes The "UNION" is still a front end thing, but I really would suggest to avoid it as you end up with many more issues in the end (losing things like drills etc.). If it isn't in the subject area but in the business model (inside the RPD) on…

Hi, As columns can't be added to a dashboard or a page I guess you mean that you want to display them in the analysis you have on that page? If they are part of the subject area used by the analysis no problem, just add them. If they aren't you would end up doing UNIONs to add these columns from another subject area and it…

In addition to what Robert posted (which is the right answer) : you bought OBIEE, so at some point you do things in a OBIEE way and not what somebody put on a paper with no idea of the available tool. You can the same functionality but it is a drop down menu and not a radio button ... If you really need a radio button…

A blank page is often not so blank ... Is the page really blank? What's the URL of the page? If you analyze with the developer tool the various redirect of the login process where does it stop? That's just few things you can look at and give you a better view of what you have in front of you

Must be a statement as there isn't any " ? " in the post And if it was a question I'm sure @3463828 knows and would ask it accordingly

Ok, so your question is different: not the maximum size of a name, but the maximum visible size. And the answer is : there isn't an answer as it depends on the user ! Depends on the size of the browser, depends on how many other things needs to be displayed on the same row. If there is enough space OBIEE will display…

I'm not really sure there is a hard limit which you are supposed to hit if you want your system to be usable ... Writing a 2000 words dashboard name just make it unusable. Did you hit a limitation? What "size" are you looking for?

Dumb question but ... The connection pool allowing you to see data does really use a TNSNAME? Because it maybe has the full connection string defined, which explain why it works

Catalog Manager and archive the catalog. Then you can still zip the file if you want but at least that's the easiest way to get part (or full) catalog and move it around.

SasDutta wrote:I am using 12.2.1.1.0 version of Admin tool. SasDutta wrote:Yes, my admin tool version is 12.2.1.0.0. So you have 2 installs or just one and it's the 12.2.1.0.0 ? Your Admintool version must always match the server version, so yes, you need 12.2.1.1.0 Admintool to work on a 12.2.1.1.0 server. You can have…