I am fuly agree that the answer is incorrect

Bcz Grouping_id is not a sub-clause, It is more like a function/aggregate

Group by subclauses listed at the following

Yes

and we can use all the DML operation while updation

Hi

you can do it by many wayes

1)hide the report from menu

2)Ask password on clicking of the report menu

3)in the report you can give him a box to enter...

Hi

there are so many tools used to explore the cube data

few of them are OWC component (now it is excel services),Olap viewer, and reporting services

amit