I'm trying to validate that I have no differences between my OLAP cubes from server to server after updating dimensions.
What I would like to do is create a report that runs on top of a package published with both identical cubes and build a measure which is basically member(cube1.amount-cube2.amount)
I've been able to union the two cubes using the same data items from each query but the report has only 1 row and doesn't seem to be able to tell me which cube the amount is pulling from in the list. I've also tried member(cube1.amount-cube2.amount) inside my union but the report is just running indefinitely.
Quote from: rarisnrovers on 21 Apr 2015 01:26:06 PM
I'm trying to validate that I have no differences between my OLAP cubes from server to server after updating dimensions.
What I would like to do is create a report that runs on top of a package published with both identical cubes and build a measure which is basically member(cube1.amount-cube2.amount)
I've been able to union the two cubes using the same data items from each query but the report has only 1 row and doesn't seem to be able to tell me which cube the amount is pulling from in the list. I've also tried member(cube1.amount-cube2.amount) inside my union but the report is just running indefinitely.
Hi,
This sounds like exactly the sort of task Lifecycle Manager is designed to do for you. It's included with Cognos 10 - have you taken a look at it?
MF.