Honestly other than the JS/CSS unmaintainable and expensive hack I already wrote about there aren't simple workarounds. If you use sections everything will have the same structure. To have different number of columns you would have to build individual analysis, so nothing dynamic at all. You can also of course just build…

The answer for a PIVOT is a bit below, posted by @Andrew Fomin. Hi Jessica, Not really possible ... Every table/pivot for each section value will have exactly the same number of columns as the others, so all your table/pivot will always have all the 5 items columns. You can of course get into some JS / CSS if you really…

What kind of authentication is used on the picture server? In the end your problem is that! Find out how you can automatically authenticate on the picture server so you can just display them ....

Hi, Call your DBA ! ORA 01792 isn't an OBIEE error itself. The database raise the error and OBIEE simply display it, so if you want it to run without changing anything in your OBIEE you call your DBA and ask him to change the setting in the DB. Do a google for the Oracle ORA 01792 to get more info, it seems it can also be…

Hi, The idea of having pictures with a naming standard that you can easily build the link to display it is fine. What is that thing about "service account"? Do you mean that the server hosting the pictures require a login to display them? Because in that case you can't really do miracles .... It of course depends on what…

+1 @Thomas Dodds Look at the certification matrix for OBIEE 12c: minimum supported java is 1.8.0_51, so with your 1.7.0_15 you are a bit .... outdated ... It's a good thing the RCU crashed as at least you didn't really start installing things with no chance to have it working.

A dirty (but really dirty) workaround could be to transform your 2 columns into a single one: concatenating Store Number with some random (impossible to have in your data) characters and than Product Number. A more clean solution would be to adapt your model to be able to receive the "Amount > 10" condition and…

Sorry but ... Why to make it so complicated? I would say you have to store the decrypted value in your DB and just setup a correct security in your DB > RPD > OBIEE objects so that only authorized users can access it. The OBIEE front-end is not a simple table with just few rows and columns, because of all the possible…

Hi, What about a customized skin/style ? A patch will not affect it (yes, your DBA is right on that point, don't touch default files).

Hi, would be better if you post in English ... As it's an international forum English is the official language to make sure we all understand each other (more or less )

Try to avoid double posting : java.exe hitting 70% CPU Usage after upgrading to OBIEE 9 It generally produces less answers ... The users reading Business Intelligence are the same reading Business Intelligence Suite Enterprise Edition .

Just don't confuse and mix the ODBC connection required to use the Admintool in "online" mode and the Admintool itself. You need to use the Admintool to add a source to your RPD, and you can do it offline (so creating a RPD locally and you will then upload it on the server) or connect online to the RPD deployed on the…

Hi, You probably need to have a look at a tutorial ... Creating a Repository Using the Oracle BI Administration Tool It's based on a older version of OBIEE but it works in the same way with 12c.

AjeetR wrote:... [nQSError: 14023] None of the fact sources for Activity Local Amount:[DAggr(Fact - Fins - GL Balance.Activity Local Amount by [ Dim - Date Fiscal Calendar.Fiscal Year Wid, Dim - Date Fiscal Calendar.Year] )] are compatible with the detail filter [Fact - Fins - GL Balance.Debit Credit Indicator = 'CREDIT'].…

Same variable for both prompts? Which version of OBIEE? There are ways to make it works, I just prefer to avoid suggesting the most random possible solutions

Hi, Can you be a bit more precise of what actually happen? (maybe with a screenshot)

Hi, Why isn't month part of you time dimension? If you want to do month-to-date analysis the simplest way is to just add the month to the time dimension have model it as an alternate hierarchy in OBIEE (because weeks and months don't have a direct parent-child relation, even if it looks your weeks are strange as a week can…

Good that you have you 2 variables and no error anymore So you can maybe close the thread? For now it's still This question is Not Answered.

From the OBIEE point of view if you have independent connection pool, even if they point to the same DB, it's like different things. So in your case it looks like Subject Area 1 has its own connection pool and so you are supposed to use 500 for your calculation. (I'm not saying the rule you found is right or not) Just also…

To make it short the usage tracking table is setup for insert and not for analysis, so nothing is done on the table to make it fast for analytical needs. So going back to what Christian posted you can move data out of it and create table (one or many) optimized for your analysis needs. It can be real tables or also…