Author Topic: DMR report query and error msg  (Read 439 times)

Offline sukanya

  • Full Member
  • ***
  • Join Date: Apr 2016
  • Posts: 32
  • Forum Citizenship: +0/-0
DMR report query and error msg
« on: 23 Aug 2016 02:28:18 pm »
In DMR report query, I see my query like below:

SELECT
  NON EMPTY CROSSJOIN([Dimensional_GO].[Gotg].[Oute].MEMBERS,

While publishing the package I see this message:
BMT-MD-6006 The package contains orphan dimensions that are not in scope with other measure or regular dimensions. Queries that reference regular and measure dimensions that are not associated with a scope relationship may not run. The orphan dimensions are Bal Fact

Is there some thing I am doing wrong in the model. Is the query supposed look like normal joins. Kindly let me know.

Thanks,

Offline bdbits

  • Super Moderator
  • Statesman
  • ******
  • Join Date: Feb 2010
  • Posts: 1,742
  • Forum Citizenship: +102/-0
Re: DMR report query and error msg
« Reply #1 on: 23 Aug 2016 04:51:59 pm »
Dimensional queries use MDX, not SQL, and don't really have joins as you may be used to in SQL.

The error message means Bal is not in scope with Fact. You need to make sure the underlying relationships are properly defined, then set scope (if I recall correctly right-click the key to set scope).

Offline bus_pass_man

  • Community Leader
  • *****
  • Join Date: May 2008
  • Posts: 229
  • Forum Citizenship: +30/-0
Re: DMR report query and error msg
« Reply #2 on: 23 Aug 2016 07:35:55 pm »
You set the scope in the dimension map.  Scope is the definition of granularity of a fact to a level in a hierarchy.

The list is only of dimensions which are orphans.  I'm assuming Bal Fact is one of your measure dimensions.

Offline sukanya

  • Full Member
  • ***
  • Join Date: Apr 2016
  • Posts: 32
  • Forum Citizenship: +0/-0
Re: DMR report query and error msg
« Reply #3 on: 25 Aug 2016 06:39:46 pm »
seeing a cross join in the generated sql doesn't indicate there is anything wrong with my model?

Offline bdbits

  • Super Moderator
  • Statesman
  • ******
  • Join Date: Feb 2010
  • Posts: 1,742
  • Forum Citizenship: +102/-0
Re: DMR report query and error msg
« Reply #4 on: 30 Aug 2016 05:12:00 pm »
Relationships and scope are part of your model. So yes, you could say there was something wrong with the model.  ;-)

Seriously, if you fix relationships/scope, you will likely find the generated code is going to change.

 



           
Twittear