on 11-28-2012 1:40 PM
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.
Regards,
Sridhar Sundaram
The PAS data is deleted with a pas command. Select the dimension mebers you want to delete for and then either issue
delete Variablename
or
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.
Cliff
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Scorpio,
Not sure, what you are trying to achieve. But this is what I did. Not the best of ways I wold say.
If you are ok with deleting all the data.then
Delete the PAS model file from SSM - Application - Home folder on server.
Delete the PAS model from Pilot Application server client.
Build PAS model from cube builder again.
This means you have not made any changes to the model directly from PAS and always change it through cube builder.
User | Count |
---|---|
15 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.