Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Olap > mdx query to id...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 1190 of 1280
Post > Topic >>

mdx query to identify unique members of one dimension used in a cube

by gdhmail@[EMAIL PROTECTED] Sep 24, 2007 at 11:38 PM

Is there a way to write an mdx query that could list the members on a
single dimension where a non-missing, non-zero datapoint is
populated.

I have six dimensions time, scenario, currency, year, entity,
accounts.

I know the scenario value is = ECO

I want to produce the unique list of accounts used across all
permutations of time, currency, year, entity, and ECO.

new to mdx so excuse me if this is obvious.
 




 1 Posts in Topic:
mdx query to identify unique members of one dimension used in a
gdhmail@[EMAIL PROTECTED]  2007-09-24 23:38:59 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Thu Jul 24 3:07:23 CDT 2008.