Hi, Thanks for response. Yes, I tried Conditional Formatting, but it doesn't work. I can use conditional formatting for my column POD but on another column (it must be in ROWS or COLUMNS and it share my records). For example, I have the same training name and two value in columns: And when I use Conditional Formatting:…

Ok, thanks for response.

Hi, Thanks for response. I can't create something like that? - Dashboard Group - Group1 - Dashboard 1 - Dashboard 2 - Group 2 - ...

Hi Thomas, Thanks for reponse. In rpd in my organization dimension i have something like that: And ok in table is working fine, the measure in ALL it's a TOTAL and in details it's a details for each organization. But how create graph with these measures? I want what --> SAVINGS [EUR] and SAVINGS [EUR] #1 (both measure in…

Ok, that how you create column? Describe here, what is the formule in RPD, why you dont' use aggreagtion in RPD and maybe what is your formule in analysis? I used column with expression(expression create in RPD) use NONE aggreagtion rule and it's working fine.

So if you check None on aggregation rule you get no value in all column? How you create this column? In rpd set a Aggregation? You have maped this column or using expression? This is not a trick, it's normal functionality.

Hi, Ok you have a Grand Total after values that on column Sales Average please check (in Edit Formule) on Aggreation Rule(Totals Row): None and this it all.

Hi, You must change some data in instanceconfig.xml on your server. There are many tutorial about this, for example: https://shivabizint.wordpress.com/2011/08/26/export-more-than-6500-obiee-11g-records-to-excel/ or OBIEE Solutions: How to Increase row limit to Display/Export to Excel from Analysis

Hi Wolfrm, If youwant compare for example March for each year you can create something like that: First table it's simple pivot table with row and column grand total. The measure column i RSUM(allocated_hours). The second table it's simple pivot with 2014,2015,2016 and simple measure column (without RSUM) and Calculated…

Hi, 1. You must check on column prompt: Enable user to Type Values. 2. Then user can past on prompt something like that: BROKER;CATALOG DISTRIBUTOR;DYSTRYBUTOR;INDEPENDENT; every values with semicolons as example. value1;value2;value3;...;

Hi, I solved the problem, however, which was in the construction of the prompt. Request for a long time to do, to extract value from the column. Thanks for help.

In sawlogn.log I found something like that: 2016-08-17T08:21:46.000+02:00] [OBIPS] [ERROR:31] [] [saw.rpc.variablemos.finalize] [ecid: 005EZtplA3zFs1wawDjc6G0002AO000c1G,0:1:1] [tid: 2078267136] An error occurred during execution of "send". Connection reset by peer [Socket:6] 2016-08-17T08:21:46.000+02:00] [OBIPS]…

Thanks for response. Ok that I create column with timestampdiff and add agregation sum for it - it works. But I have formule in answer something like: sum(TIMESTAMPDIFF(SQL_TSI_DAY,."Invoice Date", ."DUE_DATE") * "Invoiced Amount" BY "Business Unit Name", "Supplier Name") / sum("Invoiced Amount" by ""Business Unit…

Ok, I understand. That's how it implement the RPD? How to perform a column in a fact: TIMESTAMPDIFF (SQL_TSI_DAY, data1, data2) wherein the two dates are the dimensions. And then the function AGO also reluctance to act.

Hi Christian, Thanks for reponse. I analyzed your example, and in my opinion it falls short. This is your example: In my opinion In 2012 row should be: 2012 || 993612 || 960672 || ... Because the column YAGO should be the value of the previous year and are still the same.

Someone has any suggestions?

Hi, Maybe more info, for example: Do you have any time hierarchy? How selections? You can set for this columns time level on month.

Ok, It turned out that in fact this is the error associated with the data type. Types have been changed in DATABASE on DOUBLE (both columns is DOUBLE) and it works fine. When I use cast() function in RPD i stll get error, change i database help. Thanks for help

Hi, I think that you should use FILTER in your formule. For example: If you want show value on first row you can add something like that:CASE WHEN Column 2 = Green THEN .... END Next you create formule, maybe something like that: ( FILTER(COLUMN 2 USING (COLUMN 2 = RED)) + FILTER(COLUMN 2 USING (COLUMN 2 = YELLOW)) ) * 100…

Hi Andrew, I tried to apply the cast () both DOUBLE -> VARCHAR and VARCHAR -> DOUBLE but it did not work,I still have error.