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

BPC MS 7.5 MDX query return all nulls

Hi Everyone,

I am fairly confident with BPC, however I am fairly new to the analysis server side of things. I am trying to do a simple MDX query on a cube however it always returns NULL results. Also when explore the cube through the browser I get blanks for the result.

I have tried quite a few things

-Processed the application set

-Optimised the application set

-Manual Processed the cube and partition

-Changed the security

-Changed the aggregation method and designs

All with no luck. I know that there is data in the corresponding fact tables and when processing the cubes its says there is 63 K of rows read. I have also checked the measures and ensured the aggregation type is SUM.

I hope someone can help

Cheers

Cameron

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 30, 2011 at 06:05 AM

    Hi Patrick,

    Yes its standard for SSAS cubes to do aggregation with out all dimensions, this is why I was thrown off by the BPC cube. The property IsAggregate was set to false for the last association in the association chain for a dimension. the default for cube is true. Turning all the dimensions to IsAggregate=True sets up proper aggregation.

    Thanks again for your help,

    Cheers

    Cameron

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 28, 2011 at 08:45 AM

    Hi Cameron,

    Not sure to really understand your point, but from where are you browsing the cube in SSAS?

    Do you use the "Browse" link, when right-clicking on a specific one?

    If yes, here you have to drag&drop particular dimensions either in rows, columns (for example account and time), and also use the section above the result grid to filter any other dimensions (for example category, rptcurrency, entity, ....)

    After defining every dimensions, then, drag&drop "Measures" in the data section, and you then should be able to see some aggregated data in the result table.

    Hope it will help.

    Kind Regards,

    Patrick

    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.