First, in SSIS I cannot delete the data viewer from a connection between two tasks in the data flow without crashing BIDS. Even if I delete the connector or the tasks, BIDS crashes.
Second, in SSAS I accidentally deleted an attribute and the undo does not work in SSAS/BIDS. I put the attribute back and the dim won't deploy. It just runs forever.
Finally, in ProClarity my drill to detail is not displaying the fact rows I want. Plus the column headers are not easy to read. How can I make SSAS reference the correct data and corresponding column headers.
TJ
> Second, in SSAS I accidentally deleted an attribute and the undo does not work in SSAS/BIDS.
> I put the attribute back and the dim won't deploy. It just runs forever.
Indeed, undo is not yet implemented. After putting back the attribute, when you deploy, do you get an error or the deployment takes a long time ? If the deployment takes a long time, it's probably because the data is re-processed (although you put back the attribute, I believe its ID changed and will trigger a re-processing of the dimension). To stop re-processing on each deployment, right click on the project node -> Properties -> Deployment tab -> Processing Option.
Things to check/recover when putting back the attribute: was the attribute involved in hierarchies (was it source of levels in hierarchies ?) or attribute relationships or was used as granularity in measure groups ? (by default, the key attribute is the granularity)
Adrian Dumitrascu
No comments:
Post a Comment