Still a good reference to start the talk: https://speakerdeck.com/rmoff/source-control-code-deployment-and-concurrent-development-for-obiee-12c TL;DR https://speakerdeck.com/rmoff/source-control-code-deployment-and-concurrent-development-for-obiee-12c?slide=55

aPsikus wrote:We have decided to remove aggregation rule in RPD, but then in report there is error:State: HY000. Code: 14025. [nQSError: 14025] No fact table exists at the requested level of detail You are abusing a bit too much here OBIEE requires the business model to be a perfect star, a star schema has dimensions…

Look at your logs, check the generated query, open your RPD, fix the model and retry. As OBIEE is empty out of the box it's difficult to tell you anything more precise as you are the only one having your RPD and your analysis in front of you.

Multiplied by 360? Sounds like it's multiplied by every single day ... You are doing a join at a different level than the lowest granularity, so you have to model things right in the RPD telling the system how things are supposed to work. So the join and OBIEE are just doing exactly what you asked! And it's quite…

mmajdana1 wrote:I use this url to login to OBIEE http://bit.mprh.local/analyticsso it is the same url just without the port, and this is the format needed for Catalog Manager http://host/analytics doesn't mean you connect without the port, it just means you are using the default port 80 for HTTP. So in Catalog Manager you…

Details, details, details ... If you don't give more details of what you are doing, where, how and on which exact version it's like a lottery: we can post random things but it will not help you.

Hi, Yes ... You take a screenshot, you reduce the size and save the picture. You upload that file on a webserver, in a folder deployed in Weblogic (like the good old "analyticsRes") or in the catalog and you link the picture for your link. If you are looking for OBIEE doing the thumbnail itself, that's not possible.

Hi, In theory it's supposed to work, but keep in mind that the BI server is doing the join, so it's definitely slower than if the database was doing things directly. If you look at the logs what do you see? Do you see the 2 queries sent to the physical database and the results joined together by the BI server?

Hi, Without going into the details which Robert already covered, it's worth having a look at the CASE WHEN syntax (both SQL and OBIEE): it accepts multiple WHEN statements, so you definitely need to consider getting rid of your embedded CASE WHEN and have single unique CASE WHEN with the 3 (or 4 in case you need to manage…

As Robert said there isn't anything embedded in OBIEE for that. As he said you either do a "do it yourself" APEX thing or take a look at existing solutions : OBIEE Commenting & Annotation Tool | Collaborate with BITeamwork https://www.rittmanmead.com/chitchat/

Joel gave you the workaround: a VM with Windows 7 ...

Thomas pointed in the right direction ... 11.1.1.7 has no chance to work in Windows 10, 11.1.1.9 I guess was already a lot better but can't remember exactly (and I'm anyway not going to imagine all the possible versions before you say exactly the one you are trying).

Is your RPD valid? Because based on what you said it's the RPD that prevent the BI Server to start. And also worth telling the client that a 3 years old version of OBIEE is out of support and at some point they better think at an upgrade ....

In everything you wrote I don't see a single element related to OBIEE. It sounds like you are abusing HTML and how iframes works in 2018, with all the security rules enforced by browsers to protect users. An HTTPS page can't load HTTP content without giving you the mixed content message, that's because the HTTP content…

You already got maybe what you are looking for ... But aren't you just looking at how to knows what analysis/dashboard has been deleted from your catalog? In that case the link posted by Thomas helps. An alternative ways would be to use the script provided in SampleApp loading the whole content of the catalog in a DB and…

In my memory there is something which is stored inside your own OBIEE (either the path Joel mentioned or search inside the install folder). Just not sure how complete it was (maybe only RPD), I doubt it's really like the one in SampleApp as that one is extended with data of the various scripts for links between objects,…

Hi, The issue must be somewhere on your side .... I just downloaded part5 in my browser right now and the checksum match the one given online (just like the one I downloaded a year or so ago the first time).

If you read the documents of the patch it lists the bugs fixed. But many bugs are just references and details aren't public.

The theory is that it let you open the page, but doesn't load the analysis in it before that you submit the prompts.

That's what you have to look for ...