BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi,

I was trying to use proc olapoperate to disable a cube in production in order to rename to some other name. The procedure runs without error but when it comes to rename procedure, it complains error. But if I use disable function in Olap Studio and run the same rename procedure, it will run smoothly. Is there something wrong with my proc olapoperate procedure?

proc olapoperate;
Connect HOST = "server" PORT = 5451 userid="user" pw="pw";
disable cube "/Shared Data/SASMain - OLAP Schema/Cubename";
run;

Thanks,
2 REPLIES 2
LinusH
Tourmaline | Level 20
It would be helpful if you could share your LOG.
/Linus
Data never sleeps
deleted_user
Not applicable
Thx for replying Linus, the log isn't particularly helpful in this case, I reckon. There are no errors whatsoever. But the cube is obviously not disabled successfully since I can still view the web report based on this cube. Please see the logs below.

NOTE: The CONNECT command completed.

NOTE: The DISABLE CUBE command completed.

NOTE: PROCEDURE OLAPOPERATE used (Total process time):
real time 0.26 seconds
cpu time 0.03 seconds

sas-innovate-white.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 996 views
  • 0 likes
  • 2 in conversation