In addition to all the previous: it's a good things to also don't take the opposite approach and fit everything into a single business model forcing things to stay together when it doesn't make sense. As an example a screenshot of the "core" business model of OBIA : tons of objects with a crazy amount of fact tables and…

Hi, Temoryian wrote:Is there something that I am missing to prevent this from happening? Yes, you are missing to post enough information to know what you did As that's an analysis (it looks like OBIEE Answers, therefor it's called "analysis", a "report" would be a BI Publisher report) you built yourself it's impossible to…

Hi, The theory is a star schema per fact table, but nothing forbid you of having these 3 star schemas into the same business model. This is actually how you do those things. A business model isn't a single star schema, it's more all the pieces representing a business need, knowing that each fact table need to be modelled…

3614817 wrote:Added it only the BIAdministrators group - same result... Don't you have any other app roles than BIAdministrator, BIConsumer, BIAuthor? Because those are just the out of the box application roles, but doesn't mean they are really used accordingly to their names. In a real environment I would expect these 3…

Hi, Sorry but I just don't get the question (and as nobody posted anything in many hours I'm maybe not the only one). What do you call "redy check" ? What is the link between certification matrix and functionalities? The certification matrix simply tells on which system OBIEE is officially supported, but it's always about…

In addition to the good replies already posted above, it's worth nothing that action links do different things based on what/where they are applied. An action link on an attribute column will act in a very different way than an action link on a measure column. As a general note you maybe want to have a look at and always…

Opatch is the truth, nothing else. If Opatch tell you that your patch is applied that's it. There has been various threads about versions not changed in the front-end etc, and the answer always end up pointing at opatch: sure it would be better if the front-end shows you the right thing, but as long as opatch says it's…

There are random users which are used by OBIEE for some housekeeping tasks. It isn't real users but more processes of OBIEE itself. As almost everything is done via webservices etc. they are still visible as sessions.

Does your dashboard contains (directly or indirectly) an object with HTML inside? The reference to "nbsp" sounds like ' ' which represent a space, but '&' if not correctly encoded break the XML parsing of the document, which is what the sax parser does.

Hi Charles, The filename generally uses + as spaces and % could be any kind of special character, OBIEE also shorten names, so sometimes it's quite random. Just create an analysis with a similar name and then copy the XML file (not the .atr) from the user folder and override the one which has been created (so rename the…

What Joel said, adding a reference to the most known collaboration tool for OBIEE: OBIEE Commenting & Annotation Tool | Collaborate with BITeamwork As you seem to have quite some limitation with security they maybe are going to prevent you to use APEX as well. If it's the case try to fight that decision, but if really no…

Christian Berg wrote:In all honesty I'd go the file-system way: Create a new object of the same type as you're trying to recuperate. Then go and take the CONTENT of the object you want to recuperate - go inside the file and grab all the XML - and then go inside your new placeholder object, paste the code, save and that…

Did you copy the whole <userXYZ> folder? I would only take a subfolder or content as the main user folder contains bunch of "special" things (metadata files storing things) the catalog maybe get confused about. And you will still need to erase permissions to add yourself in it as by default only the deleted account will be…

As you are on OBIEE 11g (11.1.1.9) there are GUID between your accounts and OBIEE. Each account had a unique GUID and OBIEE uses the GUID to reference things. So even creating the same name in the weblogic embedded LDAP your new account will get the a new GUID and will be treated as a totally different account than the old…

Of course you can always copy things in the filesystem (remember to take the .atr file too as without OBIEE will even not see the object at all), but you will still need to reset permissions on it (which are inside the .atr in binary and the catalog manager is the tool able to play with that).

I don't have an OBIEE running now, did you try changing the permissions on the folder to grant you access? Otherwise offline.

Did you try using Catalog Manager? You must manage to do it using that tool (not from the web frontend of OBIEE, there you will not be able to do it).

Hi, Did you try running the RCU to do a drop of existing schemas? It maybe allows you to clean up properly. (Assuming you run the RCU with enough privileges)

Hi, Usage tracking tracks work done by the BI server. If the BI server execute a query it will be logged, if it doesn't there isn't a log in usage tracking. As there are various levels of cache, queries hitting the BI server cache are logged, actions being answered by the presentation cache (so refreshing the browser page…

I guess it's more a technical limitation. The analysis has filters, the dashboard can have one or many prompts which generate an almost infinite number of possible things. Sure by default a prompt is used to filter an analysis, but often it's used to drive content (hide/show things in the page) etc. Therefor it's…