SAP Universe design approach

[horynao]

Hello everyone,

I would like to ask about universe design. I like to know some approach, that in my case there are two fact tables and one dimension table. And I would like to let an user to choose period format from table 1 (etc. 2023-01, 2023/01). But there is an issue in database explain plan. If an user select table 2 and table 3 columns and he does not choose period_key from table 1 specifically, the optimizer goes through all rows in table 3. If an user choose period_key, partitioning is applied corectly.

I have following data layer. Table 3 has cca 8 mil. rows.

How can I say to the universe to select data from each table and the partitioning is applied and an user could set only one condition?

Thank you in advance

Best regards

Ondrej

[amitrathi239 · Accepted solution]

Yes, above picture is correct.Once you set the two context then users can drag objects from any table.if users will drag objects from Table2 and table3 in the single query then BO will handle itself (you will see two sql in the webi query sql panel) and accordingly generate the two sql (one for each context ).Thats the purpose of setting up the context.

[horynao · Accepted solution]

Thank you,

Best regards

Ondrej