Amicuk Programming Answers

OBIEE + Essbase slow execution

-0001-11-30   Views:1


Hi, I'm using OBIEE version and Essbase as a data source. I have an Answers report with a certain number of columns that are using AGO, TODATE functions, etc and they work fine. Now I have a need for a column that would also implem

I'm using OBIEE version and Essbase as a data source. I have an Answers report with a certain number of columns that are using AGO, TODATE functions, etc and they work fine. Now I have a need for a column that would also implement a TODATE funcitionality, but for the previous year – for example, if I choose March 2009, I need to show aggregated data for January, February and March of *2008*.
Since I did not manage to get this just through the OBIEE functions that are available, the solution was to use the EVALUATE_AGGR function with the following expression:
EVALUATE_AGGR('AGGREGATE(PeriodsToDate(%1,%2.dimension.currentmember.lag(12)), %3)', Time.Year, Time.Month, Accounts.Sales).
Here I use the Essbase function “Lag” to shift the aggregation 1 year back (12 months).
This works fine, in that is gives the correct result, however it is very very slow when used in my report that gives cca. 18 columns and cca. 15 rows back as the result.
Does anyone know why is such report so slow, is it because of the Evaluate function, because of the Lag function or something else?
Any ideas?
thank you

The replay answer
Hey, thanks a lot for a quick answer!
You are right on both of your assumptions - multiple MDX are indeed fired and we do not have the possibility of chaning Essbase cubes.
Can you perhaps think of any other way of implementing this "todate for year ago" functionality?
Is there any way to control how OBIEE generates MDX? Hints maybe or something like that?
In addition to my first post, I would just like to add that the query is much much faster when I include, as a column in Answers, all the columns on which I apply a filter - example: I'm filtering by dimension "Segmentation", Generations 2 and 3 - when I don't have these coumns in the report itself so that the chosen segmentations are seen as a column, the report is very very slow (initial issue). But when I include them in the report (not just use them in filter), the report becomes very fast and would do fine for us as such. The problem is that I do not need to show the data 'divided' by segmentation (as it is when the columns are in the report, not just filter).
Edited by: [email protected] on Mar 22, 2010 1:01 PM

Go to See the other 5 answers

OBIEE + Essbase slow execution

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I'm using OBIEE version and Essbase as a data source. I have an Answers report with a certain number of columns that are using AGO, TODATE functions, etc and they work fine. Now I have a need for a column that would also implem[More]

OBIEE Essbase skip-level hierarchy

Category:DefaultRelease time:-0001-11-30Views:130

Is it possible to setup OBIEE and Essbase to be able to model skip-level hierarchy? It is obvious with connection to the relational database. How the essbase should designed and populated with data to faciliate this type of hierarchy?Refer this http:[More]

OBIEE-Essbase Federation Ques

Category:DefaultRelease time:-0001-11-30Views:130

Hello All, We are doing federation b/w essbase and relational datasources. All our region level information (upto state) is in essbase and city level information is present in the relational tables for which drill down to city to fetch those details.[More]

In the script the cause of the movie has become slower execution speed of Adobe Flash Player. If you continue in this state, you may not be able to respond. Are you sure you want to stop the execution of the script?

Category:DefaultRelease time:-0001-11-30Views:130

ムービー内のスクリプトが原因で Adobe Flash Player の実行速度が遅くなっています.このまま継続すると.応答しなくなることがあります.スクリプトの実行を中止しますか?というエラーメッセージが出ます. どのように対応したらよいのでしょうか? パソコン初心者です.宜しくお願いいたします. Message was edited by: Ashish Gupta to change the thread title to EnglishHi Pochi, Which Adobe soft[More]

OBIEE - ESSBASE   ERROR - 1200467 - Error executing formula for [MDX query]

Category:DefaultRelease time:-0001-11-30Views:130

I have an issue on essbase with a query with 50 member filters. The environment is OBIEE 11g over ESSBASE 11.1.2 with an ASO cube. The user for essbase are with database access filters. I have the following issue, OBIEE returns a query that filter 30[More]

MODBUS/TCP very slow execution

Category:DefaultRelease time:-0001-11-30Views:130

Dear all We are new user to Labview and to LabVIEW forum. We are designing a LabVIEW application that interacts with PLCs. We are trying to exchange information between a PC/labview and a PLC. Both support the MODBUS/TCP protocole. We have designed t[More]

MYSQL slow execution of CF 7x

Category:DefaultRelease time:-0001-11-30Views:130

I have an issue that is rather irritating. I'm playing around with MYSQL 5.0 on my laptop with Coldfusion 7x developer edition. I'm using the J-connector 5.0.3. It's a duo core 1.8 processor with 1 gig of ram. Any time I include a query of any size a[More]

OBIEE - Essbase / HFM

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, This might be a very basic question. We are looking at purchasing OBIEE for our Oracle ERP reporting needs and we also want to eventually have Essbase and HFM data within OBIEE. I am a bit confused on whether or not I need to import my Essbas[More]

Slow Execution Time of Exponentia​l Function

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I am developing a program with large dataset (arrays size of around 1000*1000 elements). I realised that my program ran quite slow when calculating exponential for each array elements. So, I built a simple porgram to test the execution time for e[More]

Slow execution of a event structure(​Calling VI)

Category:DefaultRelease time:-0001-11-30Views:130

The VI i created is gettin slow after execution of a particular set of event in an event structure(Calling VI).Is it because of improper use of shift register? I have attatched the VIs...Please run GUIdev and suggest solutions.Its really gettin on my[More]

SQL query with Bind variable with slower execution plan

Category:DefaultRelease time:2015-10-11Views:130

I have a 'normal' sql select-insert statement (not using bind variable) and it yields the following execution plan:- Execution Plan 0 INSERT STATEMENT Optimizer=CHOOSE (Cost=7 Card=1 Bytes=148) 1 0 HASH JOIN (Cost=7 Card=1 Bytes=148) 2 1 TABLE ACCESS[More]

Basically to keep a long story short - i need to take my computer in for repair tomorrow. I recently did an upgrade to Mountain Lion a day or two ago. I haven't done a Time Machine backup until today (a couple days after i upgraded to Mountain Lion) [More]
We found that some customers willing to upgrade Windows Server 2008 R2 GUI to Windows Server 2012 Server Core recently. This article provides detailed steps to perform the upgrade. Analysis Upgrading from Windows Server 2008 R2 with a GUI installatio [More]
Hi All, I am facing a strange problem. In sender query, I have Employee,Employee Post and Employee Start Date. I have to pass employee to Receiver Web Template which shows Employee History. When the employee number is passed to the receiver, it ask t [More]
Hi , I have a requirement to hold the IDoc in transaction MIRO. When I post the invoice, if there is any error , the posting is terminated due to error. But the current requirement is, If there is any error , i need to capture the error in table fiel [More]
Does anyone know how to remove the "Open With..." option from contextual menus? Thanksmusicwind95 wrote: What are you trying to do? I'm hoping to find an option to remove the Open With dialog which I never use. If I right click on a simple JPEG [More]
Hi, How can I search a file along with its verions in the KM repository using KM APIs? Thanks, VamshiHi Vamshi, maybe you could use the following Interface: [More]
I just updated to OS 10.4 and now i connot burn photo CDs with iPhoto 2.0. The burn fails repeatedly. Do I need to upgrade to iPhoto 5.0 or iLife? I'm using a dual processor G4 with a combo drive that's never had this problem before.iPhoto will open [More]
Hello! I am in a sort of predicament. My friend has recently purchased the "Sims 2 Collection" on my computer and I NEED A REFUND!! I am now down to 40 bucks and direly need that credit back! any tips? NOTE: Have already created a support ticket [More]
Running Mavericks on a Mac Mini.  Had some problems which I suspected were disk related so installed Mavericks on a usb disk whilst I tested the internal disk.  The usb disk was partitioned with System and Users (two partitions).  When I was satisfie [More]
I am having issues with Stemming in my application when I run baseline_update on Windows box. It would be a big help to this newbie if you Endeca gurus help me resolve this. In my simple pipeline, I have just default properties and dimensions, nothin [More]