SAP SSM Query

[Former Member]

Hi guys

do I have to customize the BW Query or i just can use standard Query by BICA ?

[Former Member · Accepted solution]

so how to add dim manually in the PAS so that it match dim in BW

[Former Member · Accepted solution]

If you have the hierarchy in BW from which you can create the dimension, why would you want to create it manually? That is the idea of the Import schema function in BICA!

If you aren't using BICA you can create a dimension manually using the dimension editor in PAS or by using a  procedure to create dimensions from a source file. Using a procedure is better unless the dimension is pretty small.

Regards

Colin

[Former Member]

Thanks Colin for your quick response

from your words Create schema create some dim in PAS database

what about the rest dim how to create them in the PAS ?

[Former Member]

You can always manually add additional dimensions or metrics direct in PAS. It may well be the case that you have a range of metrics that are not sourced from BW and do not have the same dimensionality as those in BW. Technically no single metric can have more than 12 dimensions but in practice if you have more than 6 dimensions on a metric it will be very difficult to use simply due to of the complexity of the data ( a human issue not a technical one!).

In technical terms BW is 'just another data source' but because BW is so central to SAP environments it makes perfect sense for SAP to have prebuilt the interface into BW. Equally it is quite normal for Actual values to be sourced from a structured source such as BW while the Target cvalues are either loaded from a different source or entered via the manual data entry Entry & Approval component.

Regards

Colin

[Former Member]

Hello Colin

Sorry i didnt get your point ( If you have only created 1 metric in PAS then your import could time out )

do i create metrics in pas by my self or i just import a schema and BICA create PAS structure by itself ?

one more thing if my query has many metrics how can i extract from the only one metric

[Former Member]

Hi,

When you created your model using BICA did you just use the Import Schema link in the tool before going to the Import Data link or did you also use the Define Virtual Measures and Create Scorecard Measures links?

When you used the Import Schema link you created the shell of the PAS database and created some dimensions so that there was a structure for some data. The structure of the queries will generate dimensions in the PAS model. But if you then went straight to Import data you have effectively thrown a lot of numbers at the shell you have created but there is nothing to organise those numbers.

If your query has information about more metrics/measures than you have created in PAS then how is PAS supposed to understand what to do with the rest of the information. You should restrict your query to the information that is required in PAS so that the mapping fits. If you think of it the other way round - what would BW do if you tried to send it a bunch of data of which only some matched up to the structures in BW?

Regards

Colin

[Former Member]

Elhoussiny

Depends on what this query is!

Does it reflect the schema you created in PAS via BICA which created your dimensions? Does the query only cover data that you want to import into PAS or does it cover other elements that are not needed in PAS?

Regards

Colin

[Former Member]

Hello Coling

Actually after I imported Schema i found Dim in PAS as in the attached pic

my problem is when i import Data which is the final step I face this problem

Message V1 timeout during allocate / CPIC-CALL: 'ThSAPCMRCV',

one more thing is the query has all GL aacount with its balance

all i need is only 1 GL from the query which is Revenue

[Former Member]

Hi

You say that you only want 1 metric but it appears that your query has a number of metrics in it. If you have only created 1 metric in PAS then your import could time out because it is trying to work out what to do with the other data that doesn't have a home to go to!

Looking at the screenshot all your dimensions only have 1 level. Your GL dimension has 366 members that all aggregate up to the Total Result level. Technically this is perfectly possible but not seen very commonly in SSM particularly in a scorecard.

Regards

Colin