how to split account dimension into three different dimensions
for example
account dimension member = 11111200900
account_num.member = 11111
item_num.member = 200
sub_tem.member =900
OLAP substring
Hot Topic
- WMI alerting error
- Trouble importing csv with flat file source
- Differences between SQL 2005 Editions (Ent vs Std)
- How to connect to sql server2005 from java using JDBC driver
- Passing a parameter to Oracle in SS2005 Data Integration Services
- Connection closes often
- Push Merge snapshot fails with Data is Null message.
- Schema Ownership
- Problem adding new Database in Smart application
- Give permissions programatically with c#
SQL Server
- "product level is insufficient" message during flat file import
- Partitioned View - Errors after bulk inster
- SQL 2005 woes
- Error installing SQL Server 2005 Upgrade Advisor
- Problem in Deploying Analysis service projects using SQL server Business Intelligence Development Studio
- Some info on setting row delimiter values in package configurations
- ole db destination not inserting data
- How to detach properly using SQL Server Express?
- Configuration Files
- Case - Sensitive field
OLAP substring
forummember
Using Analysis Services 2005, the easiest way to do this is to create named columns in the table in the DSV which split out the portions of the accout. Then you will probably want to create seperate attributes within the same dimension for each of these aspects of the account.
In Analysis Services 2000, you can put a SQL expression to extract a portion of the account column directly in the MemberKeyColumn and MemberNameColumn properties.