October 4, 2005 at 8:09 am
Hello there,
I'm a newbie in writing MDX and i can't manage accesing member properties of dimensions. I wrote a query which contains all necessary data (except the member properties)
The query:
SELECT
[intLstKlasse].[intLstKlasse].MEMBERS ON COLUMNS,
NON EMPTY [Leistung_TEXT].[Leistung Text].members ON ROWS,
non empty [PID_FID].[Pid Fid].members ON PAGES
FROM IBIcube_SSB_R1025_1_Buelach
now I want to get the member property "PatientName" and "DateOfBirth" of one Patient, which is explicit identified by the [PID_FID].
Construction of the dimension:
Dimension [PID_FID]
----Level 1 [pid]
--------No MemberProperties
----Level 2 [pid fid]
--------MemberProperties ["PatientName"]
--------MemberProperties ["DateOfBirth"]
--
How can I handle this?
Tobi
October 5, 2005 at 7:18 am
This article may answer your MDX question:
http://www.databasejournal.com/features/mssql/article.php/10894_3107081_1
Your client application will usually handle the viewing of Member Properties. I use ProClarity Desktop Pro and it works beautifully.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply