Skip to Content
author's profile photo Former Member
Former Member

Data load per Flatfile

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Nov 25, 2007 at 07:23 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.