OLAP cube question (a) Edit Dimension and (b) Delete Partitiion
Database
1
Posts
1
Posters
0
Views
1
Watching
-
hello two newbie questions for OLAP. I'm looking at my cube from Visual Studio ... (a) Edit Dimension I want to basically add a new Dimension level - under Design view of "Dimension Structure" ... I can see Data Source View tabs containing two existing tables which make up my original dimension. Trouble is, how can I add the third? Can I add a table for this dimension? (b) Delete Partitiion I can find from under Cube's Design view there's one tab "Partitions" - and I can delete partition manually one-by-one right click + select "Delete" from Context Menu. Is there a quicker way of doing this? Thanks
dev