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]

The user wants to receive a reminder when the vendor misses a delivery date.If he has to deliver the total goods in three different dateas and he makes one delivery correctly then the remaining qty to be delivered should also be known.Is there a tran [More]
Bar and Line graphs are used in a chart. By default the rowlabels of Bar and Line graphs displayed on the right side of the graph. I haven't explicitly defined any values for the rowlabels. But still it's displayed on the chart. I don't want to displ [More]
Hi,    I'm going to upgrade our SAP system from release 4.6C to ECC60 EHP5 with the procedure CU&UC. I'm using a Sandbox system to do this and test the functionality, in source version 4.6C we have a IS-MP(Mill Solution) 46C1 SP12 and in the new vers [More]
My daughter's ipod touch is password locked and attached to a computer that doesnt exist anymore. i want to authorize it to my computer itunes account but itunes wont even read it due to the password failure. what can i do?That's by design. The passw [More]
Greetings, I am trying to use the Solaris Management Console to manage the 2 disks I have in my Intel PC. Both disk are allocated 100% to Solaris 10 and were formatted and partitioned by the installation program. Why is it that when I use the Managem [More]
hi there, i got a brand new macbook core 2 duo to my birthday yesterday. the isight worked when setting up my user account right in the beginning. right after that i downloaded all system updates including the efi firmware update 1.17f0 which is vers [More]
Hi, Currently I am facing an issue that the & sign is not being displayed correctly in the Long text editor. It is shown as '<(>&<)>' in the transaction once I input my value in the graphical editor , save and come back. Please help... [More]
I have a DVD with 4 separate short movies. I would like to extract one of them and put it on a separate DVD. Is this possible, and if yes how do I do it? Thanks, Dr. Steve IDVD 4; I Movie 4Hi Doc, best practise... ahh, you're a Doc, lege artis is to [More]
how do i transfer iTunes from mac to mac?Migration assistant. Target mode. Copy the entire itunes folder. Your choice.Read other 3 answers [More]
Hello, Thanks for response. But issue is still there. i didn't able to enable Wi-Fi after reseting the Phone as per your instructions Wi-Fi MAC address is still not available Please help with another solution. Hey , Welcome to the HP forums. Clear a [More]