April 6, 2016 at 3:19 am
Hi, we are having some trouble and I'm confused.
We have a process which imports data and then builds a cube, this has been running for years.
We have recently set up a new development SSAS server, the problem is that when we take the cube on the new dev server and point it at the same data source as the live cube, it produces slightly different results to the live cube.
We've narrowed it down to one record and it appears to be returning slightly different data due to some differing behaviour with the date format.
I've checked the machine settings, SSAS defaults and they all appear the same (see attached), can someone tell me what other settings that may affect usage of the date format so I can check them.
Thanks,
Nic
April 6, 2016 at 8:04 am
I think I've got this, it was an incorrect service account config.
All though no one replied, thank you to those who took the time to read the post.
Thanks,
Nic
April 6, 2016 at 8:46 am
NicHopper (4/6/2016)
I think I've got this, it was an incorrect service account config.All though no one replied, thank you to those who took the time to read the post.
Thanks,
Nic
Hi Nic,
This is an interesting (and esoteric) issue. Do you mind going into a bit more detail as to your fix? Thanks
April 6, 2016 at 8:53 am
Not at all.
The issue for me was that the account the SSAS agent was running as had a default language of 'English' in the database engine, so when it was getting the data from the view it must have been using the YMD date format.
Changing the login on the database server to be 'British English' corrected this and the data was then as expected.
I hope that helps.
Thanks,
Nic
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply