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…

Hi, Seem quite explicit: 3203003 wrote:Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :24317091, 26330183 So you know what to do now, contact Oracle Support.

I would say you can globally trust it, as you aren't looking for factual execution times but more to define priorities of what object / analysis to look at first. Of course you must not work on the MAX only, keep in mind you also need to consider the number of occurrences, the average and the median to define your…

So can you please close the thread? Right now it's still This question is Not Answered.

Sherry George gave you some good resources on how to start having a clear picture of what happen. As a side note you maybe want to suggest your client to upgrade to a still supported version as 12.2.1.0.0 as Error correction support ended last June (https://support.oracle.com/rs?type=doc&id=1664916.1)

3545306 wrote:client requirement is like that, so we had to design the analysis that way. I disagree, you had a requirement and tried to get there in wrong way. The requirement is a fairly simple and standard thing most of clients have. Then you have a simple way to make it and complex ways ... If only you would try to…

Hi, Yes, it is possible. OBIEE being a web app with some JS/CSS you can "touch" every single part of the page. The question is more why and what's your target, because there are chances it isn't the best solution ...

I still don't see why you end up with such a complicated analysis ... Your time hierarchy will be filtered by the selected year and with a super simple logic you can add previous one and next one too. So for me it's still: LOB, time hierarchy, budget : 3 columns and that's it (with selection steps to start with the year…

12.2.1.3 : work as expected (sample using 3 UNION, normal order would by "BizTech", "FunPod", "HomeView") The sorting column has values defined by hand for each query (10, 20, 30), adding it before the "Brand" the sorting is based on this column instead of "Brand", if I then make it hidden it will not be visible but still…

Hi, You mean in the OBIEE catalog? Well ... it's a server-client application, and the "catalog" isn't a standard file system but more something which is owned by OBIEE and you aren't supposed to mess around there inside. So the only possible option would be to mount your "local machine" on the OBIEE server and then link…

Definitely agree with Martin, your model is "weird". You do not need 3 years hierarchies, with a properly built time dimension you just add the time dimension once and add a selection step to automatically take the 3 years instead of the total. And your budget definitely need to be a single measure, not sure how you end up…