BusinessObjects Board

WEBI 4.2 Issues using merged dimensions and calculation contexts

building reports webintelligence
#1

Hi,

I have 2 queries:

  • Query1:
    ID (Dimension)
    Company (Dimension)

  • Query2:
    ID (Dimension)
    Pay date (Dimension)
    Worked hours (Measure)

I have merged the two IDs

  1. I create an array with 3 columns:
    Query1.ID
    Company
    Worked Hours
    –> result is fine. I have the sum of Worked Hours for each ID

  2. I delete column Query1.ID because I want the total of Worked Hours by Company
    –> result is wrong. There is the same number everywhere in column Worked Hours (equal to the total of all Worked Hours)
    I think this is normal; it’s a context issue

  3. I write next formula in Worked Hours column:
    =Sum([Worked Hours] in ([ID];[Pay date])) In ([Company])
    –> result wrong. Nothing has changed.

I have tried several formulas but nothing is working. I’m going nuts.
Can anyboby help me please ?

Thanks

#2

Hello @CFR67 and welcome to B :mrgreen: B

Did you try just =Sum([Worked Hours] in (Company])? I think having columns in your calculation that are not displayed in the report tab may confuse it.

#3

I think what you are describing requires the ForceMerge() function.

http://www.dagira.com/2009/09/03/using-forcemerge-to-fix-unbalanced-data-providers/

It allows you to remove the ID column (your merge dimension) and still have Webi use it as part of the context.

1 Like