Skip to Content
author's profile photo Former Member
Former Member

dimension produce wrong value

Greetings,

I created a webI document to display students info. for a given semester. I’ve the following objects:

completed credits (measure) and dimensions: course name, start time, year, major, students address, city, state etc.

The report displays the correct completed credits values w/o students address information. But, for some reasons when student’s address information is not included the completed credits value always doubles.

I'm in BI 4.1 environment. Is there a possible workaround for this?

TIA

Regards,

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on May 15, 2015 at 05:55 AM

    You can include the Student's address in the table, right click on it and select hide dimension.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 15, 2015 at 08:10 AM

    Could be an issue with the "Join" definition between the address table and other tables you use here.

    If there is a 1:1 relation based on the student Key and Address Key (primary & foreign key) this should not happen.

    May be in your universe or DB you are trying to look up ZIP code or something like that (which is not a key) which is causing this aggregation issue, when you are not specifically including the address in the result set.

    Regards,

    Naras

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 15, 2015 at 09:27 AM

    It sounds like there is either a chasm or fan trap within the universe which is inflating the results.

    Ask your universe designer to check the relationship between the tables used in your queries (with and without student address) and see what can be done.

    The other possibility is that there is an address type so that you can restrict address to one of those types (e.g. accommodation address versus home address)

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thank you all.

      The address is needed in the report, however I tried to hide student address dimension but didn’t work. As suggested, I’ll discuss w/ universe designer to check for joins, fan trap, chasm etc.

      Regards,

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.