Q1: Where are smart slices stored? Is it on client or server? What is the location? How much space do they take up?
Q2: How do we secure smart slices?
Note: Version is 220.127.116.11
A1: Smart slices are stored on the server. They are stored as XML files which hardly take up any space (usually in kb). Its like the data slice definition is stored in XML files. These files are stored at <hyperion_home>\products\Essbase\aps\data\cubeviews\
A2: We cannot secure smart slices, they can be seen by all the users who have access to the database. But when retrieving data, it may show up #No Access if the user doesn’t have access to data.
Here is the link to a discussion on oracle forum