Skip to Content
0
Former Member
Dec 22, 2014 at 07:10 PM

Save data manually from BO analysis for MS to BW Real Time InfoCube

35 Views

Hi experts,

We are trying to save data from BO analysis for MS into BW real time infoCube. In order to perform this task we followed the steps below:

1- We created a real time infoCube in BW system:

Dimensions:

Product, Customer, calendar year, calendar quarter, calendar month, Country, Region

Key figures:

Amount + currency unit , Quantity + quantity unit.

2-We loaded a set of data to the InfoCube.

3-We created an aggregation level countaining:

Dimensions:

Product, Customer, calendar year, calendar month, Country

Key Figure:

Quantity + quantity unit

4-We created a filter on the aggregation level using the Country dimension = 'MA'

5-We created a query using Bex query designer with following customizing:

***Rows:

Product, Customer, Calendar year, calendar month.

***Culumns:

Quantity

***Customizing:

In the planning tab for the query: Start Query in change mode

In the planning tab of the quantity Key Figure: Input Ready (Relevant for locking)

We want to save data from the Excel to the BW real time InfoCube using BO Analysis for MS. Unfortunatly, the "save data" button is desabled and the quantity cells are locked. See screen shot below:

BW System 740 SP08

BO Analysis1.4.0.2528

How can this be performed? Are we missing somthing?

Thanks in advance

Attachments

skiri.PNG (91.3 kB)