Argent
please help me

I have query that works in SQL

select
substring(account, 0 , 6), substring(account, 6, 3), substring(account, 8,
3)
from lc_dw_accounting_csv


How do I do in OLAP

Dimension called Account (11111200900) need to be split into three different
dimensions
Account_number = 11111
Itemn_number = 200
Sub_item = 900

Please help me
Thanks

You can use VB scripting function to extract the substrings

I would suggest creating a view in SQL or creating calculated columns in
the DSV if you are using AS 2005. Then you can use the SQL syntax.

You can use VBA functions from within MDX to extract substrings, but I
think you will find it more flexible base your dimension off a view.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <5e46f79b27a58@uwe>, u20487@uwe says...