About Me
I am a Business Intelligence enthusiast who likes blogging about acquisitions in the BI space, technical workings of the BI tools in general and Oracle Business Intelligence tools in particular. All the views expressed here are my own and does not reflect the views of my employer. I am happily married to one wonderful woman who has been by my side through all my ups and downs.
September 6, 2007 at 10:22 am
Hi Venkat, Nice to see your blog. I am new to Hyperion Essbase. And this is very useful for me. If you provide any material which is reflecting on real time environment. I have few doubts
1. how many threads running in essbase app?
2. what would be ideal size for block and cube?
3. how we will connect the server?
4. diff bw MAXL and Esscmd?
5. if my cube size is 4 GB how much time it will take load the data.
Thanks in advance
Gopi
September 7, 2007 at 7:31 am
I am not sure i understand some of your questions here Gopi.
1. Do you mean how many threads does an essbase app support?
2. For the block size, it would depend on your cube. This link should help you to make that decision.
3. Do you mean, how to connect to the essbase server and view the data? There are lots of options to do that. One is to go to Analytic Admin Services wherein you can view the data. Else you can use the excel addin to view the data from excel. Or if you have System 9 BI you can connect to the essbase server using them.
4. I am not sure whether i am right about this. Both Esscmd and MaxL achieve the same functionality. But you have some conversion utilities to convert from Esscmd to MaxL. Also, i believe MaxL is more flexible.
5. The answer to this question is “it depends”. It depends on your design. It depends whether you have partitioned the cube. It depends on how you have specified the level aggregation etc.
September 13, 2007 at 9:28 am
Thanks Venkat.
For above questions
1. I gone through Help file. That depends on ports.
3. Which 3rd party tool used for connecting to the server?
My New questions are.
i) If my data in flat file to load, that flat had 13 columns? How the data will load in outline? Dense or Sparse wise?
ii) How i will delete the data in excel without using any Calc Commands or form outline, directly form Excel sheet.
Tx
-Gopi
September 14, 2007 at 6:01 am
Hi Venkat.
I am attending interviews on Essbase.
as i asked abv 5th question. I don’t have any partitioning in cube? I am saying to interviewer that it will take to load 10 min time. They are asking that client will wait 10 min time. That’s why i am emphasizing on this? Please clarify
Tx
-Gopi
September 14, 2007 at 6:33 am
Even if you dont have partitioning it still depends on how your cube is setup. It depends on which storage option you have used in your cube. ASO or BSO. It still depends on the level of sparsity you have in the cube. Also, it depends to an extent on the hardware configuration of the underlying server.
October 12, 2007 at 12:41 pm
[...] Ведет его консультант Oracle Venkatakrishnan J. [...]
October 16, 2007 at 12:32 am
Is it possible to display an image based on value passed through session variables in BIEE. Based on the login different images need to be displayed. The corresponding images are stored in s_oracle10\images folder.
December 7, 2007 at 11:04 pm
Hi
I have started following your blogs snce recently. Nice work . Thanks for you help
I have a question regarding the calculation of WTD.
I already have a Dimension(based out of W_DAY_D)which i use as a Day Dimension.
Did you mean i had to create another Dimension based out of W_DAY_D and set as a Time Dimension?
Also if i have to use this the new measure(WTD)along with my other measures which do not go by the new Time Dimension(for WTD) How would this work?
Can i use the normal W_DAY_D dimension itslef as a Time Dimension.?
Could you please confirm this.
December 27, 2007 at 6:56 am
Soumya, You can use W_DAY_D for time dim, but make sure you create an alias and use it; other wise, you may be creating a wrong join. BTW, OBI apps standard is to create alis for any physical table in the physical layer before the dim or fact has been used in the BMM. HTH. Venu
February 25, 2008 at 5:44 am
Hi Venkat,
I liked your blog as it really shows how Business Intelligence enthusiast you are… I guess the woman in your life might think you having an affair with your blog….
Well jokes apart, Lately we too have started blogging on Business Intelligence… Please go through it and give us feedback to improve…
BTW, Have you read about powerful CIOs for the year 2008?
February 26, 2008 at 7:31 pm
MAIA - Thats a good one :-). I have added you to my blogroll.
March 3, 2008 at 11:34 am
Hi Gopi,
Just give me an update on difference between Hyperion and OracleBI.
thanks
Ramesh Pabba
OBI Specialist
March 8, 2008 at 9:12 am
March 17, 2008 at 6:58 pm
I’m a financial analyst, and I need to learn to use Essbase to create financial reports. Any recommendations on where I can learn more?
March 19, 2008 at 10:30 am
Hi Venkatakrishnan ,
I am not able to create this metadata report.
Here i am mentioning the steps which i followed
(1) Using Repository Documentation utility , i generated the CSV file.
(2) Instead of using external table , i created a table in database.
(3) Using sql loader i uploaded data from CSV file into the table.
(4) Then Using OBIEE 10.1.3.3, i imported this table into Physical layer.
(5) Then after i created a new subject area at BMM layer and dragged the table
to the BMM. Then dragged the table to Presentation Layer.
Beacuse the BMM layer has only this table, No other table is present at BMM layer, RPD beacomes inconsistent. Beacause no logical join is present.
And when i look this Catalog in BI Answer, It shows only Subject Area , No columns information.
I also tried to use this table with a consistent RPD. But when i use this table , i makes the RPD inconsistent beacuse lack of logical join .Again the same issue comes.
My question are -
(A) How are you using this table to create metadata report?
(B) How are you creating logical join?
(C) How your RPD is consistent?
(D) How are you able to use this table with BI Answer?
Any ideas in this regard.
March 19, 2008 at 10:42 am
Ashish - Since you have only one table you cannot directly drag and drop that into BM. You need to basically create 2 tables in BM (both copies of the same table in Physical layer) and then make a logical join between both of them. Then drag and drop one table into the presentation layer. That should make it work.
March 19, 2008 at 12:43 pm
Thanks for the reply Venkat.
There is one more question -
While creating a RPD , the description about keys and join information using
description and hint property which we define at physical layer, those informations do not reflect BI Answer when i query to metadata dictionary.
Here i give little bit more description what i did.
(1) I created a RPD and gave some description about Foreign Keys and using hint a gave some description about Physical joins.
(2) After then using utilities I generated the Metadata Dictionary.
(3) When i query to Metadata Dictionary using BI Answer , i am not able to see those descriptions. Rest of the information like table level and column level descriptions i am able to see.
Is there any way to get these descriptions or metadata dictionary does not keep descriptions for keys and joins?
Any ideas in this regard??
– Ashish
March 19, 2008 at 1:46 pm
Hi Venkat ,
When we use Repository Documentation Utility in OBIEE, it generates a CSV file which captures the information about tables and columns of presentation layer,BMM Layer and Physical layer.
But it does not captures the description information which we define at Table level and column level.
Is there any way to capture this description information into CSV file? I have a such requirement.
I know that Metadata dictionary captures the description information but that is not helpful in my case.
Any ideas in this regard??
– Ashish
March 20, 2008 at 10:28 am
Hi,
i am new to siebel analytics…
i want to learn maximum i can…
can you refer me any book,or any links,which can help in learning complete siebel analytics(OBI)
April 2, 2008 at 7:30 am
Hi Venkat,
I have to create a presentation layer in multiple language. Let’s say language is Netherlands.
I have gone through the below link -
http://oraclebizint.wordpress.com/2007/10/29/oracle-bi-ee-101332-presentation-layer-translation/
and tried to implement as per the steps given.
I have given the abbreviation of Netherlands language ‘nl’.
When i select Netherlands language in Presentation Services login page , Still i am getting all the tables and columns name and their description in English in BI Answer.
I have converted a few column and their description only in Netherlands language, rest are in English.
The NQ Query log is as below -
——————– An initialization block named ‘Set Language’, on behalf of a Session Variable, issued the following SQL query:
SELECT ‘VALUEOF(NQ_SESSION.WEBLANGUAGE)’ FROM DUAL
Returned 1 rows. Query status: Successful Completion
+++Administrator:fffe0000:fffe0005:—-2008/04/01 17:36:36
——————– An initialization block named ‘Set Translation’, on behalf of a Session Variable, issued the following SQL query:
Select SESSIONVARIABLE, TRANSLATION from Projects_Translation where LANGUAGE = ‘VALUEOF(NQ_SESSION.LOCALE)’
Returned 0 rows. Query status: Failure
The 2nd query does not return any row.
Any idea in this regard. Where am i doing mistake? Why is it not showing those column names and their description in Netherlands Language?
Do i need to do some setting in OBIEE ?
May 5, 2008 at 1:00 pm
Hi Venkat,
This is swami, working in Cognizant technology Solutions. We are having a requirement in our project. Here we have to Integrate our Siebel Analytics Reports into our customer Web Pages. I dont have any idea where i have to start. I read your blog about Placing OBIEE reports in Portels using Jdeveloper. But how can i acehive this in Siebel Analytics 7.8.2.
Pleas help me on this ASAP.
Swami.