Grouping/aggregation in universe with two contexts

[Former Member]

Hi,

I have an universe in information design tool in BI 4.1. Source of the universe is a MS SQL Database. The universe consists of two fact tables: sales revenue and incoming orders and several dimension tables. There is a loop that I solved with two contexts. So far everything is fine. When I execute a query with key figures from one of the contexts the result is as expected. But when I combine key figures from the different contexts and a dimension for the date in between, the grouping/aggregation is not working correctly. My report looks als follows:

Year    Sales Revenue    Incoming Orders

2013       1000                           5

2014       2000                           7

2015       5000                         Null

2015        Null                           12

2016         300                            1

When I refresh the report several times it sometimes looks different:

Year    Sales Revenue    Incoming Orders

2013       1000                           5

2014        Null                            7

2014       2000                        Null

2015       5000                          12

2016         300                            1

Is there a setting or parameter in the universe to force the "group by" or something like that. Is this an error or do you have any ideas what could be the reason for this behaviour?

BR

J.

[Former Member]

What is the definition for Sales Revenue & Incoming Orders objects.. They are Measures?

Please provide screen shot of your universe and object definitions in IDT.

I think you problem is with the type of objects. please convert Sales Revenue & Incoming Orders into Measures.

Thanks,
Swapnil

[Former Member]

Hi Swapnil,

they are already measures.

BR

J.

[Former Member]

Just try to set the context in report.

Check below link:

Context selection in webi | SCN

Please provide some more information about your problem. Attach the screen shot.

Thanks,

Swapnil

[Former Member]

Hi Swapnil,

I tested several scenarios and found out, that there is the same issue without using contexts.

When I excecute a query with two measures (one is coming from "fUmsatzerlöse" and the other is coming from "fAuftragseingang" with the Dimension "Jahr" from table "dBuchungsdaten", I get the same result that I already described earlier. It is not aggregating or groupping correctly for dimension "Jahr"

Jahr  Umsatzerlöse    Auftragseingang

2013       1000                           5

2014       2000                           7

2015       5000                         Null

2015        Null                           12

2016         300                            1

When I refresh the report several times it sometimes looks different:

Jahr  Umsatzerlöse    Auftragseingang

2013       1000                           5

2014        Null                            7

2014       2000                        Null

2015       5000                          12

2016         300                            1

The result I would expect:

Jahr  Umsatzerlöse    Auftragseingang

2013       1000                           5

2014       2000                           7

2015       5000                          12

2016         300                            1

BR

J.

[Former Member]

Hello,

Have you tried to set those measures, in business layer, its aggregation measure to None?

regards,