Skip to Content

Delete Data in PAS

Hello All,

What is the command that i should use to delete data from PAS model?

I wish to delete data that i stored in PAS model and also the ones saved in EA templates but not loaded into PAS model.

Thanks in advance for your help.


Sridhar Sundaram

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2012 at 08:30 AM

    The PAS data is deleted with a pas command. Select the dimension mebers you want to delete for and then either issue

    delete Variablename


    Delete *

    The help file has the correct syntax

    The EA data is in a relational database. You can remove it with SQL commands in the RDBS. The table name will start with CPMS_EA_ I don't have a system in front of me so you'll have to explore a little to find it.

    Alternatively zero the data through EA. This is a bit slower but less risky.


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      What were the side effects?

      Sridar's method will work but only if the cube was built with cube builder. Nether his method and mine will not clear the EA data.. You have to do that through EA or directly hit the data in the RDBMs.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.