Out of curiosity : why are you trying to include an analysis there? Where does the info come from in the analysis? Do you store the "down time" in a DB and change it daily? Do you update the analysis by hand ?

+1'000 to what Christian said There are some basic concepts in OBIEE security and in your post everything is mixed. Also the concept of "extraction" would deserve some extra details : do you want a simple web page listing them on screen (the link you posted) or do you actually want a real extract (generating a file…

You didn't really look at the posted link, right? 3. Give information about your environment, such as versions of software you use. This is essential, as versions change and other users might run into a similar problem never knowing if the thread they read was about their version. Because yes ... there are around 10+…

And the question is? There is generally a question mark somewhere Also have a look at on some extra info you can provide which are going to help you getting a better answer.

So you got a link connecting you to an online available SampleApp (not just a OAC instance). Then it's like said before: a RPD or a session variable can only be created in the RPD. In the front-end only presentation variables can be created. You can try to connect with Admintool to the host they give you, but if they…

Ok, I'm struggling to get the link between things ... So the SR was to have a link where you could download SampleApp v607 (OBIEE Samples ) locally? And you now want to reproduce your issue there? (so inside the VM you are running containing SampleApp) You can't create a repository variable from the front-end, just because…

Hi Rebecca, Somebody is mixing things here (you or your customer or both). OBIEE 11g and 12c can't be deployed on the same weblogic, so it's impossible to have a conflict there. You talk about a proxy, so I guess your custom setup a proxy in front of weblogic to access OBIEE, but in that case you do not want rename…

Ok, we posted in the same time and you confirmed what I thought Did the support also gave you a way to connect to the RPD? You can always try the default port ... But wouldn't be surprising if they didn't understand you have an issue with a RPD variable which require RPD access to reproduce (because a presentation variable…

In addition to what Christian posted, who sent you that link? Is it maybe after you opened a SR and the support is asking you to reproduce it on the environment they sent you the link? In that case you maybe do not have access to the RPD at all but just the front-end, which would be a bit dumb if you have issues with a RPD…

Sorry but I would avoid setting "REQUIRED" there or the users from AD will never be able to login. It's actually more to make sure the AD provider isn't set as required ... A quick reminder of what the values in the "control flag" means: REQUIRED—The Authentication provider is always called, and the user must always pass…

An additional thing, which is worth nothing: we were discussing this earlier with Christian and few others, and if you upgrade to 12.2.1.3 even the VA link is correctly managed by permissions (so remove permissions and the link is gone). The main issue you can still have with that version is if you are on Window: Christian…

Sorry didn't try that ... Gaétan : Just do your "CSS cooking" in the right nice way, inside a custom style and not by hacking around default files

Isn't it nice when the Oracle Analytics team hear your question and answer you? (ok, not really but still ...) https://www.youtube.com/watch?v=TptK1mOcKL0 So VA can be embedded inside an OBIEE dashboard. Assuming you have SSO and so no login page on screen .... it can maybe works in your case too.

To avoid repeating the piece of code 2 times change the CASE WHEN <condition> to a CASE <column> WHEN <value> : SUBSTRING("Input String" FROM 1 FOR length("Input String") - LENGTH(TRIM(RIGHT(REPLACE("Input String", ' ', REPEAT(' ', 100)), 100))) ) || case TRIM(RIGHT(REPLACE("Input String", ' ', REPEAT(' ', 100)), 100))…

Hi, Data quality would be better in the DB during ETL directly ... You have the last word (maybe need to trim it .... just in case ), take the first part of the string (as you have the last word you can do a substring or left based on the length of the string minus the length of the last word), then you concatenate a CASE…

Hi, You do it like on a normal OBIEE 12c : datamodel.sh / datamodel.cmd The script is deployed on OAC (if you connect by SSH to the server) or also on any laptop/PC where you installed the Admin tool. If you use it remotely (from a laptop/PC) you need to make sure the required ports are open. With that script you can…

The good thing with Christian is that half (and more) of the time we would reply the same thing asking the same things

Hi, You title the thread "application roles" and then talk about "groups" all the time ... So are you looking for groups (which has been totally and finally removed in 12c after having been deprecated for quite some time) or application roles? What is your "BI_REPORT_MAKER" ? A LDAP group or an application role you created…

You are mixing concepts ... A webpage hasn't page numbers, page numbers exist only when you translate a web page on paper (or PDF) and that's what Asim Cholas posted above, to add page number on print. If you want to "fake" a concept of page numbers as you said it must be calculated in the analysis itself, instead of…

1704872 wrote:State: HY000. Code: 17001. [nQSError: 17001] Oracle Error code: 942, message: ORA-00942: table or view does not exist at OCI call OCIStmtExecute. (HY000) As you can see you have a nice and clear Oracle Database error: ORA-00942: table or view does not exist So, as said, your RPD is wrong somewhere ... And you…