Show Usage for a member in Calc Manager

July 31st, 2015 writer No comments

Show Usage for a member in Calc Manager

I once received a query where customer asked whether there is an option to find out Member usage in Calc Manager.
So let’s say that member FY10 is used in ‘n’ Calculation Manager Rules, they would like to list out all the rules that has FY10 in it.
I couldn’t find out an way to do that from front end :) , so ended up querying the repository
You can get the required information by running one of TWO SQL queries given below.
Categories: Planning SQL Queries Tags:

Show Smart List Usage – Forms & Accounts

July 31st, 2015 writer No comments

Show Smart List Usage – Forms & Accounts

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.
Categories: Planning SQL Queries Tags:

SQL queries for finding folder location of Planning Webforms and more…

July 31st, 2015 writer No comments

SQL queries for finding folder location of Planning Webforms and more…

You might have spend many hours (during documentation phase of your project) to get the information about Webforms like Webform folder location, Business rules attached to the form, Menus associated with the forms,……
So here is an easier way to do it. (Thanks to my friend Jomish for helping me with the SQL queries)
To find out the folder location of Webforms
Categories: Planning SQL Queries Tags:

Essbase CDF Workshop Part I

July 31st, 2015 writer No comments

Essbase CDF Workshop Part I

Introduction

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.

Read more…

Categories: CDF Oracle Tags:

Hyperion Smart View – Extensions and Utilities Power Pack

July 24th, 2015 writer No comments

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.

Read more…

Categories: SmartView Tags: