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]

My iPhone running iOS 5.1.1 will not sync voice memos to iTunes. I have tried trimming the memos, and changed the label. No go. The "include voice memos" is checked on iTunes sync, but iTunes won't even create a voice memos playlist. Help? These [More]
I recently got a mobile-me account and iTunes will not let me change my email to the mobile-me one because it sees the mobile-me account as a seperate iTunes account. I have purchased songs and applications with my existing iTunes account and I would [More]
Let's say I have a mobileme acct called applesoranges, but then I decided not to use this name for my website. Using iweb, I have created a different website called, and was able to figure out how to set up my personal domain and then m [More]
I have a Mac Pro 2008 8-core 2.8 with 16 GB ram and the ATI HD 5870. Sometimes in Aperture 3 (newest update) when using NIK plug-in colorefex pro 4 it crashes. It only crashes when performing certain tasks, like certain recipes.  Or more often when I [More]
Hi, I am having a problem reading a file from the resources: In my project I have data.xml in my project resources folder. I tried the following and it does not work: File xsltFile = new File("resources/data.xml"); or File xsltFile = new File(&q [More]
Hello, I am currently developing a mobile application that is supposed to work on both Android and iOS devices. I am supposed to display arabic text and also to take arabic text input from the user. While I was trying to display simple output and inp [More]
We are not able to type the Korean multi-bytes in command prompt of Korean-Win2k3/XP. But we able to copy paste the Korean characters command prompt successfully. Here we are using "MS-IME2002" as keyboard type In case of Korean-Win2k8, able to [More]
Hi I have this classic ipod for a long-time. Currently, I am using it in the car with 3.5mm radio cable. Becasue of connecting to the auto speakers, I have to set ipod volume to the maximum in order to have enough volume from the speaker. The weird t [More]
Hey All! I have one particular album that I downloaded several months ago, and every time i play the songs from iTunes or my iPod, they skip in the exact same spot every time. I know Connect Music from Sony lets you re-download purchases (yay! I boug [More]
From my edit in FCE I export to Quick Time Conversion. Format MPEG 4 Options MPEG 4 improved. Image size 720*480; Frame Rate=Current: Automatic Key Frame; I'm shooting for broadcast (Baseball Spring Training, and want to send the edited video (about [More]