This project is read-only.
1
Vote

wrong target database in [ssas].[populate_olap_query_log_table]

description

in the documentation you write:
  1. Create_Table_SSAS_OLAPQueryLog.sql – This Transact-SQL script creates the OLAPQueryLog table in the MDW_Control database on the MDWDataCollectionServer.
  2. Populate_OLAP_Query_Log.sql – This Transact-SQL script creates the Populate_OLAP_Query_Log_Table stored procedure in the MDW_Control database on the MDWDataCollectionServer.
     
    You write about MDW_Control database, but in the [ssas].[populate_olap_query_log_table] is only a parameter for the mdw database:
    @mdw_database_name nvarchar(128) = null
     
    This is OK - but the code for inserting has:
     
    INSERT INTO ' + @mdw_database_name + '.[ssas].[OlapQueryLog]
     
    and this is wrong, because the [ssas].[OlapQueryLog] is not in @mdw_database_name but in the current database (for example mdw_control)
    the above line shoud be changed to
    INSERT INTO [ssas].[OlapQueryLog]

comments