How can you remove the filter created by a CREATE SUBCUBE statement in an MDX query?

Choose one of the answers below:

  1. It is removed when the batch ends.
  2. Issue the CLEAR SUBCUBE statement.
  3. Issue the DROP SUBCUBE statement.
  4. Issue the CLEAR FILTER statement.
Answer:

  1. Issue the DROP SUBCUBE statement.
Explanation:

After you create a subcube, it is used for all subsequent batches until the DROP SUBCUBE
statement is submitted or the session closes.

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)