Is the logical table where you can't create an hierarchy an actual dimension? Is it linked to a fact table?

Hi, What make you think there is a limit in the size BIP can deliver to users? Did you find logs telling you the report was generated fine, it was 23Mb, but it hasn't been delivered because of a lower limit for delivery? There can be many other reasons preventing your report to be delivered. If you have a log saying it's a…

Forgetting the context of OBIA etc. and just focusing on a database point of view there are few techniques to reduce the down time of a table while loading. For example partition exchange, where you load the new data in another temporary table and then when done you switch the partition of your main table with the one in…

For that I can't help you ... Because of no support from Oracle when running a not certified config I just avoid it. Wait and see, maybe other OBIA users here had experiences with your target versions...

Hi, Have a look at the certification matrix corresponding your exact version of OBIA: Oracle Fusion Middleware Supported System Configurations For the "compatibility with Oracle 12c" it doesn't really mean a lot: Oracle <something> 12c, what is the <something> ? If it's database then you have to ask that to Informatica in…

Hi, The error is "ORA-28001: the password has expired", it means it's an Oracle DB password which is expired. Check the passwords / accounts created by the RCU and make sure they are all still valid.

As Christian said: use an AdminTool with the same version of your server (you can have multiple versions of AdminTool installed in parallel on your Windows because they are in different "home" folders. Your screenshot show like you wanted to create a new RPD, and you are in the step where, after creating it empty, you are…

Triple posting : After changing to company logo..how to clear the image cache clear setting in OBIEE? After changing to company logo..how to clear the image cache clear setting in OBIEE? And it's not by creating a new account that the answer will change ... Maybe worth to review

Had a look at https://blogs.oracle.com/biapps/tips-and-usage-of-group-account-number-configuration ?

The function just replace the measure itself, so in your case I would say you replace the "Sale Amount"."Order" by the TODATE(...) inside FILTER. Didn't check the generated physical query but there anyway many chances the result will be the same if you do TODATE(FILTER....) instead in a normal "simple" analysis.

That's why I wrote this before: This is the name of the wanted level of the time dimension hierarchy. It isn't the logical column but really the name of the level of the hierarchy. And you must have a time dimension, or you just forgot to model your things right. And as you are on OBIA there is definitely a time dimension…

What are the details of the OS and database you use? Is it a totally clean install? Did you try retrying the install? Same error in the same place?

Hi Luigi, If you look at the available functions in the "Time Series Calculations" group you find TODATE. As the name says it will gives you the to date figures of a given measure. For example something like: TODATE("Revenue Metrics"."Revenue", "Time"."Time Hierarchy"."Year") It will return the "Revenue" measure "year to…

Hi, It's difficult to imagine nothing is logged when it happen. So look at the messages you find in your logs when it happen and so you can at least try to investigate a cause instead of the result of something.

OBIEE doesn't care much if it's the same table to 2 tables as long as you have a clear join between the 2. The logic will not really change, things will work fine even with 2, 3, ... 10 tables. Don't worry, give it a try

Hi, Grand totals requires a formula/aggregation to know how to calculate it, that's why they work on measures as there is a default aggregation defined in the RPD. If you want to sum "total amount" (why isn't it already a measure?) you need to make it an aggregation and place it into the measures area. Or edit the formula…

Your "Expiry" column isn't aggregated, so 2 rows in a source table = 2 rows in the final report. Check your data as the issue is there. If you look into logs you find the exact physical query executed which will tell you if you maybe have a missing condition on one of your joins or tables.

I don't have a old 11.1.1.7 available now .... More in general, looking back at your example : there are mistake in posted example as it's kind of hard to tell which columns means what and come from where as it's same/similar values and you mixed columns names a bit. But you can't do it with a single join and a OR, because…

What's your OBIEE version? Just did that in my RPD and it didn't complain about "column used more than once".

Nikhila reddy wrote:As we can't do 'OR' condition in rpd . So please suggest me to get member details if he is member. You can definitely do a OR condition in the RPD, just open the formula editor for that so you write your condition correctly. If you just pick columns from the 2 lists OBIEE create a physical foreign key…