Skip to Content
0
Former Member
Jan 14, 2012 at 03:07 PM

Granularity of data tables for analysis

88 Views

Hi Gurus,

I have an understanding question when the data tables / data sources is self developed and no standard data sources are used.

I have one data table (view) with primary keys and key figures:

Primary key:

ccar - credit control area.

compc - company code.

cust - customer.

salorg - sales organization.

salch - sales channel.

saldiv - sales division.

profc - profit center.

busseg - business segment.

busunt - business unit.

Key figures:

turn over

payments

open items

etc.

Those data sets are uploaded to data warehouse.

Now my question is, with each data set it should be possible to analyze with BEx Analyzer, for example

payments by customer.

payments by company code.

open items by customer and company code.

open items by credit control area.

One data set is available for the whole primary key combination (from fields ccar up to busunt).

Is my understandig correct?

Thank you in advance!!!