As Christian said the answer is in your logical model. You have a physical snowflake, so depends on how you reduced it to a star in the logical model ...

As a side note 4000 is also the max limit OBIEE accept, so you are playing with limits with quite many things Honestly your query looks like a workaround for something. First it is a DDR which return just a bunch of information, to use to dump a long list of people info is OBIEE really the best tool for the job? The way…

More in detail about the filter: if you set a filter which limits the content of the hierarchy (in your case "Agency B"), the hierarchy will be correctly limited to only the values matching that filter (so you see the parent of Agency B=Pennsylvania, Agency B=Pennsylvania and then only the children of Agency…

Hi, A filter is set in the query to the source, the data will be filtered at the source. "Keep Only" is a selection step, it's just a visual (on screen) filter but the query returned all your data (a kind of pre / post query filter). You better to not play/select/drill/click on the hierarchy while editing an analysis in…

Sorry @Mark T. , it was a totally not serious comment (because it's Saturday) and it's just totally absurd as thing. Scores have always been numbers (actually percentages without the '%' sign), and it's totally dumb that there they are sorted as text. Worth opening a SR asking for a fix I would say (maybe there is always…

Do you see numbers? Not me It's known that right after 0 is 100 and all the others come after

Similar type of information isn't the same type of information ... You generally add in the same logical table sources which complete each other (partitions like current data in a table and historical in another one) or same data at different level of details or the "reduced" snowflake. But otherwise by putting them in the…

If you got what you were looking for you can maybe close the thread and mark as required? Right now it's still This question is Not Answered.

Well ... not really ... OBIEE isn't a simple basic deployment on an application server. It is highly integrated in Weblogic. Just think at the security, the domain and all these things. You maybe want to have a look at the OBIEE architecture to understand the reason.

1322506 wrote:...I can't do anything about. E.g. [39099] Level "ABC"."XYZ" has at least one display key that contains multiple columns. Only the first column of a display key is displayed when drilling. This one is simply fixed by unchecking the "display" checkbox on the current logical level key and add a new key only for…

You maybe want to stop for a while and redefine what your target is and how you are going to achieve it. It started by a RPD upgrade and end up with an archived catalog supposed to act as a folder. There are 2 ways of doing things: - A: by clearly identify your target and define how you are going to get there and execute…

Hi, If you open the formula edit window in your analysis you will see a bunch of String functions available. In your case you maybe want to look at LOCATE, to find position of 1st " . " in the string. So something like LOCATE('.', "your table"."your column"). The same function can accept a 3rd parameter saying from which…

To do dimensional only analysis you can set the "Implicit Fact Column" in the subject area. This column will act exactly as you are asking, telling OBIEE which fact to implicitly use to join your dimensions without requiring you add it to your analysis.

Is "wadmin" the login you used in 10g to edit the RPD? That's what it complains about...

Keep in mind that Google is your friend .... <script>window.location = "/analytics/saw.dll?catalog";</script>Please go to <a href="/analytics/saw.dll?catalog">the Catalog</a> if not redirected automatically.

Hi, The starting page is the homepage or a dashboard, there isn't a setting to open the catalog by default. If by "report folder" you really mean a folder in the catalog then you can try by setting as default starting page a dashboard, and in the dashboard you add a redirect to the catalog page with a javascript code.

If your image is blocked by the CSP rules (the link Sherry George posted) you can see it in your browser if you open the developer tool and reload the page. You must see a reference to an image blocked because of CSP in general. If that's the reason (so if your image has a different domain than the OBIEE one) configure…

Excel files are overrated (mainly because a binary proprietary format). The script can definitely manage to get you a CSV-like file you can easily open with Excel. What's the real need, the final target of that requirement?

You maybe want to export them from the source of groups and application roles ... The RPD display them, but application roles and groups come from weblogic. There are scripts (WLST) allowing to export them and for some probably also in the UI you can manage to export some of them.

Hi, So the "dynamic table" is a pivot (that's actually one of the most "exotic" translations I saw ). And the value you change are columns you placed in the "pivot table prompts" section of the view. And when you execute the analysis (so in preview mode or in a page, and not in the "Results" tab when building it) and…