yes Reza, i have done that and then i saw that the in cube we have dimentions in a sequance but in dataset the sequance is changed. to get the sequance of dim in cube i have used ADMO object, not the display that we have in cube. as we know that the cube display is different as per the internal sequance of Dims.... Anirban Biswas (v-anbis@microsoft.com)

Put a break point in line of script task and check this: do you populate list of cube dimensions in correct order? breakpoint will pause control flow and show you the execution line and you can use watch window to track scripthttp://www.rad.pasfu.com

Hi I am using Usage Based Agg in my cube. For that I have enabled OLAPQueryLog in SSAS Properties. I am getting data in my OlapQueryLog table. in this table there is a column Dataset which is having data in 00000,010,000000,000,010,00000,011000,01011,000000000,000,0000,0000,000000000000,010,00000,000,0000 format. I have created a SSIS package and I have a script task where I am using ADMO object to get the list of dim and the attributes the user have queried on. It seems that the Dataset in the OLAPQueryLog in getting populated correctly. I have queries my cube and took the same row with my user name and starttime and the dataset. The dim and the attributes that I am getting from the dataset is not the same. Can anyone tell me if I am wrong in my script? Dim as_server As New Microsoft.AnalysisServices.Server Dim as_db As Microsoft.AnalysisServices.Database Dim as_cube As Microsoft.AnalysisServices.Cube ssas_server_name = Dts.Variables("ssas_server_name").Value ssas_db_name = Dts.Variables("ssas_db_name").Value ssas_cube_name = Dts.Variables("ssas_cube_name").Value as_server.Connect(ssas_server_name) as_db = as_server.Databases.FindByName(ssas_db_name) as_cube = as_db.Cubes.FindByName(ssas_cube_name) Dim i As Integer Dim j As Integer, dimIndx As Integer, attIndx As Integer Dim newDim As Boolean Dim dimName As String, attName As String Dim insert_values As String dimIndx = 0 : attIndx = 0 dimName = "" For i = 0 To Len(olap_dataset) - 1 Select Case olap_dataset(i) Case "," dimIndx = dimIndx + 1 attIndx = 1 newDim = True Exit Select Case "0" Exit Select Case "1" If newDim Then If dimIndx >= as_cube.Dimensions.Count Then Exit Select dimName = as_cube.Dimensions.Item(dimIndx).Name newDim = False End If If attIndx >= as_cube.Dimensions.Item(dimIndx).Attributes.Count Then Exit Select attName = as_cube.Dimensions.Item(dimIndx).Attributes.Item(attIndx).Attribute.Name.ToString() MsgBox("Dim Name: " + dimName + " Att Name: " + attName) attIndx = attIndx + 1 End Select Next Any comments would be really helpful. Anirban Biswas (v-anbis@microsoft.com)

this is the answer... http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/463f8b86-3574-4917-b181-4e0a701dba95 Anirban Biswas (v-anbis@microsoft.com)