on 2015 May 11 10:45 AM
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.
I am not getting clear picture realted to your problem.
Can you please expain by using more detail example.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
75 | |
10 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.