Home » Developer & Programmer » Data Integration » OLAP and MDX
OLAP and MDX [message #366942] 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: OLAP and MDX
Next Topic: Business Intelligence Tools
Goto Forum:
  


Current Time: Sun Nov 27 23:03:36 CST 2022