Skip to Content
0

Merging dimensions from different universes

Apr 20, 2017 at 12:23 PM

54

avatar image

I have two different queries from different universes. The queries are from existing reports. I have merged two dimensions from these two queries. Now after merging, on pulling in a measure to the report table, the values are shown inflated and wrong. Please help me in finding where would be the mistake?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Mahboob Mohammed Apr 20, 2017 at 01:02 PM
0

Hi Dinesh,

Would you be able to add a screenshot here? If it's confidential data, how about create some data and recreating your issue?

Thanks,
Mahboob Mohammed

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Mahboob ,

Thanks for the reply. I will explain the issue elaborately in points. If not clear let me know, i will post recreating sample issue. Also pls share your email id to post details.

*There were two separate reports having common data.

*Measures from one of the report was asked to be inserted into another report.

*First report had one query and the second report had three queries. Both the report were using two different universes.

*So merged two common dimensions from all the three queries.

*After merging while the measures from one of the queries were dragged into the report table, the values seems to be inflated or wrong.

Kindly let me know the possible mistakes that would have been made.

Thanks,

Dinesh

0
Niraj Parihar Apr 21, 2017 at 03:56 AM
0

You may have to use calculation contexts while dealing with measures in case of merged dimensions. Please post some example so that we can work out accordingly.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

There are duplicates even after merging two dimensions. There are no dimension through which duplicates can be avoided. In this case is calculation context the solution??

0