0

Can someone enlighten me why this is happening? I am doing a SSAS tabular model with one of the table (refer image in the link below) where the calculated cols as follow:

location_rank =COUNTROWS(FILTER('f_p_txn', EARLIER([fk_p_key])=[fk_p_key] &&EARLIER([start_date])>=[start_date]))

end_date =DATEVALUE(LOOKUPVALUE([start_date], [fk_p_key], [fk_p_key], [location_rank], ([location_rank]+1)))

activity status =IF(ISBLANK([end_date]), "Ongoing", "Done")

What has been calculated and presented in SSAS is correct but when I deploy it and create dataset in SSRS, the output is not tally with SSAS. Noticed in SSRS the date some were correct, some the day and month are mixed up and causing the location_rank become incorrect. then i tried to fix change the start_date and end_date column's properties data type to Date, and tried in different date format like dd/mm/yyyy or mm/dd/yyyy, but the problem still persist. What is causing the mess to happen?

tablel in SSAS tabular model

the dataset I create from the query designer from the above ssas table

Community
  • 1
  • 1
jcy
  • 1
  • 1
  • 8
  • Can you screenshot the dialog where you right click on the project node in Solution Explorer and choose properties? I am wondering if the processing mode setting is set to default and so when you deploy it didn't reload fresh data to SSAS. (The SSAS screenshot is from the workspace database. I assume the SSRS screenshot is connected to the deployed database not the workspace database.) if you connect SSRS to the workspace database does it tally? – GregGalloway Dec 17 '16 at 13:49
  • thanks for your hint! :) – jcy Dec 19 '16 at 08:43

1 Answers1

0

i figured it out. Must specify and transform the datatype of the date column to Date type in SSIS before proceed to SSAS.

jcy
  • 1
  • 1
  • 8