Merge dimension Does not work from two data sources

[former_member360582]

Hi

We are using Merge dimension for a report.

Summary :

We have Network Product code and Text;TSA Product code and text; as dimension objects

Net sales :Measure .

Cognos Product is available on one data provider.

So In order to get Net sales from Cognos perspective we are using merge dimension based on Net work product and TSA product.

We do have Network product and TSA Product from both the data providers and so merge is based on both.

But when we just take the Cognos and revenue in the table it gives just one value and not consolidated

for eg

Cognos product               Net sales 

BB other Products                123

BB Y Product                         123

BB Z product                          123

But if

Cognos Product           TSA Product      Network product      Net sales

BB other product                abc1               xyz1                              23

BB other  product               abc1               pqr1                              56

BB other product                                                                            123 (This value again gives the one sum vales ) The format is break here applied

BB Y product                     def1               lmn1                                  67

etc

So this is the problem I used force merge for each In  but nothing is succedded.

Force merge works well with excel but not with different data providers.

I have one Both the universes and database is Teradata and SQL server

Thanks and Regards

Gaurav.

[Former Member · Accepted solution]

I am not getting clear picture realted to your problem.

Can you please expain by using more detail example.

[former_member360582 · Accepted solution]

Hi

The issue is Merge dimension with Different providers is not giving output for measure.

Data provider 1:

Network product code  (dimension)

TSA Product code        (dimension)

Cognos Product name (dimension)

Data provider 2:

Network Product code  (dimension)

TSA product Code        (dimension)

Net sales                      Measure)

We have merged based on network product and TSA product.

Now the problem is

when we take

Cognos Product from query 2 and Net sales from query 1,net sales does not give any value or just one value for eg

table 1

Cognos Product           Net Sales

BB1                                   456789

BB2                                   456789

BB3                                   456789

It is actually if you take all the objects into the table then it gives exact net sales

table 2

Cognos Product      Network product   TSA Product       Net sales

BB1                         xyz1                        pqr1                    100

BB1                         xyz1                        lmn                        23      sum ( 123 of BB1 )

So Aggregated sum of Cognos we are not getting in table 1

Thanks and Regards

Gaurav.

[Former Member · Accepted solution]

pleaset try any of the one way:

1)

= sum([net sales] foreach(network product;tsa priduct))

or

2)

create a object

obj1 = [network product]+[TSA product]

Now create  detail object

obj_dtl for cognos product and point that object to obj1 .

and now simply drag obj_dtl & measure .

Thanks,

Swapnil

[former_member360582 · Accepted solution]

Thanks

The second part it works

The first part using for each I already used.

Thanks again swapnil.

regards

Gaurav.