If it's really the business model then the OP maybe did a full drag&drop of the physical layer to the BMM layer and ignored almost all the rules of OBIEE. If it's the case the easiest would be delete the full model and start again paying attention to what is done.

3512682 wrote:It is also showing the prompts in excel along with the analysis result. Not possible ! Or you are not telling us the full story .... Where are the prompts in my export? Nowhere ...

Why don't you display the "export" link below the analysis you want your users to export? That "export" link is local to the analysis, so the result is just the analysis. As Christian said if you use the "export page" you get, as expected, the full page.

Why not to start from the beginning? 3251920 wrote:using "Where in" clause will return with the following error ORA-01795: maximum number of expressions in a list is 1000 error Of course the best solution would be a join with the tables generating the IN values, in your case you don't have that. Another solution is to use…

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.