Posts Tagged ‘Essbase’
Period End Average Selling Price
To calculate an average price in the Year_Total/Total_Period member is quite straight forwards if you’ve got your period hierarchy as dynamic calc. It just needs a forumula. It doesn’t need to be a Two Pass calculation member. The ASP (Average Selling Price) member in my model has the following properties: The time balance and account…
Read MoreRestoring Part of the Essbase Data
Here is a tip for restoring part of a Planning model, say for a specific Version/Scenario. First I have restored a model from which I want to extract the data, ready to import data into my PROD for only a specific version & scenario combination. Export in native Essbase format The folder has to be…
Read MoreAccess to Multiple Environments in Excel Smart View
A super quick post about a tip I got a few years ago on an easy way to manage access to multiple environments in Excel Smart View. The reason for going to post is that it surprises me how often that I come across people that have not seen this, so here it is. How…
Read MorePerformance step up for @PRIOR
I wanted to test the performance of using @XRANGE with @PRIOR verses using the cross dimensional operator in conditional statements to see how much performance could be improved.
Read MoreView Double Entry Transactions
Ever done an intercompany recharge of costs? The calculation creates the other side of the transaction and you want to see it, but the security set up prohibits you from viewing what you’ve just done. I was confronted with this paradox problem, I had a web form to input intracompany cross charges, but all I…
Read MoreBSO database, calc performance or size management
What to do if the size of your database is getting close to your storage limit, or the performance of a calculation is becoming less optimal because it is running over too many blocks, here is a tip to see where the blocks are in your BSO application. From the Database Properties the total block…
Read MoreCopy Version Snapshot in ASO model
Something that comes up regularly is creating a snapshot of Scenario & Version, often a copy of “Budget” “Working” into “Budget” “Final” and locking the data as read only. Data Copy in BSO In a BSO or Hybrid model it’s pretty straight forward and you’d do something as simple as this: It’s quick, simple and…
Read MoreData Extract with Ancestor Meta Data
From time to time requirements to publish meta data along with an extract come up. I recently had a requirement to produce an extract with column headers a bit like this: This was two dimensions, the bottom row is just level 0 members, the second row up is level 0 members with parents, grandparents &…
Read MoreLoading Multiple Accounts Using Logic Groups
In this blog, I have a file that I needed to parse twice in order to populate six account members by filtering on different subsets of the data. One approach could be to create two data load rules and have scripts to run them, basically reading the file twice. Alternatively, by using “logic groups” the…
Read MoreUser Cloud File Access
I have a Groovy script that produces a text file on demand, executed by a power user. The user then needs to download the file for downstream offline activity. However they couldn’t access the file output. So the question was how to get a file from the Inbox/Outbox folder, the default folder for all API…
Read More