cancel
Showing results for 
Search instead for 
Did you mean: 

Which data model is better in this case?

Former Member
0 Kudos
41

Hi all,

there's a problem we've faced while modeling data for reporting and would like to ask for help.

There's Cube1 with characteristics: store, date, pos terminal and key figures Sales@Retail, Sales@UOM

And Cube2 with chars: store, date and key figure Customer Flow.

In reports we need to get the Customer Flow value for each line in Cube1, but it doesn't exist for each store.

So we see now two ways of solving this:

1st one is - creating infoset with cube 1 and cube 2 joining them with store and date. Then creating a multicube with Cube1 and our new infoset and basing the report on that multicube.

This way we'll get the customer flow for each store where there is one, and get no customer flow for each store where there's none loaded.

2nd way is - creating infoset with cube1 and cube2 using the left join by store and date. This is kinda simplier, but SAP doesn't recommend to use left joins, and it doesn't seem to work well enough.

So which way is better?

Thanks in advance,

Andrey

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi everybody,

thanks a lot for your advice

Best regards,

Andrey

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Andrey,

Its better to follow the process suggested by Simon,for long stand DSO gives more flexibilities than cubes.Then go for the easy lookups, if ur using BW7.3 version u can use the rule type Read from DSO for simple lookup.

Thanks

Rams

former_member197665
Participant
0 Kudos

I don't think that solution two is possible because I think that a left outer join between two cubes is not possible in BW. Did you think about a lookup in the transformation which loads data into cube1 to read the customer flow? If you have the data from cube 2 in a DSO this would be a possible solution with the advantage of better reporting performance compared to solution 1.

jagadeesh_mandepudi2
Active Contributor
0 Kudos

Hi

Seems first solution is good for long stand.

Jagadeesh