May 16, 2017 at 10:43 pm
Hello Everyone ,
We need help to write MDX query to capture below requirement :
We have multiple Cubes in separate database on single server requirement is to create one tabular report to measure summary value (basically count of requests ) against common dimension as below mention Snapshot:
Jan Feb March
Prod ( Measure count from Cube A) ( Measure count from Cube A) ( Measure count from Cube A)
Prod ( Measure count from Cube B) ( Measure count from Cube B) ( Measure count from Cube B)
Prod ( Measure count from Cube C) ( Measure count from Cube B) ( Measure count from Cube B)
We do not have flexibility to bring these measure into single Cubes.
Any help will be highly appreciated .
Thanks
Alok
May 18, 2017 at 7:32 am
Write three separate queries against the three cubes. Can you have three separate datasets in SSRS (or whatever reporting tool you're using) and do the combining of the data there?
Use the LOOKUP() in SSRS. This may not work for your data/situation, but it's a thought.
I hope this helps,
Rob
May 18, 2017 at 9:57 am
Thanks Rob. We are working on same approach what you have suggested . Thanks for reply.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply