Thank you for your suggestion.

Hi Robert, The data is not calculated in summary table as before, since when uses select multiple date, the result for counts=1 did not be summarized(It will be calculated repeatly).

Hi Robert, Yeah, your understanding is correct. count is one column created in DB and is on behalf of order numbers by one day、one customer and one platform. Your suggestion is firstly that I should aggtegate this "count" coumns in logical layer for sum , and users should be filter it in ad-hoc and drag customerID in…

Hi Christian, Maybe you misunderstand my meaning. I know OBIEE is not equal to SQL query, I only expressed my business requirement for writing SQL for understanding easily. However ,I cannot know how to create final measure for implementing this quirement. Because users do not do complex operation in ad-hoc. and they want…

Hi Robert, Yeah, it can be created multiple columns for generating final measure, but I do not know how to create it based on this requirement. IF I create one meause for sum(orders columns), and filter it for sum()=1，but I do not count customerId columns based on last condition

Hi Christian, Maybe I can not write clearly. You can see my sample SQL, I should count users for ordering one time in a period of time. One aggregarition is sum(orders) in a period of time and count() =1, and find these users,then count distinct it PS: the aggregate is on different basical index

Hi Christian, It does work. Thank you very much.

Any suggestion?

Yeah， the issue is also same, can you test it in this scenario for importing data from SQL Server?

I only use the windows ODBC drivers, not native SQL Server drivers,Because I do not know how to use the native SQL Server drivers.

Yeah, I have checked this option for 'synonym' in RPD, but it does not be OK. You can click on mouse in my screenshot to view the detail steps.

Hi Christian, The name "SQL Server driver" is the old, and I download and install the latest SQL SERVER drivers named "ODBC Driver 11 for SQL Server" from Microsoft Web.Some tables are created in ECP_LCL DB and some tables are created in ECP_ODS DB. In order to improve the performance for joining different tables in…

Hi Robert, The actual navigating link as below, which is not '=' , and replace the dynamic code with clicking vlaue. http://mstg.mcd.com.cn/Store/1400007 So is there any method for implementing this requirement?

Hi Christian, I do not see more detail inforation for Navigate to a Web Page, is there any useful sampe for this function? Thanks.

Hi Robert, It is on dimension column and generate the following error message.

Hi , OK ,got it. It does not be implemented in table. Is it impossible to do it?

Yeah， it is the same user account and password. It is very strange. By the way, I only write the following code for testing :Is there any missing steps? CREATE SYNONYM [dbo].[DIGL_ORD] FOR [ECP_ODS].[dbo].[DIGL_ORD]

Hi Joel, Thanks for reminding me. After I create the synonyms with the following code in SQL SERVER, and I can see the related synonyms tables in SQL SERVER, but do not see them when I import data by RPD. What happen? CODE :CREATE SYNONYM [dbo].[DIGL_ORD] FOR [ECP_ODS].[dbo].[DIGL_ORD]

Hi Gianni, Could you please tell me how to do it by step? Thanks very much

Hi Christian, I am sorry. I do not understand what you mean.