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…

Hi, Assuming you talk of "sorting" instead of "short selling" (shorting Meaning in the Cambridge English Dictionary ). Which exact version of OBIEE 12c ? Looks good in mine as long as the sorting column is placed before the "Dim 1/2/3" column.

Your customization is linked to a given page, if you look into the code of the customization you find the reference.

And if you don't have VA/DV licenses you are now up to pay tons of $$$ to Oracle as you used VA to upload the Excel ! @959d5b3b-a2b6-4462-ad3b-972dc9237eb3 : before to use VA to upload your Excel as posted by Asim make sure you are legally allowed to use it (= you have a license for it).

View selector simply switch between views, and a view just display the result of the query. The query is one and unique and so you can't change the filter of the query based on the selected view, for that you would need different analysis (as the filter is at that level). You can only try to "cheat" a bit but visually…

So the idea of having both as level based hierarchy as Christian said, using an opaque view if you can't do it with a view / materialized view / ETL in the DB, is probably easier as it will also answer your other point about filters: Report w/Parent Child Hierarchy not filtering But if you want to stay on parent-child you…

Depends what kind of filter you are setting .... You have the log telling you exactly what happen when you add a filter and have no record anymore. Hierarchies aren't filtered with a filter but mainly with selection steps. So look at your logs and you will see the reasons of the "no records" as the query will be quite…

933651 wrote:I think it is already strted because ./start.sh executed successfully. Maybe I have to do some other steps. That's why next to start.sh you have status.sh giving you the exact status of your environment. What kind of install you did? Did you load the SampleSales Lite BAR file during install? Because if not ...…

Is OBIEE really running? Can you login on the web page of OBIEE with these credentials? Weblogic Console and Enterprise Manager isn't OBIEE, they are on the weblogic Admin server and can perfectly works while OBIEE is down or your user can't login to OBIEE because you are missing the security (if you didn't import the…

Long story short: choose between spending hours and days trying to make it works and install virtualbox and have your OBIEE up and running 30 minutes later. Follow the link posted above by Pedro if you want to start with SampleApp which is definitely something every OBIEE user would need to have.

Christian gave you the answer (you are asking something which doesn't make sense as OBIEE and Informatica will never interact one with the other). If you actually mean if your OBIA 7.9.something using Informatica 9 can be deployed on OBIEE 12c then you just need to look at the certification matrix. And the answer is yes as…