How can I see which Smart List is associated to which member?
I had to do that on a PBCS implementation and as you know there is no access to the backend. Luckily the client named the Smart lists similar to the member names, however there were some which was shared between members!!!!
On OnPrem, it is easier I can query the tables
This query will give you the Smart List name along with the members it is assigned to.
I decided to write a series of posts on a topic that is as old as essbase itself (maybe not – but it’s pretty old). But, in my opinion, it was not sufficiently covered, did not get enough attention by consultants, and as a result, it is a sort of taboo to talk about with many customers.
The topic is CDF or Custom Defined Functions. If you are on this page you probably know that:
Those are “additional” functions written in Java.
You can write your own, or use existing ones.
They are registered on Essbase server
They can be called from calculation scripts/Business Rules as if it was a native Essbase function.
From my experience there are not that many essbase developers that actually do create their own CDFs. From client point of view somebody will have to maintain those CDFs, probably expand for new requirements, and since this is a rare (and expensive) skill, they try to stay away from custom code. Which is fully understandable, and I often supported those decision. As a result essbase developers don’t have much incentives to develop this skill, and this is a vicious (virtuous – depends who you ask) cycle.
Hyperion Smart View – Extensions and Utilities Power Pack
Getting Query on Daily basis are there any shortcuts for smartview except writing Macros – so thought of writing this blog.
Oracle has several extensions and utilities to make your Hyperion Smart View navigation simple and more efficient. There are a variety of Power Pack downloads that can be used to enhance or extend Smart View to save time and make navigation more manageable.