Yes what you told is correct but, Business User create this report. hence it will be good to create a report as is and get output in one row. by changing any logic in RPD

this need to be my output

In %Spend in Pivot Table, i should get (27850590/387213414)*100 but it is taking the individual amounts, can you please give me the solution for that

Thank you. It is working now.

Thank You so much for this information,. i have created 2 Criterias and 1 st criteria has Top 1 % and second criteria has Top 2 to 10% but when am trying to do union all between this two criterias, am unable to get second criteria results,

Hi asim Here we got millions of customers so that wont be a case. You have any solution for this.. please help me out. Thanks

Yes, Your point is correct but in my case that wont happen. can you please explain the previous comment which you have posted. Thanks

It is helpful, Thankyou can we achieve the same with the bar graph

Thanks the issue got solved. Made init block as default

OBIEE got upgraded to 12c, rpd which is deployed in 11g now i want to deploy the same rpd in 12c. when am opening the 11g rpd using 12c Administration tool it is giving this errors. ->how to migrate from rpd from 11g to 12c. can you please help me on this Thanks, Nikhila

Thank you for replay We have Initialization Block for user, where this rpd is not throwing any error when i use this in 11g, when i open this in 12c Administartion tool it is giving this session variable errors.

Hi Christian, Am also looking for same kind of information. could you please share me connection request with me. Thanks, Nikhila

It is to fetch the duplicate Records Where member ID, processed date and PNR # are the same, So that filter will give Dublicate records

Yes Asim I tried checking that but i didnt find any difference between those 2 Queries this issue am facing when i pulling Transaction_id or Transaction_num, for rest of columns from same table are giving results

As this queries are generated From Analytics this are giving the same results which we are getting in Analytics, Query with out inculding Transaction Id: is giving dublicate records Query after inclusing Transaction Id: is ging no data

Query with out inculding Transaction Id: select count(to_date(T155348.X_PROCESS_DATE)) as c1, count(T155106.X_MEMBER_NUM) as c2, count(T155348.X_PNR) as c3, 1 as c4, T155106.X_MEMBER_NUM as c5, T155348.X_PNR as c6, to_date(T155348.X_PROCESS_DATE) as c7 from W_LOY_TRANSACTION_ID_D T155348 /* Dim_W_LOY_TRANSACTION_ID_D */ ,…

After adding this OR Condition in this Expression and save, automatically it is changing it to AND, Can You help me with this please

Cant we use one column for more than one time

i followed https://wapcobiee.wordpress.com/2015/08/27/obiee-send-content-to-ftp-server-network-folder/ this link to place OBIEE reports into ftp. May be BI publisher have OOTB, but i think OBIEE Doesn't have OOTB functionality. Thanks