Hi Madasamy, Do you mean that i need to have my child prompt as a seperate prompt instead of having that along with the parent prompt? If i have my child prompt as a seperate prompt means, then the value can pass from my parent to child prompt, but the report which uses child prompt will not get the value from the child…

Hi Madasamy, I couldnt clearly get with your solution. You meant that i cant use presentation variable and instead do i need to rely on session variable for this text field prompt to work to populate default value based upon the parent prompt selection[where the presentation variable is initialized] Kindly clarify. Thanks,…

Hi Pedro, Finally the column hide worked with the below formula, if the prompt value is null. This worked, after specifying the hideif condition in presentation column of None to 1=1. Now i can see the columns hide/show in the analysis according to the prompt selection in dashboard. ifnull(@{p_c1},"None"."None") Thanks for…

Hi Pedro, My variable p_c1 is returning number and not the attribute so i cant invoke that using '@{p_c1}' Saro

Hi Pedro, Again thanks for the reply. Nope i dont want to show different column value in the same column. I want to hide/show the column in the analysis according to the selection of the columns in the Prompt. The below link exactly explains, my scenario. Also if u can have a look @ my previous reply step by step then u…

Dear Gianni, Apologize if my thread dint explain the problem clearly before. Here is a brief scenario: 1.) My ultimate output is i need to have the above two measure columns(line base amount and pda amount billed) as a prompt values in one of my dashboard prompt, so that i can select those columns as a value in the prompt…

Dear Pedro, Thanks for the reply. Actually the value that im passing to my presentation variable p_c1 through variable prompt will bring the measure value in my column and not the attribute value. Hence the below formula of ifnull(@{p_c1}['@']{cast (null as char)}, "None"."None") is not hiding the column, as my…

Thanks Gianni, for the right explanation;-) Regards, Saro

Dear Thomas, Thanks for the reply. If that so, then my attribute column organization and invoice currency is repeating, even though i marked it as a suppress under column properties. Is it possible to suppress them. If i move my attribute column organization and invoice currency before my line number columns means, then…

Dear AJ, Thanks for the reply. Glad in a getting a response from you almost after an year where you helped for one date calculation logic with OBIEE:-) My requirement is like below: Im in obiee 11.1.1.7.150120. In my analysis i have a count(DISTINCT "Fact1-payroll"."Employee Number") in my edit formula which results to…

Dear Friends, Seems like a product limitation with OBIEE Bug 21571659 - FILTER FUNCTION DOESN'T WORK AS EXPECTED IN OBI - Unable to use "COUNT DISTINCT" with the "FILTER" function ( Doc ID 2138129.1 ) - As per these, filter function in OBIEE does not execute each row line-by-line like the case statement, which is causing…

Hi guys, Any Suggestions. Saro

Thanks Andrew for all your help. Regards, Saro

Hi Andrew, Thanks for the quick response. From that referred link i can see like you have passed this syntax extra {'na'} for handling the "All column values" in the prompt, so you mean to include that to my syntax like below for the "All column values" to work. SELECT "Fact1-payroll"."Employee Number" FROM "8 -…

Hi Manoj/Andrew, Thanks for your replies. As my multi select presentation prompt is working fine with the below query SELECT "Fact1-payroll"."Employee Number" FROM "8 - HR-Payroll" where EVALUATE('to_char(%1,%2)' as char, "Fact1-payroll"."Pyroll Date", 'DD-MON-YYYY')||'('||EVALUATE('to_char(%1)' as char,…

Hi Jack, Thanks for the reply.But i dont think there is an issue with the query like i said earlier that the query works fine with UNION/UNION ALL/INTERSECT. I do have problem only with the MINUS as it is not working in the sql prompt results. Any other possible fix for this problem. Regards, Saro

Though i can see this decimal places in score as a product limitation with obiee 11.1.1.7, as it is been fixed in 11.1.1.9 version. https://docs.oracle.com/middleware/11119/biee/BIEUG/whatsnew.htm#CJAHJCJI Thanks, Regards, Saro

Thanks Gianni for the explanation. Regards, Saro

Dear Gianni, One more quick question, what we are wondering to understand is like how the cube stores the data and how we can view this. Basically we tried to understand this from our ESSBASE developers but their explanation is not much satisfying. Generally with the relational data which is sitting on the tables, view etc…

Thanks for your suggestion Gianni, Let me point out this to the ESSBASE developers. Regards, Saro