Skip to Content
author's profile photo Christophe FREY
0
Christophe FREY

WEBI 4.2 Issues using merged dimensions and calculation contexts

Posted on Feb 23 at 10:34 AM 19 Views

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. It seems so easy...
Can anyboby help me please ?

Thanks

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Ayman Salem
    Ayman Salem
    Posted on Feb 23 at 10:56 AM
    0

    Define a new variable from the [company] as the Detail of the ID and then use it in your table.

    ..

    hope that helps


    mq.jpg (64.8 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.