December 3, 2013 at 5:17 am
There are two Cube Databases in the same server with identical schema.
In than we have created a ProjectID dimension on an Unique identifier (GUID) Column...
When i execute an MDX query and fetch the result i am getting two different type of result from both databases.
One Cube is returning simply GUIDs while the other is returning them enclosed in "{}".
We have to compare the result with another table so we are facing problem.
I have checked the properties but could not find any difference.
Please help me understand why this difference is occurring and how to get the same format in both.
Thanks,
Karthick.
December 5, 2013 at 6:39 am
ard5karthick (12/3/2013)
There are two Cube Databases in the same server with identical schema.In than we have created a ProjectID dimension on an Unique identifier (GUID) Column...
When i execute an MDX query and fetch the result i am getting two different type of result from both databases.
One Cube is returning simply GUIDs while the other is returning them enclosed in "{}".
We have to compare the result with another table so we are facing problem.
I have checked the properties but could not find any difference.
Please help me understand why this difference is occurring and how to get the same format in both.
Have you used a tool like SSAS Compare (free from RedGate) to ensure that the two cubes are structurally the same? Are they pointing to the same or different datasources?
Rob
January 8, 2014 at 6:17 am
We have not used any tools to compare, but the same solution is being used between both Cubes and the underlying Data sources.
I am positive that they are having the same Schema structure. Only the data will be differing between the two systems.
Thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply