PDA

View Full Version : I can´t see the originalmember of dimension Account



Claudia
02-24-2007, 02:15 PM
Hello,


I need to obtain the originalmembers (id´s) of my differents dimensions. I´m obtaining these id´s except of the account dimension, the difference of this dimension is only its parent-child.

My MDX is:

Select distinct(
{
[Measures].[Amount]
}) on columns,
non empty distinct(
CrossJoin(
Descendants({[Dune].&[-7]},,leaves),
CrossJoin(
Descendants({[Auxiliar].&[85000000]},,leaves),
CrossJoin(
Descendants({[Version]},,leaves),
CrossJoin(
Descendants({[Periodos].&[-8]},,leaves),
CrossJoin(
Descendants({[Cedulas].&[347].children}),
CrossJoin(
Descendants({[Moneda]},,leaves),
Descendants({[Unit].&[4]},,leaves)
))))))
)
Dimension Properties Dune.OriginalMember, Auxiliar.OriginalMember, Version.OriginalMember, Periodos.OriginalMember,
Cedulas.OriginalMember, Moneda.OriginalMember, Unit.OriginalMember
on rows
from [Gicsa_1]

This query work properly but don´t show the mem_id of the account. What Can I do to resolve this?