Hello:
I am very new to cognos. I am trying to do the following:
1. Use iqd file to retrieve data from an oracle database. This gives me most of the data I need for analysis. For example, I get the following columns from this query:
Month_End_Date, Region and Sales.
2. However the data retrieved above needs to be adjusted using an excel file which contains three columns, the same as above - Month_End_Date, Region and Sales but just a handful of records.
I have successfully added the two data sources to Transformer. I have added Month_End_Date and Region from (1) as dimension and Sales from (1) + Sales from (2)as a measure. When I generate the cube, it appears the grand total of sales from (2) is being added to each and every cell in (1). In other words, the adjustment is not taking place by matching the Month_End_Date and Region in both files. What am I doing wrong?
Thanks in advance.
I am very new to cognos. I am trying to do the following:
1. Use iqd file to retrieve data from an oracle database. This gives me most of the data I need for analysis. For example, I get the following columns from this query:
Month_End_Date, Region and Sales.
2. However the data retrieved above needs to be adjusted using an excel file which contains three columns, the same as above - Month_End_Date, Region and Sales but just a handful of records.
I have successfully added the two data sources to Transformer. I have added Month_End_Date and Region from (1) as dimension and Sales from (1) + Sales from (2)as a measure. When I generate the cube, it appears the grand total of sales from (2) is being added to each and every cell in (1). In other words, the adjustment is not taking place by matching the Month_End_Date and Region in both files. What am I doing wrong?
Thanks in advance.