Hi Everyone,

I have a cube with revenue as the measure. CompanyId is one dimension
and CompanyType is another dimension.

It is possible to get a list of companies which belong to a particular
company type?

If I give the MDX query
select [Co].[Co Name].Members on columns from MainCube
where [CoType].[All CoType].[IT]

(IT being one of the Company Types) -

I get all companies, and not just the companies that are of IT type.

If I make company as a child level of the company type, then I can get
all children of [CoType].[All CoType].[IT], but I will need to get
companies by more than 1 independent criteria -
for example - list of all companies which are of "IT" type and are
located in the state GA and have number of employees > 1255.

Is there are way one can use cubes for this, or normal SQL and OLTP db
is the way to go?

I am totally new to OLAP and MDX - so any pointers will be really
appreciated.

Thanks and regards

Vani Murarka

By creating independent dimensions, in terms of cube metadata, there is no
relation between companies and types, that is to say, you know that such and
such company will only have data corresponding to a specific type, but
Analysis Services does not.
It would perfectly possible to have data for a given company distributed
among several members of the company type dimension.
You might evaluate using member properties (and eventually building virtual
dimensions from them).
If you did, you could use filter expressions, such as:

filter([Co Name].members,[Co Name].currentmember.properties("CoType")="Some
Type") on Rows

HTH,
Brian
www.geocities.com/brianaltmann/olap.html

"Vani Murarka" wrote:

Vani,
it seems to me that you are dealing with a level of the same dimension:
dimension Company that has ID as the key and Type as an upper level...

"Vani Murarka" <vani.murarka (AT) gmail (DOT) com> ha scritto nel messaggio
news:966ff27a.0410180424.38125b71 (AT) posting (DOT) google.com...

Hi Vani,

this filter on the companies should return the expected results:

with set [IT Companies] as
' Filter ([Co].[Co Name].Members, (Measures.Revenue, [CoType].[All
CoType].[IT]) > 0 )'
select { [IT Companies] } on columns from MainCube

cheers,
Matthias

"Vani Murarka" <vani.murarka (AT) gmail (DOT) com> schrieb im Newsbeitrag
news:966ff27a.0410180424.38125b71 (AT) posting (DOT) google.com...

I think Matthias is on the right tract with the filter, but I would use
the "isempy" for the condition rather than
" > 0", since in theory there could be a valid Company/Type combination
that happened to have has zero revenue.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!