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…

1704872 wrote:I have just finished creating a new .rpd file and uploaded it the BI server....the from clause in the sql query generated is wrong I have a bad news for you: your RPD is wrong. OBIEE will never guess or imagine anything, it will use what you did in the RPD to generate queries. If a query is wrong it means…

OBIEE is great but still has no options for miracles .... Even by hand in SQL you don't have a magical function doing that other than select each column and union all the result one after the other, so in OBIEE you also don't have magical solutions to that. You can do the same UNION in the analysis itself if it's for just…

It looks like you have an issue with your config, check twice on the Office side the SSL config required and what you entered in Publisher.

3319067 wrote:I working on OBIEE reports in cloud environment and version is Oracle Business Intelligence 11.1.1.9.0. What service is that? OBIEE in OAC is 12.2.2, so if you post what kind of service you are actually using it's maybe easier. Or if it's your own made cloud then it isn't a question related to cloud but just…

961614 wrote:Schedule time is 10:00 AM only but if the file size having more than 400 KB , that mail I am receiving at 10:00 PM.I didn't find any logs because agent trigger successful. There are always logs, for every single agent executed there is a log. Agents also execute analysis which also generate logs. Scheduled…

Hi, The emails being sent at 10AM or 10PM is one thing, but at what time does the OBIEE agent run? Because exactly 10h00 or 22h00 sounds too "precise" ... Look at the logs on the OBIEE side and check when things are executed and what happen at that point, maybe the issue is somewhere else (also outside OBIEE).

vinay.lakshmi wrote:but my BMM Model is huge and having 100's of tables I can't do one by one table.. You can, you definitely can do one table at a time, you just don't want, that's different ... The one above is the supported way of doing what you ask for. It's a one shot thing, you do it once and it's done, it will take…