Author: Sanjay Purohit
Audience: Hyperion Solution
Architects and Hyperion Planning Database Administrator
In the
tradition Planning world dimension/member intersection are used to store the
data and most of us know that Hyperion Planning also provides a drop down
feature called Smartlist to capture the data. But this feature comes with few
limitations such as:-
Security Assignment: - The security cannot be assigned to
Smartlists.
Data Export: - The Smartlists are saved on Hyperion Planning
sachem and numeric values are pushed to Essbase. Users can get only numerical
values in Essbase if data is exported from Essbase.
Goal
Creating
and loading Smartlists is an easy task but deleting them requires lots of
manual efforts. Let’s assume a case where you load 1000 entries to a Smartlist
but later we decide to use only 400 and we need to delete 600 of them. You are
only left with two choices either delete them manually one by one or delete the
Smartlist itself. Let’s how we can delete Smartlist entries.
We have
created a csv file and will load the Smartlist from workspace:-
·
The
Smartlist load is hidden under the New Dimension. Select New Dimension and then
Dimension Type Smart List.
·
The
smart list is loaded after running the file.
·
Now
we will load the below given file to delete the Smartlist entries.
·
After
loading this file. All the entries are removed from Smartlist except one.
Similar
Posting
Hyperion
Planning Smartlist
Setting up
Smartlist
Where has
my Smartlist gone
No comments:
Post a Comment