Data load per Flatfile

[martin_bako]

Hallo every body,

I have the following problem, may be could somebody help:

I create a Cube with Three Dimension (Product, Campaign, Dist. Store) which contains three InfoObject with the same names.

Key Figures (Campaign Cost, Sales Quantity, Revenue) and

Nav. Attributes( Manufacturer, Product Category) which are the attributes of InfoOject Product.

I tried to fill this Cube with Sales Data and Campaign Data from two flatfiles as follows:

- Sales Data has the following Data (Distribution Store, Cal. year / month, Campaign, Product, Sale Quantity, Product Price, Revenue)

- Campaign Data has the following Data (Campaign, Distribution Store, Cal. year / month, Campaign Cost)

And also I have filled the InfoObject Product with Master Data from a FlatFile:

(Product, Product Category, Manufacturer)

The load of the Data in the Cube executed through two InfoSources.

<b>First Problem:</b>

I load first the SalesData in the Cube and then the Campaign Data which should fill the empty field (Campaign Cost) in the Cube, but it does not, it adds new data rows with CampCost and 0,00 Sales quantity and Revenue, so what happen in the Cube after loading the Campaign Data looks like this:

Campaign cost Sales Quantity Revenue

300,00 0,00 0,00

235,00 0,00 0,00

. . .

. . .

344,00 0,00 0,00

0,00 3455,00 5678,00

0,00 4567,00 5643,00

0,00 3453,00 6788,00

So, can anybody tell me what my fault was and how can I fill exactly and only the empty field Campaign Cost in the Cube by loading the Campaign Data which also contain only Campaign Cost?

<b>Second Problem:</b>

I create a Query to show the Revenues Data according the Manufacturer which is a Nav. Attribute in the InfoObject Product. But the result is, it shows the Manufacturer but no Revenues Data (empty).

But when I insert Product and Distribution Store additionally to the Manufacturer under the Rows in the Query Designer it works.

So why it does not show Revenues Data only according the Manufacturer, what is being wrong?

I appreciate any help and thanks in advance

Martin

[Former Member]

When Sales data is loaded into the Cube only the corresponding key figures from the flat file are filled,likewise for Campaign load..The functionality you expected would work only in an ODS.Cube is not designed to be overwritten based on few key fields. The end result (in the query output) would show up a single record(row) with all the key figures values from both datasources.

One option you might want to consider is to have the data loaded to an ODS & then to a Cube.

[martin_bako]

Hallo Jerome,

I think you are right about my first problem, but what about the second one:

I tried to show the Sales quantity and Revenues according to manufacturer in a Query,

the result show the Manufcturer and sales quantity but no Revenues Data (Manufacturer is an Nav. attribute of InfoObject Product).

and it does show the Revenues data when I add Product and Distr. Store to the Qeury.

Thanks

martin