Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

mdx query to identify unique members of one dimension used..

 
   Database Forums (Home) -> OLAP RSS
Next:  Grab Random Percentage of Records  
Author Message
gdhmail

External


Since: Sep 24, 2007
Posts: 1



(Msg. 1) Posted: Mon Sep 24, 2007 10:57 pm
Post subject: mdx query to identify unique members of one dimension used in a cube
Archived from groups: comp>databases>olap (more info?)

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.

 >> Stay informed about: mdx query to identify unique members of one dimension used.. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
[Cognos] Count only unique - Hi How can i creat counted measure, which will count only unique values ?? Thanks

CaseInfo as Fact or as Dimension - I am modeling a system for a Judicial (Criminal, Civil etc) client and most of my users are Judges and Court Administration who are interested in Monthly Detailed and Summery Reports of the Cases. Critical measurements are Case Age(Number of days Case..

Makes an AGE dimension sense ? - Hi, I am new in designing a data warehouse. Does it makes sense to have a dimension table called AGE where maybe numbers from 10 - 100 are in it? Maybe I should callculate the age in my query ?! I think it is OK to have a TIME dimension wich is..

Business ration as dimension ?! - Hi, we have a discussion about designing a data warehouse. One suggestion was to have all business ratios as dimension. The fact table is a combination of some diemnsions plus the business ratio dimension. These relationships are building the primary ke...

Structuring a geography dimension -
   Database Forums (Home) -> OLAP All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]