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…

Hi, Saved customizations of a users are stored into his own personal folder <CATALOG_ROOT>/users/<username>/_selections , shared customizations are saved next to the object, so if you save a shared customization for a dashboard page you have it in <DASHBOARD_PATH>/_selections . Just keep in mind you are not supposed to…

Hi, The "Freeze column" option is possible only in some columns bases on your layout. How does your dashboard page looks like (how are columns placed in it) ? If you add 2 columns one next to each other you can freeze the one on the left, if you put 2 columns one above the other you can freeze the one on top etc.

Hi, Do you want to call a DB function in an analysis or do you want to do a direct database request? Because it's 2 different things. So if you want to bypass almost all the functionalities of OBIEE and use it like if it was SQL Developer (a free tool) you simply go on "New" > "Analysis" and there you select "Create Direct…

You run it from a Windows or Linux machine (or VM) able to connect to the DB where you want to create the RCU schemas. RCU doesn't require any link with something installed locally on the host running it, it just create things in the DB, so you can run it from where you want as long as you can reach the DB server (so no…

Hi, as your screenshot are missing (smells like a copy/paste of something you posted somewhere ...) how did you created the 2 LDAP? Are they 2 authentication provider? What are the values of the "control flag" you defined for these 2?

How are your network settings? Using DHCP? Having a firewall on it? Is the IP of your test-bi01 host still 172.30.101.16 ? Next time post some extra details like OBIEE version, OS and context (VM, server, your own laptop etc.) ... Ok it's 12c, but if you post it you avoid to be asked for it ...

Before to try to improve something you must identify what you are supposed to improve. "Improve report performance" doesn't actually mean anything in OBIEE as the report performance is a mix of multiple applications talking to each other, so until you don't start by finding out where time is spent there is nothing to…

Right data or data compared to what? The first thing is to find out where the issue is: is your data available in the DB? Does your report connect to right DB? What kind of query does your report generate?