| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
