merged dimensions

[Former Member]

hi

I have made a report that is using 2 querys designed this way:

query 1: object 1, indicator1

query 2: object 1, object 2 -->object 7,indicator1

in my repot the object 1 is the object that is merged.

I ve made an object X in the report that uses some objects from query 2.

I ve also made an object Y that uses object X, object and indicator 1 from query 1 but when I design my table , I ve a serious problem.

I have a #datasynch error in all cells .

I ve tried to make a new Dimensions of type information for all the dimesions that are in query 2 but not in query one to resolve this issue.

this idea gives me a better result but not the best: i have many multi values . this returns to that the dimension that is commun to both of he querys is a dimension that have been defined in the universe that Im using and that this dimension is a Grouping of an other company.

any idea?? thank you

[Former Member]

You should be able to use "indicator 1" with the objects in Query 2 IF it is a measure or detail of "object 1". If it is a dimension then just create a variable with the formula =i[ndicator 1] and tag it as a detail of "object 1".

[amrsalem1983]

query 1: object 1, indicator1

query 2: object 1, object 2 -->object 7,indicator2

you can not include indicator1 with any other none merged dimension

simple answer, wats the relation in your business between the indicator1 and object2, there is no relation, so that indicator1, can only be used when you put merged dimension with all objects , or with objects which exist in both queries,

but once there is an extra objects exist in query2 and not exist in query1, you can not add measures from query1 to the reprot, it will gives you #[DATASYNCH] or something like that.

good luck