Home » Developer & Programmer » Data Integration » OLAP and MDX
OLAP and MDX [message #366941] Fri, 28 July 2000 19:10
arindam mukherjee
Messages: 2
Registered: July 2000
Junior Member
How do I use vba string functions in MDX queries? The on-line help says that the functions can be used but I can't figure out the right syntax for it. PLEASE HELP!
I want to take the first letter from a level i.e.(NET INCOME in the e.g. below) and display it.

For eg.
WITH MEMBER DIMENSION.NET INCOME.A AS 'LEFT({DIMENSION.NET INCOME.MEMBERS,1})'
SELECT
measures ON COLUMNS,
DIMENSION.MEMBERS ON ROWS
FROM CUBE a.
Previous Topic: Oracle 8 data warehousing
Next Topic: OLAP and MDX
Goto Forum:
  


Current Time: Thu Mar 28 19:26:37 CDT 2024