Hi, sorry but ... what is wrong with your totals? 42.88 - 36 = 6.88, and the totals are the sum of the values of your columns, so it's fine ... If you ask OBIEE to display your 42.88 as 42 hours and 53 minutes you are asking too much as in your example your data is normal numbers.

Hi, Did you check if your applications roles exists and if you have all the right privileges ? The migration with the BAR files also migrate the security, but some app roles names can be different or things like that. So log into EM and Console and validate everything on that side.

Hi, Which version of OBIEE? 10, 11, 12? In 10 and earlier version of 11 (if not wrong) it was possible to have conditional formatting on totals, in the last 11 (and I guess 12 even if I didn't test in details) it's not possible anymore: conditional formatting apply to values but not totals. Second point: is your null a…

Hi, In 11.1.1.7.* when you choose the "User input" = "Calendar" you can't limit the values anymore. If you want to limit the values (>= 1990 && <= CURRENT_DATE + 15) you must stay with something else like a list. The UI doesn't provide any way to limit values of the calendar.

Hi, What did you already try to solve your issue? Because you don't really provide any info to really help you in a more focused way other than ... reboot it and try again. The message is telling you it can't connect to the biserver instance, so the simple question is: is the biserver up and running? Are you allowed to…

sureshbhavana wrote:please give the solution Try with 42 .... Sorry, you don't really do anything to avoid random answers or jokes as you don't give any input (the picture just confirm what you say in the thread's title: there was an issue configuring the domain and it's step 13 of 14). So maybe you can look for some logs…

Well ... It can works for dimensions values only, but as soon as you have a fact OBIEE requires joins. A logical model in OBIEE must be a star schema, and OBIEE uses that when having measures. OBIEE doesn't work like SSAS, it's power is really to generate queries based on the business model using the physical model to know…

Hi, You don't have a single physical join or logical join and you are surprised that OBIEE can't know how to join your tables together? I guess you forgot the key element of the RPD: join things together so that OBIEE can know how to generate queries to find answers to the analysis you build in the front-end. You must join…

Hi, Can you access the web interface OBIEE using a browser on your Windows PC? Is the firewall on the SampleApp506 off? (can't remember if it's off by default or not) Is your windows firewall off on the virtual interface with a 10.0.2.x address or at least configured to allow access to the few ports requiring it? There is…

I couldn't find an hierarchy like yours with the same value for different branch of the hierarchy so I couldn't try the exact case to see if there is a bug or something. So I stay on my first impression: that there is a key somewhere not defined in a way to uniquely identify the correct "Other" value in the right branch.…

Hi, Your 6 dimensions have something in common? Same physical source or something like that? Is your system more or less standard or you had to change all the settings for some special needs? As you expected OBIEE must not add in a query unused dimensions, so I'm guessing there must be a link between these dimensions to…

Hi, What do you expect exactly as answer? Amazon Cloud, a physical server, a virtual server (VMware or any other) is the same thing: you must install the tools by yourself. In Amazon choose if you want a Windows or a Linux image and then start installing your software like you would do on your own physical server, it's…

Hi, For OBIEE 12c to import a RPD and webcat from your OBIEE 11g you need to use the migration utility provided. 12c works with the BAR file, an archive containing RPD, webcat and security. The utility (a JAR) must be executed on your 11g environment, it will pack together into a BAR your RPD and webcat and security and…

What is the value of Dim - Item.Purchasing Category Hierarchy 8 for the Semiconduc > Transistor > Other rows ? Is it maybe "Other" ?

More in general the way you write it sounds like if it's something you will do many times? If you really have a dev system in 11.1.1.7 and when done you must deploy to your official system (prod) being 11.1.1.9 I highly suggest you quickly update your dev system to the same version. The XML of catalog objects changes…

It's a bit confusing .... So the correct value of "Semiconduc" > "Transistor" > "Other" is 2'032'632. But when you filter with your hierarchy in the prompt on "Semiconduc" > "Transistor" > "Other" you have "Other" > "OTHER" > "Other" appearing on screen instead of "Other" below "Transistor" ? If that's why happen, are you…

Hi, CURRENT_DATE is today, so TIMESTAMPADD(SQL_TSI_DAY, -7, CURRENT_DATE) is 7 days ago. If you add a filter on your data using that formula you get data of the last 7 days (your date >= 7 days ago). If you want 8 or 6 days just change the number in the formula, if you want 1 month you must change the first parameter and…

Hi, When using a hierarchy as prompt you don't filter the analysis by setting "is prompted" on all the levels but you add the hierarchy to the analysis as well and using selection steps you define it can be override by the prompt.

Do what @3055888 said: a CASE WHEN <account columns> = 'Revenue' THEN <your fact> * -1 ELSE <your fact> END Of course all the options posted works: 0 - x, x * -1, ABS(x) You are supposed to have a dimension or an attribute somewhere allowing you to identify your revenues to use as condition in the CASE WHEN.

Well, this doesn't really tell you where the issue is ... Did the query take a day to return you 17 records because your DB is slow or did it take so long because the query was really bad? If it's the first you must ask a DBA to have a look and it's a DB issue, if it's the second you must investigate if the report is…