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.
gopi said
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
Venkatakrishnan J said
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.
gopi said
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
gopi said
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
Venkatakrishnan J said
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.
Про Oracle Business Intelligence » Блог Venkatakrishnan-а J said
[...] Ведет его консультант Oracle Venkatakrishnan J. [...]
Pitchai said
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.
Soumya said
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.
Venu said
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
MAIA Blog said
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?
Venkatakrishnan J said
MAIA – Thats a good one
. I have added you to my blogroll.
Ramesh Pabba said
Hi Gopi,
Just give me an update on difference between Hyperion and OracleBI.
thanks
Ramesh Pabba
OBI Specialist
bibomedia.com said
tom barney said
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?
Ashish said
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.
Venkatakrishnan J said
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.
Ashish said
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
Ashish said
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
romil said
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)
Ashish said
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 ?
swami Nathan said
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.
Ali said
Hi Venkatakrishnan,
No hesitate to say that i am new to Essbase, Hyperion. since four, five days i am reading your blog and its really a great start for me. i am understanding some here and there in the blog, difinetly lot of ppl might have taken advantage of this site. its great help to all venkat.
Thanks
Ahamed
Krishna said
Hi VenkatKrishnan,
How can I use a REF CURSOR in the data template.
I am trying to convert the RDF which is using REF CURSOR to BI Publisher report. The REF CURSOR in the data template is not returning any data.
Any help is appreciated.
Thanks,
Krishna
sitesh said
hi …can u pls tell me how to change the background images in OBI .i am using 10.1.3.3.2 version of OBI with OC4j.
thanks and regards
sitesh
siteshkumar said
hi venkat,
i want to change the background images in each pages of a dashboard,each page having a different image.is it possible..if yes…provide me with a solution…
thanks & regards
Sitesh
shubh said
Hi Venkat,
I have a requirement in which i have to send a report to 1400 different stores (store’s primary person’s email id) via iBots. But one person can be primary of multiple stores and all the primary persons of the stores will login to OBIEE and setup their my account and provide the email id (which is different for different stores) to which the report need to be deliverred. as he is primary of multiple stores, he need to setup multiple email ids. but the report is not getting deliverred to multiple email ids rather it is getting deliverred to only the default email id.
If you can help me in setting up this, it will be of much help,
Thanks,
-Shubh
Philip said
Hi Venkat,
I am working with BI and Mapviewer, and would like to know if you can point me in a direction for a solution to this problem:
I need to run a BI query (report) and THEN show the results of the query on the map.
An example would be a query or report that could show customers who sell green widgits with total sales of $x.xx per week. I need to show markers on the map for the location of only those customers and not customers who don’t meet the criteria of the query. This makes for a much more dynamic query / map application that is controlled by the user via the query power of BI.
Thanks.
Philip
milin said
hello sir,
milin said
hello sir;
I am fresher in BI and i want to ask u about future scope of BI in market?
Amit said
Good work Venkat. I come from similar interest. Do write me a email if you get a chance and I will like to see the prospect of doing something together. Eitherways, good luck and keep up the great work…..
best regards
Amit
Ed Eloian said
I am having trouble starting the OBIEE scheduler service. I get the 1064 error. Do you know why this is happening and how I can fix it.
Ramki said
Hi,
I am unable to install HFM web client is there any web patch required for that any one can help me.
Regards
Ramki
R Hari Haran said
Hello Venkat,
I chanced to see this blogsite and I must say that the information is very useful indeed.
I am working as a Program Manager for BI with one of the IT services major.
Congratulations on creating and maintaining this wonderful blogsite.
Sandeep Kumar Mohanty said
Hi Venkat,
You have put a real helpful information here abt development in OBIEE. It helped me a lot in past few days in my project. Thanks a lot to you for that.I am new to OBIEE and I have impemented the writeback to the answers. In my case I am writing back to a staging table instead of directy updating the data base. Later an OWB map updates my backend base tables from the staging table.So when the user logs back in he/she is able to see the update in the dashboard made by the writeback.
Here my client requires to capture the ‘Username’ of the user who makes a writeback and the date(sysdate) of updation as well.
Can you kindly advice me how to make it happen. If you can describe the steps with some screenshots for a sample example it would be really very helpful to me.
Thanks a lot in advance for all yur help.
Regards,
Sandeep
vineeth said
hi venkat,
i have a query. i am using a case statement to calculate the output into 3 ranges as high, medium or low.
here is the case query:CASE WHEN ( CAST(“V Circuit Pwe3 Details”.”Value Oat” AS INT) >=100 and CAST(“V Circuit Pwe3 Details”.”Value Oat” AS INT) =300)THEN ‘High’ ELSE ‘Low’ END END
cast function is used as the data type is varchar and i am comparing with numeric values.
the report is working perfectly fine. however when i use this output (case stmt column) as a prompt, i get the following error:
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 17001] Oracle Error code: 1722, message: ORA-01722: invalid number at OCI call OCIStmtExecute: select distinct concat(concat(T2407.LOCALITY_EA, ‘-’), T2407.TRS_AREA_EA) as c1, T2407.A_EQUIPMENT as c2, T2407.A_IP_ADDRESS as c3, T2407.CIRCUIT as c4, T2407.CREATE_DATETIME_ORDERS as c5, T2407.VALUE_OAT as c6, T2407.J_CEA as c7, concat(concat(T2407.LOCALITY_EZ, ‘-’), T2407.TRS_AREA_EZ) as c8, T2407.Z_EQUIPMENT as c9, T2407.Z_IP_ADDRESS as c10, T2407.J_CEZ as c11, T2407.Z_MTOSI_PORT_NAME as c12, T2407.PWE3_NAME as c13, T2407.VLAN_TYPE_CIRCUIT as c14, case when cast(T2407.VALUE_OAT as INTEGER ) = 100 then ‘Medium’ else case when cast(T2407.VALUE_OAT as INTEGER ) >= 300 then ‘High’ else ‘Low’ end end as c15, T2407.A_MTOSI_PORT_NAME as c16 from V_CIRCUIT_PWE3_DETAILS T2407 where ( case when cast(T2407.VALUE_OAT as INTEGER ) = 100 then ‘Medium’ else case when cast(T2407.VALUE_OAT as INTEGER ) >= 300 then ‘High’ else ‘Low’ end end = ‘Medium’ ) order by c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16. [nQSError: 17011] SQL statement execution failed. (HY000)
PLEASE DO HELP ME OUT !!!
V Murali said
Hi Venkat,
We are facing a pecuilar problem in OBI Reports.
If any report, which has provided with advanced sql filter condition those report output in csv not getting creating for other normal filter condition is able to create csv output.
Please let me know how to resolved this problem
Our OBIEE version 10.1.3.2.0
Regards,
V.Murali
Pankaj Garg said
Hello Sir,
I am newbie to OBI EE…and while working on it i got stuck…as per our requirement we need to make charts and put them on dashboards..that’s the easy part…now complex thing is i have to make slider that interact with that chart and the value and shape of the graph changes, as we change the values in the slider area….
please help me its very urgent…
Thanks & Regards,
Pankaj Garg
pankaj said
hello all
Is thr ny way to define error code and error messages tht wil display on dashboards..i mean is there any poss way of getting the error code and error msg that are defined by user….or is thr any file that contains a list of all error codes and msg’s
thanks,
pankaj
kalyaanasundhar said
Dear Venkatakrishnan,
I am kalyaanasundhar, working in dowell technologies, chennai. i was searching abt business intelligence in google and had a chance to see your blog, and thought u will be correct person to clear my doubt.
I don’t know nothing abt Business Intelligence? but i am interested to learn more abt it. before that i want to know wat is OBIEE, is it a tool? is it enough for me to learn OBIEE if i am good in Oracle and SQL server, is these basic thing is enough to learn OBIEE. I will be thankful to you if u give any tips regarding OBIEE and links to learn more abt OBIEE. I will be thankful to you if u send me the details to my mail id kalyaanasundhar@hotmail.com
Thanking you,
Regards
kalyaanasundhar
Bharatagraj said
Hi Venkat,
Just checking with you if you are working as a offshore with Oracle for OBIEE+? if so then there are chances that we crossed each other during your presentation at Bank Of America Corporate Treasury.
Just while googling for OBIEE/Hyperion got your blog. After reading your name thought should check with you.
Warm Wishes
Bharat
megha said
Hello Venkat,
I got stuck in Multilanguage configuration… I done all this steps which are mentioned in the Multilanguage ButWhen I done the Upadate row count in offline mode it shows all rows in the.csv. But while online mode it not reflect all the rows in the RPD..
Please help me out…
Bye take care
Person Who Should Know Better said
Hi Venkat,
I don’t know anything about BI at all. Can you write a quick blog post explaining everything there is to know. Please make it short, I have an interview in 2 days.
Person Who Should Know Better said
Hi Venkat,
In OBIEE, how do I integrate a dynamic, fortuitous call to a COBOL program from a dashboard prompt? The user must be able to choose the COBOL program and the mainframe its running on. The user also must not know he’s using OBIEE so can you tell me how to customize the screens to make it look like a Pacman game? The orginal, not Ms. Pacman. Can iBots help here?
Rachel said
Hi Venkatakrishnan,
Glad to see your blog, it’s really useful.
I have a problem with Analytics:
How can I add some customized links at the top right of the page, just side by side with “Dashboards – Answers – … – Log Out”?
I’m not sure where to find the source code for that frame.
Appreciate your time and hope to hearing back from you.
Rachel said
I got the answer from your previous page. Thank you and will keep my eye on here.
saichandv said
hi Venkat,
First thanks for your extreme support for all BI professionals.I worked on how to call bi publisher reports from ibots.I refered to your previous post they are doing well.
But i want to select a “Delivery Content” based in a BI Publisher Report, not a dashboard content… when I press the “Select Content” button the navigation explorer shows Dashboard Folders only…
The question is: I need to put a BI Publisher Report “into” a dashboard before call it from a iBot schedule?
Thanks and Regards,
V.Saichand
Elven said
hi sir,
i am newcomer in OBIEE
and i don’t know how to start, really newbie in ETL and Knowledge Management
would you mind guide me to learn, i mean, can you guide me to good website which teach about ETL and OracleBIEE.
For your suggestion thank you verymuch.
Steve Stein said
Venkat – We have a simple set up… links on the OBIEE dashboard to the Hyperion Workspace 9.3 report. The report is saved as a Financial Report but it has the PDF preview capability and our end users typically use that and print it. We want to pass in the URL (which we currently cut and paste from the SmartCut) some parameter so that it goes to the PDF preview instead of the HTML preview. Is this possible? Or is it something in Hyperion?
Smita Acharya said
Hi Venkat,
I am relatively a new user in OBIEE world.
CAn you pls suggest some good documentation on Intergartion of peoplesoft with OBIEE HR Analytics.
We are in process of enabling Authentication and authorization process in our HR analytics (OBIEE 10.1.3.4) , inherting peoplesoft configuration.
Pls suggest
Subramanian said
If you want to learn OBIEE , go thru OBIEE training ppt , which u can get from oracle guys
Naveen said
Hi Venkat,
Our OBIEE developers developed their reports. Now we want to integrate and show them users through Hyperion workspace. How to achieve this?
Rengenx said
Попробовал разобраться со статьей, но увы. Не могли бы вы написать свою аську или стукнуть мне – 783858