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]

HI, i try to run the (Oracle Fusion Order Demo Application For JDeveloper) Fusion Order Demo (FOD) is an end-to-end application sample : when i try to : Right click build.xml and choose Run Ant Target > buildAll . error coming Buildfile: C:\JDevelope [More]
Thanks for such a great update!!!I used to have activation problems. now I am getting same error "We could not complete your iTunes Store request. The network connection was lost." "Read other 12 answers [More]
Hi, I have window desktop application develop in Visual Studio.NET 2010 (C#.NET). The video is saved in *.MP4 or *.AVI format with high definition. The desktop application record the Live Web Cam Video, as soon the video is saved in need to export th [More]
I could log into my windows live hotmail account but I could not send any emails or open any emails. == URL of affected sites == David. You may be having a problem with some extension [More]
How do I make deleted apps disappear from the list of purchased apps in the App Store?You don't. You cannot delete Apps from that list as that would defeat its purpose.  It allows you to download purchased apps without having to re-pay for them. Its [More]
Not sure if this is the right forum for an airport extreme question but here it goes. Have a G5 connected directly to an airport extreme that is connected to the internet just fine. Not the new generation airport extreme. My POWERBOOK G4 is not showi [More]
I would like to know if there is a list of computers that will support Windows 8.  I have a Mac-Mini Server mid-2010, and I want to install windows 8 on it so I can use it insted of windows 7.  I have Mountian Lion(10.8.2) installed, and when I insta [More]
Sometimes when I am online (either safari or firefox), especially on websites like myspace, my macbook will just freeze up and stop "listening." I have tried the patient approach by waiting in hopes that my computer will stop being "busy,&q [More]
Hello, i have a ipod and doesnt let me to conect at hifi, i try every step that here recomend and nothing work, please i need help appear my internet providor and enter the password, and said: disable to conect thanksWelcome to the Apple community. S [More]
¿Cómo recuperar el historial de llamadas de un iPhone?solucionado, ajustes, store, id, desconectar y volver a conectar, okRead other 2 answers [More]