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]

I have just taken the plunge and moved over to a Macbook Pro from Windows. I am really impressed with the computer, but need some help with a particular problem. My wife has her iPhone and iPad, both of which are synced to one iTunes library on her o [More]
Hi there, as the Topic states i have a lot of trouble installing my USB Soundcard under the newly installed Windows 7 [driver, headphones, general sound bass redirection etc.] Here is what i already tried and (kind of) worked or not.. . Original, off [More]
Hope someone can put me out of my misery... I've been running my Mirrored Door (MDD) Dual G4 for years and have always booted into OS 9, but today, the Mac has decided to boot to OSX. From the Startup Disk Control panel in OSX, I have selected the OS [More]
Hallo, da ich Euer System der Forensuche nicht verstehe trage ich hier mal meine Frage ein. Englisch kann ich nicht, somit möge man mir verzeihen aber vielleich gibt jemand bei Adobe der Deutsch versteht. Also ich hab mir vor kurzem einen  LG   47 LM [More]
Hi Gurus, We are using manual bank statement and i have marked tick on post automatically in main bank account. System is not allowing to post entries in FF67. Can you please help with this error? Thank youHi, Remove Post automatically tick mark in M [More]
Hello Experts, We have a scenario, in which the PO will be created using a load file (LSMW - BAPI) with reference to a Purchase Requisition. All are text based purchases and no material master exists. I want the price from the load file to be taken a [More]
Dear All My Client have following business scenario they are in supply & installation different type of services for this they get different type of inquiry from different type of customer in Excel worksheet called as BOQ (Bill of quantities) templat [More]
It seems to only be an issue with the Chrome browser. The help works in both IE and Firefox. Since Google Chrome is a very popular browser and many people have it set as their default, this is quite disconcerting. I am using RoboHelp Version 9.0.2. T [More]
Hi all, Sorry to re-visit something I've seen a number of posts on, but I can't seem to get things to work as I've been lead to believe they should. We have a handful of systems that do not have any instance of the ZEN agent installed, a mix of NT an [More]
In the past 2 days, I've experienced significant slowdown. The only thing new is that I'm attempting to switch from Eudora to Mail. Here's what is repeating -- ENDLESSLY -- per Console:[1] ([74]): Did [More]