That's what I said: a measure column will be replicated for all the attributes ... And in addition you have the grant total as well. OBIEE isn't supposed to manage that requirement, your user being too lazy to make a "right click > insert row" isn't enough to justify to build a weird pivot. A pivot has some basic rules and…

I guess you forgot/missed to upload screenshot or something (or they disappeared). Arjun_Mehta wrote:Users dont want to take the trouble of adding one row on his part every time.... Please tell that user that he is lazy, and a lazy user using the wrong tool for the wrong need is "dangerous" (yes, I say it and mean it )

You maybe got it wrongly ... "archive" isn't based on any date/time parameter. "archive" works on a path, it archive what is in that path at the time of running the command. You have runcat.cmd installed on your workstation/laptop to see the attributes the runcat.cmd -cmd archive accept. (Catalog Manager being installed…

The requirement sounds a bit "dumb" as in Excel your user just need to go down or right and he has a empty row/column. You can add a column and give it a NULL value and you have a empty thing. Of course it depends totally on how your pivot looks like (because a "measure column" will be repeated for all your attributes and…

Correcting my previous answer ... Sure SampleApp has 2 domains configured against a single install ... But when you start it, 2 weblogic Admin server, 2 weblogic managed servers etc. So double resources used (ram, cpu) even if sharing the same binaries on disk.

By the way, joining the party later ... You apparently can have multiple domains on the same OBIEE install (so same "oracle_home" and multiple configs). Sample App has that with 2 BI instances.

Multiple installs? Sure, all independent and not sharing anything, no problem for that.

As the idea of the attribute is to be unique (based on the logical keys you defined), if you add the logical key to your analysis you will get the correct level of granularity. The distinct will still be there as that's how things are supposed to work (when using measures there is a group by, when only attributes it use…

Did you read what I wrote above? Because I actually gave you inputs on your original post (in the middle of the reply to your second one...). Aren't you in the described case? All the cache things ("checkbox" , prefix box etc.) are in the analysis using the value of your 2 prompts. But the prompt itself doesn't have these…

Hi, Your first case has an issue where OBIEE will not really help you a lot: you have a "dynamic" list of people. Having prompts allowing you to enter values, store these values in variables and use them in formulas in the analysis is fine. But your first example is typically somewhere where you would want a Qtr and FY…

Different reports, different columns ... Master-detail to not care as long as the column "driving" the logic (customer) is the same one, and it's your case ! Master-detail is often used inside the same analysis to drive different views, but can always perfectly works between different analysis in the same dashboard page.…

Good it works for you, as it has been suggested as solution ... Can you please close the thread? This question is Not Answered.

Hi, What do you mean by: Selva Pandiyan wrote:OBIEE reports by default generates the physical query with DiSTINCT CLAUSE. You mean when you make a query on attributes only? What's your use case? Because you can definitely avoid the effects of a "DISTINCT", depends on what you try to do exactly ...

Hi, Not sure to get exactly how your thing work. Report 2 and 3 always display data of a single customer, the one you click on report 1? If that's the case you better use master-detail instead of navigation. Master-detail will only change report 2 & 3 (both details) by selecting the customer you click on report 1 (master).

Hi, In the chart the legend has no option : it's there or it isn't. Names are names of columns. If you need a kind of custom legend you can add a "legend" view to your analysis. The legend view is built by hand, so is static but allow you to put what you want inside the way you want it.

There is a way you can check the value and change it ... The PORTALPATH is a variable and you see it in the RPD if it is set or not. The value of "My Account" is stored in the catalog. I don't have a 11.1.1.9 available right now but I'm kind of sure it didn't change that part. 2 ways to see / change the value: first one is…

Hi, Apparently it's the DB not accepting connection using an old JDBC driver (what the installer does). There is a setting you can set on the DB server (in the sqlnet.ora file) to allow older clients too. Have a look at https://docs.oracle.com/database/121/NETRF/sqlnet.htm#NETRF2016 and ORA-28040: No matching…

Hi, You probably linked the wrong Document ID ... The 11.1.1.7 Admin tool isn't certified for Windows 8, 8.1 or 10. Just because they didn't existed when the tool has been developed. The 11.1.1.7 just doesn't work on Windows 10. If you search the forum you will see that many tried to make it, all failed. Some managed to…

Hi, Based on what Oracle says: Oracle Database Vault implements powerful security controls within Oracle Database 12c. So in the end it's a Database 12c, which is supported. Vault apparently it's a kind of "layer on top" to give you extra control on security etc., but from a "SELECT ...." point of view, which is what OBIEE…

Well ... that's no luck "a general error" and nothing saying what kind of error it was ! Anything else useful if you look into the logs?