Showing posts with label attribute. Show all posts
Showing posts with label attribute. Show all posts

Sunday, March 11, 2012

drop IDENTITY attribute

Is there any way to remove IDENTITY column attribute without dropping the column?i have not come accross any method other than doing it thru enterprise manager.|||I knew about that but in this case SQL Server drops the table and recreates it with the new description (including indexes, constraints, triggers, etc.). - a hell of a script - checked with Profiler
I thought it might be another way to do it smoothly.

Thanks anyway,

Originally posted by rohitkumar
i have not come accross any method other than doing it thru enterprise manager.|||you can do "alter table tbl drop column column_name" and then add a column without the identity. the only problem is it will append the column at the end of the field list. i think yukon will have the ability to drop/add properties.

Tuesday, February 14, 2012

Drilldown for Parent Attribute

Does anyone know how to create a drilldown matrix or table using a parent attribute in Analysis Services?

Currently, I have a dimension with this parent attribute which contains up to 10 levels. Then, if you click "Browse" in the Analysis Services toolbar it will let you expand each node until you reach the end of the branch. This allows a variable length tree. However, the problem is that when I go to add this attribute to my query in reporting services it only adds the first level. In other words, when you expand the attribute in the query designer, you can see all ten levels exist but only the first level is added to the report. I've also tried to manually add each level into the query, but this also fails. It ignores whatever level I add and just keeps the attribute's first level.

I know this is kind of a confusing problem, but I'd really appreciate any advice.

Thanks!!
Joel

Does anyone have any ideas or need more clarification?

Thanks

|||

Still stuck... Just wanted to get a few more looks at this problem.

Thanks