Hi Gianni, They are the column index in tables for improveing performance. 'dig_ord' in ECP_ODS database is fact table and I do not have right to create any tables,but 'calendar' in ECP_LCL database is dimension and I have some right to modify anything. For some reason, DBA have to creat two database name in SQL Server,…

Hi Joel, Because I want to see the SQL execution plan and want to confirm whether the whole SQL execute the column Index for imporving the performance

Hi Gianni, Thanks for your kindly help. If it will separate into 2 segment,does it execute the index in SQL ? I cannot copy the sql into SQL Server,becuase it is not the whole SQL and I can not see the relationship between tables. Is it the suggestion or workaround to solve this issue? Thanks.(Exculde moving one table into…

Update the latest ODBC drivers,and the issue will be sovled.

Hi Christian, Thanks for your kindly support. Firstly, I do not find the SQL SERVER 2012 in physical payer,but only 2008 or others. I also change the default database type 'SQL SERVER 7.0/2000' into ODBC basic or Advanced, but it does not work sucessfylly. The error message as below: State: HY000. Code: 10058. [NQODBC]…

Hi Experts, This is the configuration informaiton for BI Server, but I want to chang the log size and age with "AdminServer" or "bi_server1" in "\user_projects\domains\bifoundation_domain\servers\AdminServer" ,thanks.

Please help me. Thanks very much.

Hi Gianni Ceresa, Because this one non-calculation index must be changed based on date,you can consider it as the slowing changed dimension. So if it is the requirment, please help me to how to design the model or architecture. Thanks.

Hi Ebin, I try to do it based on the link, but it does not work successfully. Is it the BUG in BIEE 11.1.1.7.1+?

Any suggestion？Thanks for your kindly help.

Is it possibile to do it?

Hi Lamin, My OBIEE version is 11.1.1.7.141014, and install the BIMAD application separately for downloading the related software from Oracle Web. Then patch the latest the files (Patch 21985218) from the following…

Hi Andrewif, Greate , thanks very much. I do not try to use the css style. Firstly, I have tried to hidden the related column in colunm property(Hidden),which does not work.

Hi Arko, I do not understand the exact method (How to set and use the label), could you please say it more clearly? Thanks.

Hi Arko, Thanks. Although your method is not best , it meet the requirement . However, it will spend some time for freshing whole page when the data is big; So I want to know whether I can use the variable to pass to detail report.

Hi Arko, Thsnks for your kindly help. Your link is on Master-Detail event information,which is not my expected result. If I use this function, it will show the drop-down or slider in detail report. Thanks.

Is it not possible to do it?