I note from
http://msdn2.microsoft.com/en-us/library/ms143229.aspx
that the SkippedLevelsColumnproperty in no longer supported.

If you've got a perent-child hierarchy that has a varying number of levels
from top to bottom, how do you make all the leaf nodes appear on the bottom
level? (We've got views we set up for AS2000 that have columns for the number
of levels to skip)

Hello,

You may want to refer to the following link:

http://msdn2.microsoft.com/en-us/library/ms365406.aspx

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===


This posting is provided "AS IS" with no warranties, and confers no rights.

I'm confused .. the other reference inferred SkippedLevelsColumn wasn't
supported. This one is saying to use it. Will SkippedLevelsColumn be
supported in 2005 onwards?

Thanks

Hiding Members in a Parent-Child Hierarchy

To make a parent-child hierarchy ragged, use the SkippedLevelsColumn
property of the parent attribute in the hierarchy to support the ragged
structure. Before you use this property, make sure in the data source view
that the dimension table for the dimension contains a column that stores the
number of intervening levels between each member and its parent. The
SkippedLevelsColumn property must be set to this column in the dimension
table.


""privatenews"" wrote:

It is not supported in AS 2005. The documentation is incorrect in this
respect.

Thanks,
Akshai
--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Acius" <acius (AT) nospam (DOT) nospam> wrote

Well can we go back to the original posting please. How is it done in AS2005?

"Akshai Mirchandani [MS]" wrote:

Hello Akshai,

The following is feedback from product team:

Although SkippedLevelsColumn shows up in DDL and AMO, it is not supported.
This is in the list of backward compatibility issues as you have seen.
There is no way to force all leaves in a parent-child hierarchy to the
lowest level (other than doing in the table).

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===


This posting is provided "AS IS" with no warranties, and confers no rights.

Thanks for checking that Peter;
It was very useful functionality from AS2000 (Particularly if the client
tool can only select at a level and not at base)

Is there an example of "doing in the table"


""privatenews"" wrote:

Hello Akshai,

Based on their comments, doing a table means just adding rows to the
parent-child table to insert artificial members. There is no way to hide
the artificial members though.

Please rest assured that your feedback on this feature is routed to the
right channle, and I also encourage you submit via the link below

http://lab.msdn.microsoft.com/produc...k/default.aspx


Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===



This posting is provided "AS IS" with no warranties, and confers no rights.