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…

3531239 wrote:In CSV, I'm able to export the same report but not in Excel format(as per the requirement it needs to be exported in Excel format only). CSV is a 100% format support by Excel since .... can't count, I was too young to remember. Before to go more in details .... What exact version of OBIEE is it? (version +…

Thanks for the spam, not sure what you are trying to test ... You maybe want to read the community rules.

Well, you can use a pivot. You seems to have 4 columns (ACT, BUD, Variance and Variance %) which are repeated by some attributes. In that case using hidden columns calculating flags will work. So you move the "condition" from the XML into the formula of the column (so it's visible and easy to maintain). But it depends on…

819624 has it right. As you are new, you need to know that the Admintool saving the RPD must always match the server version. And RPD can be moved to upper version (because upgrades of RPD are always supported) but there isn't a way to "save as older version". I can't remember what OBIEE version is the 326, could maybe be…

Hi, Conditional formatting based on 2 or more conditions is possible. The GUI way to make it would be by adding new columns to your analysis where you write formulas returning flags. The issue with your case is that you are using a table view, so that approach will not work because each column is independent. You can still…

Ok, let's try to take things from the beginning You said "sql result", so why aren't your 2 prompts standard "all column values" but instead you had to use a "sql result" for the list of values? Aren't these 2 columns you prompt for linked in a way or another in your model? Can't you just use the "limit values by" and let…

Hi, must be the week of the prompts as that's probably the 3rd thread like that I see this week .... In OBIEE out of the box there is a way to manage dependance between prompts fields, it works using the column prompts and the RPD model to refresh related fields. If your prompts are based on LSQL queries there is already…

Your answer is "archive" / "unarchive" . You can archive content from the front-end and you can also archive from command line (automated way) by calling runcat.sh . In the same way you can then unarchive from the front-end or by command line.

For the records, Oracle also wrote on the topic of "the best tool for the job" when it was about rendering / exporting tons of data (because I will never believe someone analyse 25K rows in screen). https://support.oracle.com/rs?type=doc&id=1558070.1 (for an older version but still valid for 12c)