Hi, You can check the query log in Administration Tab for that. Regards, Uma Mahesh.

Sorry my mistake, Comments and Override status working now. I've sent my reply through mail, it posted after two days. Regards, Uma Mahesh

Hi @Gianni Ceresa, thanks for your Reply, I have a doubt, After setting up SA Subject Area,Do i have to enter users Details manually in this table?? Thanks & Regards, Uma Mahesh.

Thank You for Your Reply, Do I have to do any Configuration Changes after this step, Regards, Uma Mahesh.

Thank you, Comments are working now.

Thanks for your Reply, @Gianni Ceresa . do i have to do any configuration changes after this step?? Regards, Uma Mahesh

Issue with Topn or Rank , you can find answer here.

I have one alternative solution for this 1. set sort order for measure column (I'm Applying Descending order) 2. create another measure column like BOTTOMN(RSUM(Measurecolumn),5) 3.if you are using Ascending order then use TOPN instead of BottomN

Hi Kavya, u can set default format for system wide default for one column or data type. for that datatype or column which u have set custom format as default, it will directly apply for the new analysis. Refer this for understanding. https://docs.oracle.com/cd/E23943_01/bi.1111/e10544/format.htm#BIEUG2863

Yes, If you are using pivot table put suppliers column in dimension side and amount column that contains case condition in measure side. u'll get what u want.

As Joel Acha Said Create an DashBoard Prompt(Variable Prompt). which gives you presentation variable like: Amount; Number... in report insert this formula. TOPN("Suppliers Balance column",10 BY CASE WHEN @{PV_DYNAMICSELECT}{} = 'AMOUNT' THEN "Amount Column" WHEN @{PV_DYNAMICSELECT}{} = 'NUMBER' THEN "Number Column" | | END…

Try @{year_pv-1}

Thanks to your suggestion Christian, I agree With You

Yes, Christian It is Really Helpful to me, I know Why we are using BI. But my Clients Wants to load total Records of data in Export, that's why i'm Posting This Discussion. Any how, thanks For Your Support.

Hi all, I've tried to change Print Rows in Print & Export options in DashBoard Edit While exporting the following error coming "we found a problem with some content in 'DashBoardName.xslx'. do you want us to try to recover as much as we can?if you trust the source of this workbook,click yes" Can any one help me, how to…

Hi, Thanks for Quick Reply, I've alredy changed the settings in instanceconfig.xml, now i'm able to export all rows from analysis. now my problem is with dashboard, can you guide me to increase rows in export dashboard. Thanks , Uma Mahesh.

Thanks for your suggestion, but i don't have the old password, i've tried all the ways but i couldn't get it. now i want to change the Schema password. and if i change the schema password where can i change the password in OBIEE 11g Enterprise Manager. Please help me with that. Thank you.

Thanks for your support Thomas

hi Thomas, Thanks for Quick reply but i have some dimension columns too in that table like ACCOUNT_NO what i want exactly is a Report With ACCOUNT_NO filed and MAX of AMOUNT AS Per Dates in a MONTH