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…

Right click on the BMM > "Duplicate with Subject Area", right click on the physical DB > "Duplicate". Change the connection pool settings. Change the links between BMM LTS and physical tables by using the Tools > Utilities > "Replace Column or Table in Logical Table Source" utility. Done ...

I was referring to "his" bad wording with "2 fact tables". And for the architect: yours can be a solution assuming he has 2 real measures, something that a normal common standard model will not have ...

In addition to what Christian said (so bad wording), do you really have "Burger King" and "McDonalds" as columns in your fact table? In theory they are supposed to be attributes, so in a dimension and then you have unique measure from your logical fact table representing no idea what your numbers are supposed to be…