开发者

parent child relationship in analysis services 2005

开发者 https://www.devze.com 2023-01-23 22:11 出处:网络
I have a table: ID, ParentID, Code, Caption1, Caption2 ID - atribute usage = key; namecolumn = Caption1 ParentID - atribute usage = parent

I have a table: ID, ParentID, Code, Caption1, Caption2

ID - atribute usage = key; namecolumn = Caption1

ParentID - atribute usage = parent

Code - atribute usage = regular

Caption1 - atribute 开发者_如何转开发usage = regular

Caption2 - atribute usage = regular When I browse the dimension parentid it shows in hierarhical way based on Caption1 witch is OK.

What should I do so when I browse by Caption2 to show also in hierarhical way. My business needs is to show in hierarhical ways when I browse by Caption1 or Caption2 or Code too. How can I do that.


You can build your own custom hierarchy

0

精彩评论

暂无评论...
验证码 换一张
取 消