Contact Me

If you would like to reach out to me with questions or suggestions, you can send an email to krisvenky83@gmail.com. I would be replying within a day or two.

138 Responses to “Contact Me”

Egor Says:
September 6, 2007 at 6:35 am
Venkatakrishnan, thanx for a good blog! Let me give you a small tip: you can use Alt+PrintScreen to make screenshot of a current window, not whole desktop.
Venkatakrishnan J Says:
September 6, 2007 at 7:28 am
Thanks Egor. Wonderful suggestion. Will use it in future entries. Thanks again.
Thomas Wong Says:
September 29, 2007 at 3:38 am
I have a question regarding converting Oracle Report 6 to Hyperion System 9 Interactive Reporting. I know there is no direct method for the conversion but would like to find out is there a way to translate the Oracle Report 6 into PL/SQL code or other code format that the developer can use it as baseline for conversion? Thank you.
Rama Says:
October 3, 2007 at 11:57 am
HI Expert,

Can you please help me to come out of this peoblem

When Dashboard reports containing charts or graphs are executed
locally correctly and it’s displaying exactly
But the problem is if we accessed the same Dashboard with the
diffrerent URL like using system name instead of LoacalHost it’s
asking UserName and Password for each navigation and also Charts
or Graphs appearing as blank.
I am pasting my URL’s for your reference

http://localhost:9704/analytics/saw.dll?Dashboard
it’s working fine

http://w04251_itd:9704/analytics/saw.dll?Dashboard
it’s not working

My System Configuration Details
Oracle BI EE Version 10.1.3.3.0
Operating System Microsoft Server 2003 with SP2
Internet Explorer 6.0 and configured through Proxy Server

While installeing Oracle BI EE I have selected Basic and OC4j.

I am trying to open the Application Server Control using this URL
http://w04251_itd:9704/em/
It’s asking the username and Password but it’s not opening
it’s giving the Error Message
(This OC4J is configured to make JMX connections via RMIS and
fall back to RMI if the RMIS port is not configured. The RMIS
connection on the OC4J local instance is configured but a
connection could not be established. The JMX protocol is
specified by the oracle.oc4j.jmx.internal.connection.protocol
property in opmn.xml)
Venkatakrishnan J Says:
October 3, 2007 at 1:06 pm
The first thing that i would do is to check whether i am able to ping w04251_itd from command prompt. If you are not able to do that, try adding this to your etc/hosts file. Also, check whether you are able to make the url work by specifying the ip directly.
Madhu Says:
October 4, 2007 at 8:13 pm
Hi Venkatkrishna,

I am working on OBIEE(Siebel analytics) and wanted to check if it allows us to upload templates(.rtf) which generates the .pdf file like we generate the .pdf files in EBS using XML Publisher.

Thank you,
Madhu
Venkatakrishnan J Says:
October 4, 2007 at 8:25 pm
OBI EE consists of a suite of products. It has the following components

1. Answers
2. Dashboards
3. Delivers
4. BI Publisher
5. BI Office
6. Disconnected Analytics

You have BI Publisher(formerly XML Publisher) in BI EE. So, you can upload templates and generate pdfs using this.
Shan Says:
October 9, 2007 at 2:27 pm
Hi,
my BI SCHEDULAR SERVICE IS STILL NOT WORKING.I HAVE FULLFILL ALL THE STEPS WATCH IN YOU BLOG.I AM USING XP PROFESSIONAL EDITION PLS GUIDE ME IN THIS REGARD.
Evgeniy Says:
October 18, 2007 at 9:42 am
Hello, Venkatakrishnan!
Oracle BI EE:

How to refine data in aggregates tables (created by “create aggregates …” statement) after the data in corresponding database tables was updated?

It is unable to use the “delete aggregates” statement and then “create aggregates” again, because “delete aggregates” eliminates all aggregates in a model, but there are several aggregates in our model, that are intended for refining in different time moments and periods.

Thanks
Srinivas Says:
October 21, 2007 at 11:07 pm
Hi VenkataKrishnan,

How to cretae Drill down reports by using Answers only We Developed Dimensions in BMM layer.But My comapny want to develope the Drilldown reports by using Answers only Can you please give some guidelines.

Thanks,
Srinivas
Tim Says:
October 25, 2007 at 9:51 pm
Hi Venkatakrishnan,
Your site is extremely helpful and I really appreciate all the great information.

I was wondering if you could answer one question for me. Is it possible to run 2 Oracle presentation severs on the same NT server? We would like to spin up a DEV and TEST environment and are trying to figure out the best way to make that happen.
Thanks,
Tim
rodney Says:
October 26, 2007 at 3:43 am
I saw your video on Maps in OBIEE. I am interested to know how this was done. Can you forward me to where you found this content? Thanks!!
Venkatakrishnan J Says:
October 28, 2007 at 10:06 am
@Tim: Various deployment options are discussed in the deployment guide http://download.oracle.com/docs/cd/E10415_01/doc/bi.1013/b40058.pdf.

@Rodney: Even i am not sure which mapping tool is actually used there. The content’s direct link is here http://www.youtube.com/watch?v=G2GtwyYemYU.
Venkatakrishnan J Says:
October 28, 2007 at 10:09 am
@Srinivas: Always it is recommended to create all the dimensions, hierarchies etc within the repository. If you want to specify them in answers, one way is to have Report Navigation. Check my blog entry here http://oraclebizint.wordpress.com/2007/10/24/oracle-bi-ee-101332-custom-drill-path-navigation. This would give you a basic idea.
Manohar Says:
October 31, 2007 at 8:42 pm
Hi Venkat,

Need your inputs for performance tuning of the OBI reports? We have a situation where we need to show 100,000 records to the user ,the query when run on the backend database runs in a minute.
All indexes are in place.

When we run the report in OBI it is taking 10 minutes. Can you give me any suggestions on performance tuning.

Thanks,
Manohar
Manohar Says:
November 6, 2007 at 3:17 pm
Hi Venkat,

We found that the performance issue was more with database than the OBI.

Thanks,
Manohar
Pournima Patil Says:
November 7, 2007 at 11:37 pm
Hi Venkat,
You blog is very informative & it relly helps. I followed the steps you mentioned for OBIEE(10.1.3.3) & LDAP authentication. After that i have to integrate OBIEE wtih SSO. I have upadted credentialstore.xml & provided the passphrase in instanceconfig.xml. After this when i go to Presentation services i get following errors.
1. Not logged in page error
2. Sometime Unable to contact server.

An encrypted password was found in the credential ‘impersonation’, but no decryption passphrase has been specified. Please ensure that a decryption passphrase is specified in configuration. See documentation for details on how to configure the credential store.
Error Codes: WUDC2HWW
Can you give me any suggestion to resolve this issue.

Thanks,
PP
arifuk Says:
November 8, 2007 at 9:07 am
Hi,

I’m need to configure Discoverer with BI Publisher, but have a number of questions regarding what are the prerequisites.

I have installed (on a Windows 20003 SP2 env - vmware image).

Oracle BI 10.1.2.1, which consists mainly of Discoverer and Oracle Application Server Control

Oracle BI Publisher Release 10.1.3.2, which was installed as part of my OBI EE install 10.1.3.3. BI Publisher is configured to report against
OBI EE Subject Areas and Answer Request, using Oracle OBI Server Security Model.

Oracle 10gR2 10.2.0.1 is the Db for all repositories/EUL/reporting schemas etc.

I have downloaded patches
p5648158_10122_GENERIC.zip - which is the one off patch for Disco Web Services

OAS_Patch_p4960210_10122_WINNT.zip - which is the patch to bring the OAS upto 10.1.2.2

I’m reading articles
http://download.oracle.com/docs/cd/E10415_01/doc/bi.1013/e10416/discointeg.htm#BGBJBGID
http://www.rittmanmead.com/2007/09/09/integrating-bi-publisher-and-discoverer/
http://oraclebi.blogspot.com/2007/08/bi-publisher-discoverer-integration-4.html

From what I can understand I need to have OID (Oracle Internet Directory) and the OA Meta Repository already installed and configured, before applying the
OAS patch.

What download can I use to install OID and the OA Meta Repository (which also needs upgrading to 10.1.0.5) only.

I hope this is enough info to get a conversation started.

Thanks

Arif

arifsyed@btinternet.com
Sudipta Says:
November 13, 2007 at 11:22 pm
Hi Venkat,

We are looking for following Enterprise Reporting features in OBI

1. Drill Down(N-level) in Reports

Drill down facility upto any no. of levels inside the same report.

2. Event Based Report Scheduling

For example, a file drop event will trigger report data refresh.

3. Report Snapshot/History (N-instances)

Users should be able to view N no. of historical instances of a report

4. Conditional Formatting in Reports
based on a report column/field value -
a) data formatting to display some meaningful value to user(e.g. if TRANSACTION_TYPE =’D’ then show “Debt” else “Credit”
b) display formatting of one/more columnn/fields

5. Paging in Reports
displaying page numbers in reports and control to force page resetting on start of a new group

6. Role based access security to Reports
Mechanism to group reports under folders and ability to give access to user groups to view reports.

We had a look into OBI Publisher but we couldn’t find above features.

Can you please suggest us which OBI component can address our requirements.

Thanks in advance.

Warm regards,
Sudipta
Asit Says:
November 14, 2007 at 4:27 pm
Do you know how to SSO enable BI Suites? I can’t find instructions on SSO enabling BI Suites. I just opened and SR at Metalink. In the meantime, I would like to know if you know how to SSO enable BI suites. SSO enabling Discoverer was easy. Thanks,

– asit
Sachin Sethi Says:
November 19, 2007 at 5:13 am
Hi Venkat

Thanks for all information which profile , Can we call
oracle procedure and function from oracle OBIEE RPD File or Oracle
Answers because i want to use some calculated data in reports query….

Can you give me some Oracle Answers Layout guide where
i can find out layout features..

Thanks
Sachin
Edward Eloian Says:
November 20, 2007 at 4:03 pm
I am having trouble installing Oracle BIEE. When I run the installer i get the error message:

java.lang.NoClassDefFoundError: run exception in thread “main”

Do you know what this is and how to resolve?

Thanks,

Ed
Rajat Says:
November 26, 2007 at 9:20 am
Hi Venkat,

Can you give some idea about the various privilages.
What I want is a user who can only view the reports in dashboard ,i.e a user without edit dashboard privilage.

Thnaks,
Rajat
Vijay Kumar Ramagiri Says:
November 27, 2007 at 5:43 am
Hi Venkatakrisha,
Your blog is very useful and really help to others. I am working on OBIEE(Siebel analytics) and I wanted to restrict the data which is available in the Presentation Layer based on User Position.
rodney weinstein Says:
November 29, 2007 at 2:30 am
Hello - Keep up the good informative work.

Question - DO you know if there is a front end or back end setting that will collapse a specific dashboard box by default?

The global filters at the top can take up a lot of space. We do like it at the top, but would like only this window (section) collapsed when the user logs in. All the rest of the boxes should be opened. If the user wants to open up the filters to make a new selection, they then can do so.

Sorry - One more question - When putting charts into dashboard sections, there is a ton of whitespace surrounding them. To conserve space I would like to remove all the extra whitespace, but it is almost impossible to do. Any thoughts on if this can be done or tweeked a bit?

Thanks.
rodney weinstein Says:
November 29, 2007 at 2:32 am
Hello - Keep up the good informative work.

Question - DO you know if there is a front end or back end setting that will collapse a specific dashboard box by default?

The global filters at the top can take up a lot of space. We do like it at the top, but would like only this window (section) collapsed when the user logs in. All the rest of the boxes should be opened. If the user wants to open up the filters to make a new selection, they then can do so.

Sorry - One more question - When putting charts into dashboard sections, there is a ton of whitespace surrounding them. To conserve space I would like to remove all the extra whitespace, but it is almost impossible to do. Any thoughts on if this can be done or tweeked a bit?

Thanks.
Venkatakrishnan J Says:
November 29, 2007 at 7:03 am
Rodney,

In order to collapse certain sections as default, collapse them first in the dashboard. Then go to Page Options->Save Selections. So, save the page state and then make it as default. So, whenever a user logs in he would have the sections collapsed as default.

In order to remove the whitespace you need to tweak the styles and the skins. You need to find out which class adding that whitespace and try to remove them from the custom XML messages.

Venkat
Ponraj Says:
November 29, 2007 at 1:16 pm
Hi Venkat,
you are doing a great work. Thanks.

You have explained in the blog Customizing OBI EE - SOAP API that, how to use the web services of OBIEE to bring the results of an ‘Answers request’ into custom pages or places of our interest.
My requirement is as like this
I want to enable the end user to design his reports in my custom page as he would do in the Oracle Answers web console. In other words, i want the same functionality of Answers web console in my custom page.
Is it possible to achieve this requirement using web services? I have gone through the available web services. It seems my requirement is far from reachable. Wanted to have an expert opinion.

Thanks
Ponraj
Bilal Says:
November 30, 2007 at 10:27 am
HI Venkat,
Gr8 work done! I am happy to see a very informative blog on BI and DWH.
I am new to BI and currently working on OBI EE 10 with Oracle DWH 10.2. I need to show Tme Based (Year-Month-Days) capacity utilization in a chart in dashboard and want to work through Subject Area not through Query. The capacity is saved in Cube A while production is saved in Cube B. How can I use both of cubes in a single chart. Please note that we need to sum up capacity for every day spent start from the install of the machine, whereas it not necessary that we have processed material on that machine on a specific date. Cube A have used Dimensions Time, and Machines. Cube B have used Dimensions Time, Machines, Processes, Production, and Colors.

Please let me know the method to use.

Thanks

Bilal
sam Says:
December 4, 2007 at 5:17 am
hi venkat,

a blog on solaris installation will be of great help !!!

thanks,
sam
Bilal Says:
December 4, 2007 at 6:27 am
Hi Venkat,

Please guide me to refresh the data in Oracle (Siebel) BI. I am using Oracle WH 10G Rel 2 at back end. Connected to Oracle (Siebel Dash board) through Oracle (Siebel) Administration Layer. Currently I have to re import meta data from Oracle Warehouse to Administration Physical Layer. and Then Have to redefine hierarchies and redefine presentation layer. Is there any automatic or shortcut method to refresh the updated data already imported in Adminisration layer.

Thanks

Bilal
Bitloo Says:
December 6, 2007 at 11:02 pm
Hello Venkat,

I had sent you an email regarding this a long time ago but did not hear back, how may I implement a query like this in OB:

SELECT d1.date, (succ+fail) AS att, d1.succ, d1.fail, fail/att AS daily, (select (sum(fail) / sum(att)) from data
where date > (d1.date - 7) and date <= (d1.date) ) AS Cumm
FROM data AS d1;

The number 7 above is a variable, will keep changing.

Thanks.
Bitloo Says:
December 6, 2007 at 11:04 pm
Hi Venkat,

Which book will you recommend to learn more about OB and what it can do or point me to correct resource.

Regards,

Bitloo
Sheeba Grace.T Says:
December 10, 2007 at 4:38 am
Hi Venkat

Your blogs are really too good and most helpful.

I have created a dashboard using OBIEE 10.1.3.3.1.
Can you pls let me know how to deploy the same in client’s location?

Thanks & Regards,
Sheeba.T
Vikram Takkar Says:
December 10, 2007 at 6:16 am
Hi Venkatkrisnan,

I have one dimension table named as “Team” it has column “Team Type” and its value can be either Sales team or Traders team.It has “TeamKey” as a primary key of the Table and it mapps with salesTeamKey & TraderTeamKey of the Fact table. Actually Fact table contain these two keys “salesTeamKey & TraderTeamKey” and maps with TeamKey of the Dimension table.

I think its not possible to join the two table , i need to create Table alias for the dimension table.I know how to create the Table alias in the physical layer & BMM layer.Can you please tell me how to use the alias Table in Presentatiuon Layer?

Thanks n Advance.
Dawn Says:
December 11, 2007 at 6:34 am
Hi Venkat, I am trying to do aggregation and in BMM its showing an error code with 38091. This is thrown in the existing production rpd

Now..when we try to do it as new test rpd it throws another error 15019….. Please give your suggestions
Esther Says:
December 11, 2007 at 9:07 pm
Hi Venkatakrishnan,

Thanks for the nice OBI EE blog…

Would like to know how migration works in OBI EE. In other words, in discoverer we can export a single business area or the whole EUL.. How can we export a subject area in OBI EE or something along those lines. Any information on this would be really helpful.

Thank you,
-Esther
Deepika Says:
December 12, 2007 at 8:20 am
Hi Venkat,

Saw your blog oraclebizint.wordpress.com/ I must say very impressive stuff and hence I have included your blog link in our website here: http://www.keysoft.co.in/links.aspx

Venkat it would be great if you could contribute on our BI Forum: http://forums.keysoft.co.in/ and help other BI enthusiasts find solutions to their queries.

Do visit our knowledge section: http://www.keysoft.co.in/biknowledge.aspx and let me know your feedback on the same.
caimino Says:
December 12, 2007 at 10:02 am
Hi Venkatakrishnan,
I have a question for you.
I tried to customize reports’ Title View in order to implement multi-language.
My aim is to make reports’ Title View changeable depending on logon language’s choice.
Do you know a way for it?

Thank you in advance

Best regards

Cosimo
Venkatakrishnan J Says:
December 12, 2007 at 11:09 am
@Vikram - You need to achieve that in your Physical layer. Why do you want an alias in your presentation layer

@Dawn - More info on the error is required. Do you have the error messages

@Esther - What are you planning to do with the export. If it is for using in another machine just copy the RPD. Else you can merge the desired contents of your repository into an empty repository.
Vikram Takkar Says:
December 13, 2007 at 5:28 am
CAn you PLease tell me how would i solve the following problem:

I have one role Playing dimension ( Team ) that can have 2 value ( Either Sales or Traders) .this dimension has 1 key ie. teamKey that points to two keys in the fact table ( salesTeamKey & traderTeamKey)

CAn you please tell me how do i define the join for both tables ?

I think we can not solve this problem with single join , we need to create alias table for it and mention the joins differently for sale s and traders. OK

Now i need to drag that alias table in BMM and Presentaion layer also otherwise whats the fun of creating aliases? When i am checking the consistanct of the repository it is shwoing me error?

can you suggest me the solution.. ie. how to work with role playing dimension?

Thanks
Jamal Syed Says:
December 13, 2007 at 8:35 pm
Hi venkata,

I see an option for custom authentication plugin in Admin, but do not see any example on how to create one. Also, If we want to implement both LDAP and custom authentication, can we do that or is it just either or?

Thanks,

-jamal
Idetrorce Says:
December 15, 2007 at 12:50 pm
very interesting, but I don’t agree with you
Idetrorce
Sofia Says:
December 17, 2007 at 8:49 am
Hi Venkat

Can you pls explain the concept of briefing book in detail.

Sofia
Chandra Says:
December 18, 2007 at 6:55 am
Hi Venkat,

How can I restrict no of rows that are coming in a page for Pivot view.

-Chandra
Peter Says:
December 19, 2007 at 7:18 pm
Hi Venkat.
is it true, that variables cannot be used to change column headings dynamically? I am currently trying to do this but haven’t found a solution yet. All entries in custom headings seem to be interpreted as pure text.
juanc llanes Says:
December 20, 2007 at 1:27 am
i have a external custom search jsp page with a one parameter.

is possible to do a action link to this external custom search jsp page and pass parameter to it from a results in the dashboard?

How i can drill down to a external jsp page from results in the dashboard?
juanc llanes Says:
December 20, 2007 at 1:51 am
my problem is how to invoke a external custom search jsp page and how to pass parameter to it from a cell values from a results in the dashboard.

i read an example about action link but i don’t know where an how to define my own url for the my custom search jsp page in the answers request definition and how to pass to it a cell value as parameter from a dashboard during presentation session.
Rajeev Says:
December 21, 2007 at 6:05 pm
Hi Venkat, Can you please tell me how I can configure single sign on with siebel analytics.
Is there any document for doing this ?

Thanks
raj
Shailaja Says:
December 26, 2007 at 12:57 pm
Hi Venkat,

This is a plain query on connecting to Hyperion OLAP server from Cognos8 BI for accessing teh cubes cretaed in Essbase.

Could you throw some light on how a connection string gets formed for Essbase Server?

I tried giving the analytic server name with proper credentials but encounter teh error:
‘QFS-ERR-0138: DataSource ‘EB’ is not supported by any provider’

KIndly suggest ..

Rgds–
V Murali Says:
December 27, 2007 at 10:13 am
I have one customized software from that software I want to call OBI dashboard (other way I want to suppress the obi login screen)

At the same time I want to authenticated in OBI.

Please let me know your inputs.
V Murali Says:
December 27, 2007 at 10:13 am
I have one customized software from that software I want to call OBI dashboard (other way I want to suppress the obi login screen)

At the same time I want to authenticated in OBI.

Please let me know your input.
sam Says:
December 29, 2007 at 12:49 pm
Hi Venkat,

I need to transfer my reports from one OBIEE web server to another.
I transfered the .rpd file along with NQSConfig.INI and Instanceconfig.xml.
I’m able to see the Subject Areas but not the reports which I created.
Can you please let me know which other folders do I need to transfer

Thanks,
Sam
sam Says:
December 30, 2007 at 11:29 am
Hi friends,

I’m facing a peculiar problem in BI EE…..In charts the the numerical values are getting rounded off to 2 decimal places automatically ,even though in the table it is upto 6 decimal place.
For example 1.00612 is getting converted to 1.01 while plotting the charts.
Please help.

Thanks,
Rajat
asit Says:
January 1, 2008 at 7:22 pm
Hello Venkat,

First of all, thanks for the excellent blog on BIEE. One question for anyone.

Is it possible to make a Dashboard that can be accessed without username/password (ie. public access)? Thanks in advance?

– asit
Bharat Says:
January 3, 2008 at 6:23 am
Hi Asit,

Yes, its possible.
In Security section of NQSConfig.INI file use
AUTHENTICATION_TYPE = BYPASS_NQS;

hth,
bharat
Asit Says:
January 3, 2008 at 1:06 pm
I’ll try that. Thanks Bharat.
Corbaks Says:
January 3, 2008 at 3:34 pm
Hi Venkat,

first, happy new year!
and thanks for your excellent blog!

i have a little question for all.

i must developp an external application in java (servlet).
I will using SOAP API, this application must be totally integrated in a dashboard. (embedded content?)

my problem is : how i can retrieve SessionID or username in my application?

thanks in advance
Corbaks
Raviben Says:
January 4, 2008 at 3:54 pm
Hi Venkat,

As I have posted earlier, it’s taking ages to just import around 10 tables from ORMS. Is there any faster way. I have been waiting for around 3 1/2 hrs now.
Please help out.
Ali Haroon Nawaz Says:
January 5, 2008 at 12:58 pm
Dear Venkat:
I want to assign dynamically to dashboard prompt. My problem is such like that
I want to show two variablec in the form of list. One is about product value greater than 100 other is less than 100. Then in the next dashboard prompt those products name should be shown whose value is greater than 100 or less than 100 as selected. Please help me in this case. I dont know how i show two variable in the form of list. Separate I can show but how two coloumn I show in list. Please help me in these sections. Thanks
asit Says:
January 6, 2008 at 7:23 pm
follow-up question
By uncommenting following:

AUTHENTICATION_TYPE = BYPASS_NQS;
I still have provide something in username… it could be xyz or abc… it does not matter as long as there is something. There has to be a way to create a dashboard that requires no username/password. Thanks,

– asit

====================
Hello Venkat,

First of all, thanks for the excellent blog on BIEE. One question for anyone.

Is it possible to make a Dashboard that can be accessed without username/password (ie. public access)? Thanks in advance?

– asit

# Bharat Says:

Hi Asit,

Yes, its possible.
In Security section of NQSConfig.INI file use
AUTHENTICATION_TYPE = BYPASS_NQS;

hth,
bharat
Tapasvi Says:
January 7, 2008 at 11:43 am
Is it possible to render a BI Publisher report inside HTML DB (APEX) application ?

I am trying to achieve this by creating a web service based form and report page but not successful so far

I could successfully test only “validateLogin” and “hasReportAccess” method. runReport method gives ORA-20001: soapenv:Server.userExceptionjava.lang.NullPointerException error..
shekar Says:
January 14, 2008 at 11:49 am
Hi Venkat,

I would be pleased if you can clear my doubt. I have two independent reports namely ‘X’ and ‘Y’.
I just want to know if there is any chance where in i can see the two reports in only one report by using the drop down.

Thanks in advance.
Shekar
Brijesh Goyal Says:
January 15, 2008 at 7:16 am
Hi Venkat,

I was trying to build a report on Answers and got stuck at one point.I need a computed column say SumM1 such that it will hold summation of all the values that are coming in column M1.

for eg.

M1 SumM1

10 60
20 60
30 60

I searched for almost all the option but none of them worked for me.

Kindly share your view on that.

-Brijesh
shekar Says:
January 16, 2008 at 7:09 am
Hello Venkat,

Its been a wonderful work by you. We all appreciate you for that.
This is where everyone gets clear of all the doubts and share it to others, solved by you or by any other. We would really be happy if you can answer our queries as soon as possible. It’s been a month that you haven’t replied 2anyone, because queries solutions are so crucial.
Its a plea, and we can understand that you have ur own commitments
Venkatakrishnan J Says:
January 16, 2008 at 1:41 pm
Apologies everyone who have been waiting for a reply. Never realized the Contact Me page would get so many comments and hence did not check them for any updates. Anyway my replies are below.

@Vikram - Just create an alias in the physical layer and then make a join.

@Jamal - I think you can do a combination of both. I am planning to put together a blog entry for custom Authentication.

@Sofia - Is there anything specific that you want to know on the briefing books?

@Chandra - Do you want a Pagination in the pivot view or do you want to just filter the rows?

@Peter - Unfortunately yes. Though you can mimic dynamic column headers using another text view. I will blog about this later.

@Juanc - Check my blog entry here http://oraclebizint.wordpress.com/2007/12/26/oracle-bi-ee-101332-drills-across-sections-in-a-dashboard/. It has an example.

@Rajeev - This is documented in the Deployment guide.

@V Murali - Just pass the username and passwords in the URL itself. That will achieve what you need.

@Asit - Just pass the username and passwords in the URL itself. That will achieve what you need.

@Corbaks - How about using GO URL? SOAP APIs can also be used. But for most cases GO URL will more than suffice. Can you explain what exactly is your business scenario?

@Raviben - Can you try using ODBC instead of OCI? I have heard seen some strange things happening when you use OCI for importing metadata especially in 10.1.3.3. But you should use OCI in the connection pool.

@Tapasvi - Yes very much possible. Can you provide more details on the error? How are you handling the final result output?

@Shekar - Yes very much possible. 2 approaches can achieve this. Either use Guided Navigations or GO URL for each of these reports. I am planning to blog about this.

@Brijesh - Use SUM() if you have SUM as aggregation in the repository. If you no aggregation in the rpd then use SUM(SUM())
Rajeev K Says:
January 16, 2008 at 6:40 pm
Hello Venkat

Do you knw , in Answers , how do i assign permission for a user to use the Custom text format in Column Properties> Data Format tab , with Override Default dATA Format checked? The Admin id has the rights to view this option in the drop down , but i need to provide this to users too so that they can write javascripts for navigation purposes.

Thanks
sree Says:
January 17, 2008 at 1:03 pm
Hi,
I want to create two tables under one main dim table in the presentation Layer.
I want to cretate the main dim table is “Prodcuts”. Under this main dim table I want to display two sub dimensions like ” Product Type” and ” Product Sub Type “.

Can you pls give me adive how you can achieve.

Regards
Sree
sree Says:
January 18, 2008 at 8:58 am
Hi Krishna,
I have implemented the pagination as per the code you given today.
But i am getting the Syntax Error.
Can you pls help into this.

Regards
Sree
Venkatakrishnan J Says:
January 18, 2008 at 10:34 am
@Sree - What error do you get?
V Murali Says:
January 19, 2008 at 11:14 am
Hi venkat,

Is it possilbe to display dynamic tool tip in column fields.

Regards,
Murali
V Murali Says:
January 22, 2008 at 1:11 pm
Hi Venkat,

Tool Tip : We have report having four differnt columns such as Employee Name,Date,Salary,No.of Leaves.

In the Employee Name column ,when user moves mouse pointer at that time we need employee should show where customer can able to employee id.

could you please help us,we need your help which help lot for deveopment process

Thanks

Regards,
Murali
Lokesh Says:
January 23, 2008 at 3:07 pm
Hi Venkat,

my problem is
i have two edit box in prompt.
1)Name 2)ID
i have assigned server variable to ID edit box.
when ever i open the screen i find default value assigned to ID.
i remove the default value and enter value in name edit box.
on which i want to search.
but as soon i enter value on edit box and click on Go button, my screen will refresh and again default value is assigned again it ID

i tried to modify globalfilterprompt.js

and i tried to understand Source file generated by report
i found that GFPUpdateValues
event is called onblur

as this code generated by Server, and i don’t have acces to Server to modify, i found this would be better option to avoid this problem.

can you tell more about GFPUpdateValues function

thanks,
Lokesh
sid Says:
January 24, 2008 at 6:21 pm
Venkatakrishnan,
I am new to OBIEE and has learnt a lot from your blogs. I have a problem regarding Pivot tables based reports….certain reports come back with too many rows that OBIEE can not handle (due to default limits)…so I tried to override them with this setting in instanceconfig.xml =>

200000
750000
1500
2000

That damn thing is not working. What can go wrong? The node definitions above are put within ServerInstance node and there is a chart -> DefaultImageType node below the definition that is working.

Also if I use JPEG as my default image type, can I use map based prompts?

Thanks a lot for considering my questions…..and keep up this great blog. If you have an answer to my instanceconfig nightmare, please mail me.
sid Says:
January 24, 2008 at 6:25 pm
Sorry,
in the previous post my xml tags are eaten by browser or some parser at wordpress. Here is the tags and values with removed (I do not wated to write”&gt” you know:

PivotView
CubeMaxRecords 200000 /CubeMaxRecords
CubeMaxPopulated Cells750000 /CubeMaxPopulatedCells
MaxVisibleSections 1500 /MaxVisibleSections
MaxVisiblePages 2000 /MaxVisiblePages
/PivotView
Manju Nambiar Says:
January 29, 2008 at 7:22 pm
Hey Venkat,
I am doing a fresh install and configuration of OBIEE.
I followed the steps in your blog “Oracle BI EE 10.1.3.3/2 - Using LDAP/OID Authentication” to configure security using company LDAP.
Instead of OID, I am using the company LDAP. After creating the server, I tested the connection and was successful. Next I tried Import option, but got the Oracle BI Administration Tool error message: “There is nothing to import.”
Next I tried the initialization block setup and system variables - but no luck.
Is this an LDAP privilege issue or OBI issue?
I tried the same LDAp with a LDAP viewer tool and am able to see all the users.
Please help me out.
Thanks,
Manju
Girish Says:
January 31, 2008 at 8:41 am
Hi Venkat,
I want Pagination in the Pivot Table view(i.e) i want to restrict the number of rows same like a table view in Pivot table view
Prakash Says:
January 31, 2008 at 12:42 pm
Hi,

The Button which I’have created for Write Back through the Table Properties is disabled.Is there any specific setting which we have to do to enable it.

I’have a Oracle DB tabel SALES with two columns EMPID & REVENUE .

I would like to update the REVENUE colum with the write Back feature.

I’ve created a WrightBackTemplet.xml file & placed it in D:\SAS_INSTALLED\SiebelAnalytics\Web\App\Res\CustomMessages

The XML file looks like ..

UPDATE SALES SET REVENUE=@2 WHERE EMPID=@1

COMMIT

I’ve also added the Write Back privileges to the WebAdministrator.

Kindly let me know what else I have to do.

Y the button is not enabled?

Thanks
Prakash
Jonah Says:
January 31, 2008 at 4:56 pm
Hi Venkatakrishnan,

Great blog! I have a question for you. We are running hyperion essbase 6.5.3 for building our cubes and WebFOCUS for our front end reporting. We are looking at upgrading our reporting and data mart system to system 9 (OBI EE + 4 Hyperion Components) in order that hopefully it works better under one umbrella product and cost savings from licensing costs. I read your overview on the Hyperion System 9 BI solution and was wondering whether this solution can run a web front end as good as webFOCUS and if it can read OLAP (essbase) and relational (Oracle) sources. We do not financial reports but that function may be used in the future. Should I consider anything else? Thank you.
David Says:
February 1, 2008 at 9:59 pm
Hi Venkatkrishna,

Like your blog. A simple question about OBIEE 10.1.3. Back in Siebel 7.8 you could place 2 or more reports within one report. For example, if I wanted to display a report on people hired followed by a report on plant inventory I would simple embedded them together and print to a PDF. In 10g this feature is now gone. I need to print 10 different reports into one PDF! I cannot use one answer query to run all these reports. Is this possible in OBI or do I need to run something in Adobe PDF writer?

Thanks in advance
V Murali Says:
February 4, 2008 at 8:08 am
Hi Venkat,

I want to design rpd for my historical data maintance.Both fact and dimension table are partition of 14.

customer needs latest partition data should display in the report and there should be dashboard prompt where user can able select the desire partition data and report should refresh with reference to user selection paramter.

We have same fact and dimension tables without partition having 2lakh records and report data displaying within 15 seconds and same report with partition table it is displaying more than one minutes.
Venkatakrishnan J Says:
February 4, 2008 at 1:28 pm
@David - How about creating a new page and adding your reports there. You can take a PDF of the entire dashboard page.

@Jonah - Absolutely you should consider now using BI EE plus which has both Hyperion Components and BI EE Components. Hyperion Web Analysis can seamlessly report on both Essbase and Relational tables. Also, BI EE can do that. Both of them have a very good UI.
SholaO Says:
February 5, 2008 at 12:29 am
Hi Venkatakrishnan,

Question on: ONLINE REPOSITORY FOR OBIEE Connection Pool.

I’ve search through you to your BI blog for information on ONLINE connection Pool and your blog has an excellent content materials on overall BI subject matter

My Scenario: I’ve created a custom Repository based on custom tables (XX_TEST_5.rpd) with an OCI10g/11g with appropriate data source. I’m always able to update row count offline, without any issue with no Global consistency and the rpd is available for query. But when I updated (on local desktop) NQSConfig.INI with my above rpd name, and try to validate my repository Online within OBI Admin tool, I always get an “nQSError-17014” error.

I’ve explored all known options even I tried to validate the rpd within my local BI answer with all Privilege Administration setting for Answer and I’m still unable to connect ONLINE.

I‘ve tried every option possible including using different versions of OCI available. Currently I can proceed to do anything within BI Answer and unable to progress with my current dashboard project.
Would you have any recommendations on how to overcome this issue? Thanks a lot for your assistance in advance.

Thanks,
SO
Victor Says:
February 7, 2008 at 8:28 am
Hi, there…
I´m a complete adict to your blog.
When got any doubt, get my Bible, but although you´ve got 2 posts about my question, I can´t understand completely about Date Answers treatment.
I´m trying to get a date from user, and when the variable gets nothing, want to intializate with a default date. Here is where the error raises. When try without the variable, it runs, so I think there is a problem with my format.My filter:

FILTER( “curr_budget”.Ammount USING (”curr_budget”.Date BETWEEN @{timestamp(Get_date)}{timestamp ‘2007-01-01 00:00:00′} AND @{timestamp(Get_date)}{timestamp ‘2007-12-31 00:00:00′}) )

It´d be great if you can show me where is the problem.
Thanks in advance, Venkatakrishnan…
bill Says:
February 7, 2008 at 3:35 pm
Hi Venkatakrishnan,
Your site is extremely a great helpful tool and I really appreciate all the great information that you have posted here.

I was wondering if you could post something about Hyperion system 9, such as the installation, configuration and deployment. This is pretty hot BI technology, but unfortunately, there is no related material on system 9 configuration and installation. Actually, I loved the idea of your demonstration by posting the screenshots and was thinking if you could do the same with system 9 installation

Thanks, bill
Farz Says:
February 8, 2008 at 5:46 pm
Hi Venkatakrishnan,

Thanks for all your blog entries.
Do you have any blog or documents for BI EE web services similar to what you have created for BIP and Web services. Thanks.

Oracle BI Publisher 10.1.3.3.1 - Creating Applications using JDeveloper 11g and Web Service SOAP APIs
Karthikeyan Sankaran Says:
February 9, 2008 at 12:00 pm
Hi Venkat,

My name is Karthik. Just got introduced to your blog. Seems like you have lots of good information out here. Will keep visiting this site more often.

I am also a BI professional and blog at http://www.beyeblogs.com/karthikonbi. The discussion topics are more general in nature and not necessarily on specific tools though. Oracle BI is definitely generating lot of interest right now and am interested in learning more about its capabilities.

If possible, please include me in your blog roll.

Thanks and keep writing!

Regards
Karthik
Rama Says:
February 10, 2008 at 1:11 pm
Hi Venkat,

I am facing the problem In chart view the numerical values are getting rounded off to 2 decimal places. but in the table view the values are showing correct values.

Is there any configuration changes we need to do?

Thanks & Regards,
Rams
Mohamed Nadim Says:
February 13, 2008 at 7:15 am
Hi Venkat.

Your posts are really good and informative.
I have a question though….How can I give the OBIEE dashboard users the option to change their passwords.

Please reply.

Thanks.

MoN
Venkatakrishnan J Says:
February 13, 2008 at 10:25 am
@Mohamed - Check my blog entry here http://oraclebizint.wordpress.com/2007/10/28/oracle-bi-ee-101332-changing-passwords-from-presentation-services/
Divya Says:
February 13, 2008 at 2:26 pm
Hi,
My luck that I visited this informative blog..positive that i will get a quick answer to my OBIEE query

The requirement is this.. On click of ‘print’ at the Java front end, it should invoke the corresponding OBIEE report(without opening its interface) and print the same. My doubt is :
1) Is it possible to invoke OBIEE without user intervention i.e can OBIEE credentials be parametrised?
2) Without opening the report, can we pass the filter values to OBIEE layer from Java front end?

Can this be achieved? Please let me know.

Thanks,
Divya
Venkatakrishnan J Says:
February 13, 2008 at 2:54 pm
Yes very much. Check my blog entry here http://oraclebizint.wordpress.com/2007/07/30/customizing-obi-ee-%e2%80%93-go-url-parameters/. You can pass filter parameters, user credentials etc via a URL.
Divya Says:
February 13, 2008 at 3:47 pm
Hi,
Thanks for the quick reply, Venkat. I will be requiring more information on the same. Will be a regular visitor from today onwards…

Thanks,
Divya
Gathatharan Says:
February 14, 2008 at 10:39 am
Hi Venkat
BI scheduler service is not getting started and showing this error

Could not start the oracle BI Scheduler Service on local computer.
Error 1064:An Exception occured in the service when handling the control request

could you please help me out
Ashok Das Says:
February 14, 2008 at 11:39 am
Hi Venkatakrishnan,

I am using OBIEE 10.1.3.2.0 and am facing one issue in DAC. When I run any execution plan from DAC, the execution plan fails within a sec and when I checked the DAC ServerLog, it says “W_ETL_TAG - not a DAC table!!”. If you have any idea about this, can you please help me out.

Below is the error log:
10173 SEVERE Thu Feb 14 15:35:08 IST 2008
——————————————–

START OF ETL

——————————————–
10174 INFO Thu Feb 14 15:35:08 IST 2008 Creating Connection Pool.
10175 FINE Thu Feb 14 15:35:08 IST 2008 Inside CreateConnectionPool: got a resultset of dbconnections.
10176 FINE Thu Feb 14 15:35:08 IST 2008 Inside CreateConnectionPool: about to create pool.
10177 INFO Thu Feb 14 15:35:08 IST 2008 Creating connection pool. : DataWarehouse
10178 INFO Thu Feb 14 15:35:09 IST 2008 Reading password from database
10179 INFO Thu Feb 14 15:35:09 IST 2008 1 attempt
10180 FINE Thu Feb 14 15:35:09 IST 2008 Inside CreateConnectionPool: pool created.
10181 FINE Thu Feb 14 15:35:09 IST 2008 Inside CreateConnectionPool: about to create pool.
10182 INFO Thu Feb 14 15:35:09 IST 2008 Creating connection pool. : SEBL_VERT_80
10183 INFO Thu Feb 14 15:35:09 IST 2008 Reading password from database
10184 INFO Thu Feb 14 15:35:09 IST 2008 1 attempt
10185 FINE Thu Feb 14 15:35:09 IST 2008 Inside CreateConnectionPool: pool created.
10186 INFO Thu Feb 14 15:35:09 IST 2008 Connection Pool created.
10187 INFO Thu Feb 14 15:35:09 IST 2008 Creating Server Pool.
10188 INFO Thu Feb 14 15:35:09 IST 2008 Reading password from database
10189 INFO Thu Feb 14 15:35:09 IST 2008 1 attempt
10190 INFO Thu Feb 14 15:35:10 IST 2008 Server Pools created.
10191 INFO Thu Feb 14 15:35:10 IST 2008 Returning an instance of EmailManager…
10192 FINE Thu Feb 14 15:35:10 IST 2008 At the start of EmailManager.dispatch
10193 WARNING Thu Feb 14 15:35:10 IST 2008 No receipients for email registered! Please register email recipients who will be informed about ETL progression.
10194 INFO Thu Feb 14 15:35:10 IST 2008 Getting actual start timestamp for this ETL
10195 INFO Thu Feb 14 15:35:10 IST 2008 The actual timestamp is 2008-02-14 15:35:08.901
10196 INFO Thu Feb 14 15:35:10 IST 2008 Initializing ETL parameters.
10197 INFO Thu Feb 14 15:35:10 IST 2008 Starting to load the tables and index information
10198 INFO Thu Feb 14 15:35:10 IST 2008 Finished to load the tables and index information
10199 INFO Thu Feb 14 15:35:10 IST 2008 Going to load steps to be run.
10200 FINEST Thu Feb 14 15:35:10 IST 2008 Number of indexes cannot be greater than the number of connections or less than 1. Defaulting to 0 for ORA_11_5_10_Flatfile
10201 FINEST Thu Feb 14 15:35:10 IST 2008 Number of indexes cannot be greater than the number of connections or less than 1. Defaulting to 0 for UNIV
10202 FINEST Thu Feb 14 15:35:10 IST 2008 Number of indexes cannot be greater than the number of connections or less than 1. Defaulting to 0 for SEBL_VERT_80_Flatfile
10203 FINEST Thu Feb 14 15:35:10 IST 2008 Number of indexes cannot be greater than the number of connections or less than 1. Defaulting to 0 for ORA_11_5_10_Flatfile
10204 FINEST Thu Feb 14 15:35:10 IST 2008 Number of indexes cannot be greater than the number of connections or less than 1. Defaulting to 0 for UNIV
10205 FINEST Thu Feb 14 15:35:10 IST 2008 Number of indexes cannot be greater than the number of connections or less than 1. Defaulting to 0 for SEBL_VERT_80_Flatfile
10206 FINEST Thu Feb 14 15:35:10 IST 2008 Number of indexes cannot be greater than the number of connections or less than 1. Defaulting to 0 for ORA_11_5_10_Flatfile
10207 FINEST Thu Feb 14 15:35:10 IST 2008 Number of indexes cannot be greater than the number of connections or less than 1. Defaulting to 0 for UNIV
10208 FINEST Thu Feb 14 15:35:10 IST 2008 Number of indexes cannot be greater than the number of connections or less than 1. Defaulting to 0 for SEBL_VERT_80_Flatfile
10209 FINE Thu Feb 14 15:35:10 IST 2008 Populating application information.
10210 FINE Thu Feb 14 15:35:10 IST 2008 Populating all the tags for application Siebel 8.0 Vertical
10211 SEVERE Thu Feb 14 15:35:10 IST 2008
ANOMALY INFO::: Error while loading nodes.
MESSAGE:::java.lang.IllegalArgumentException: W_ETL_TAG - not a DAC table!
EXCEPTION CLASS::: com.siebel.analytics.etl.util.database.SqlParserException

com.siebel.analytics.etl.util.database.DACSqlParser.getTable(DACSqlParser.java:479)
com.siebel.analytics.etl.util.database.DACSqlParser.processFromClause(DACSqlParser.java:333)
com.siebel.analytics.etl.util.database.DACSqlParser.processSelect(DACSqlParser.java:285)
com.siebel.analytics.etl.util.database.DACSqlParser.parse(DACSqlParser.java:109)
com.siebel.analytics.etl.util.database.DACSqlParser.parseSQL(DACSqlParser.java:5
com.siebel.analytics.etl.execution.Application.populateTags(Application.java:201)
com.siebel.analytics.etl.execution.Application.init(Application.java:129)
com.siebel.analytics.etl.execution.Application.(Application.java:109)
com.siebel.analytics.etl.execution.ApplicationContainer.getApplication(ApplicationContainer.java:40)
com.siebel.analytics.etl.execution.ApplicationContainer.getApplication(ApplicationContainer.java:52)
com.siebel.analytics.etl.execution.ExecutionPlanDesigner.retrieveExecutionPlanTasks(ExecutionPlanDesigner.java:28
com.siebel.etl.engine.core.SessionHandler.loadNodes(SessionHandler.java:365)
com.siebel.etl.engine.core.ETL.thisETLProcess(ETL.java:322)
com.siebel.etl.engine.core.ETL.run(ETL.java:604)
com.siebel.etl.engine.core.ETL.execute(ETL.java:831)
com.siebel.etl.etlmanager.EtlExecutionManager$1.executeEtlProcess(EtlExecutionManager.java:210)
com.siebel.etl.etlmanager.EtlExecutionManager$1.run(EtlExecutionManager.java:164)
java.lang.Thread.run(Thread.java:595)

::: CAUSE :::
MESSAGE:::W_ETL_TAG - not a DAC table!
EXCEPTION CLASS::: java.lang.IllegalArgumentException

com.siebel.analytics.etl.client.data.repository.OwnershipType.getValue(OwnershipType.java:4
com.siebel.analytics.etl.client.data.repository.TableReferenceHelper.(TableReferenceHelper.java:34)
com.siebel.analytics.etl.util.database.DACSqlParser.getTable(DACSqlParser.java:475)
com.siebel.analytics.etl.util.database.DACSqlParser.processFromClause(DACSqlParser.java:333)
com.siebel.analytics.etl.util.database.DACSqlParser.processSelect(DACSqlParser.java:285)
com.siebel.analytics.etl.util.database.DACSqlParser.parse(DACSqlParser.java:109)
com.siebel.analytics.etl.util.database.DACSqlParser.parseSQL(DACSqlParser.java:5
com.siebel.analytics.etl.execution.Application.populateTags(Application.java:201)
com.siebel.analytics.etl.execution.Application.init(Application.java:129)
com.siebel.analytics.etl.execution.Application.(Application.java:109)
com.siebel.analytics.etl.execution.ApplicationContainer.getApplication(ApplicationContainer.java:40)
com.siebel.analytics.etl.execution.ApplicationContainer.getApplication(ApplicationContainer.java:52)
com.siebel.analytics.etl.execution.ExecutionPlanDesigner.retrieveExecutionPlanTasks(ExecutionPlanDesigner.java:28
com.siebel.etl.engine.core.SessionHandler.loadNodes(SessionHandler.java:365)
com.siebel.etl.engine.core.ETL.thisETLProcess(ETL.java:322)
com.siebel.etl.engine.core.ETL.run(ETL.java:604)
com.siebel.etl.engine.core.ETL.execute(ETL.java:831)
com.siebel.etl.etlmanager.EtlExecutionManager$1.executeEtlProcess(EtlExecutionManager.java:210)
com.siebel.etl.etlmanager.EtlExecutionManager$1.run(EtlExecutionManager.java:164)
java.lang.Thread.run(Thread.java:595)

::: CAUSE :::
EXCEPTION CLASS::: java.lang.NullPointerException

com.siebel.analytics.etl.merge.RepositoryUtils.getDiffEntityBean(RepositoryUtils.java:141)
com.siebel.analytics.etl.merge.RepositoryUtils.getOwnershipStatus(RepositoryUtils.java:175)
com.siebel.analytics.etl.client.data.repository.OwnershipType.getValue(OwnershipType.java:44)
com.siebel.analytics.etl.client.data.repository.TableReferenceHelper.(TableReferenceHelper.java:34)
com.siebel.analytics.etl.util.database.DACSqlParser.getTable(DACSqlParser.java:475)
com.siebel.analytics.etl.util.database.DACSqlParser.processFromClause(DACSqlParser.java:333)
com.siebel.analytics.etl.util.database.DACSqlParser.processSelect(DACSqlParser.java:285)
com.siebel.analytics.etl.util.database.DACSqlParser.parse(DACSqlParser.java:109)
com.siebel.analytics.etl.util.database.DACSqlParser.parseSQL(DACSqlParser.java:5
com.siebel.analytics.etl.execution.Application.populateTags(Application.java:201)
com.siebel.analytics.etl.execution.Application.init(Application.java:129)
com.siebel.analytics.etl.execution.Application.(Application.java:109)
com.siebel.analytics.etl.execution.ApplicationContainer.getApplication(ApplicationContainer.java:40)
com.siebel.analytics.etl.execution.ApplicationContainer.getApplication(ApplicationContainer.java:52)
com.siebel.analytics.etl.execution.ExecutionPlanDesigner.retrieveExecutionPlanTasks(ExecutionPlanDesigner.java:28
com.siebel.etl.engine.core.SessionHandler.loadNodes(SessionHandler.java:365)
com.siebel.etl.engine.core.ETL.thisETLProcess(ETL.java:322)
com.siebel.etl.engine.core.ETL.run(ETL.java:604)
com.siebel.etl.engine.core.ETL.execute(ETL.java:831)
com.siebel.etl.etlmanager.EtlExecutionManager$1.executeEtlProcess(EtlExecutionManager.java:210)
com.siebel.etl.etlmanager.EtlExecutionManager$1.run(EtlExecutionManager.java:164)
java.lang.Thread.run(Thread.java:595)
10212 INFO Thu Feb 14 15:35:10 IST 2008

10213 INFO Thu Feb 14 15:35:10 IST 2008 The ETL took 0 Minutes
10214 INFO Thu Feb 14 15:35:10 IST 2008 Returning an instance of EmailManager…
10215 FINE Thu Feb 14 15:35:10 IST 2008 At the start of EmailManager.dispatch
10216 WARNING Thu Feb 14 15:35:10 IST 2008 No receipients for email registered! Please register email recipients who will be informed about ETL progression.
10217 FINEST Thu Feb 14 15:35:10 IST 2008 EtlSummary columns: {}
10218 INFO Thu Feb 14 15:35:11 IST 2008 Releasing connection pools…
10219 INFO Thu Feb 14 15:35:11 IST 2008 Releasing the concurrency manager…
10220 SEVERE Thu Feb 14 15:35:11 IST 2008
——————————————–

END OF ETL

——————————————–
Divya Says:
February 14, 2008 at 12:03 pm
Hi,
I am adding further to my query above (No. 91).

Your suggested blog entry gave an idea that we can pass user credentials and filters through URL. However, the requirement doesnt end there. The report data should be passed from OBIEE directly to the printer without user ever seeing the Answers. He would be introduced just to the Java front end where conditions can be entered and there would be a print option. Firing a printout should invoke corresponding report in Answers(which user isnt introduced to) and then report print out is obtained.

Is this possible? If yes, please suggest how.

Regards,
Divya
Diego Anderiz Says:
February 14, 2008 at 7:43 pm
Hello all,

I have a result set from a request in Oracle BI EE Answers which uses a fact table that contains variable readings (from a gauge) and variable names from a dimensions table that I want to display in a pivot table.

On the pivot table I have a Timestamp fact as Rows and a dimension Variable Name on the columns. The Variable Reading (from the fact table) I insert into the measures.

When I run this report, the Variable Measures appear blank in my pivot.

That is strange as when I display in a standard table in Answers I have fully populated rows with A number of Variable Name values, thousands of Variable Reading values and corresponding Timestamp values when they were taken.

Basically we need for each Variable Name (columns) we want to have the Variable Readings values against the Timetstamp (rows) when they were taken. No complexity here, no aggregations, sums, averages required.

Can somebody help please?
Thank you
Manohar Says:
February 15, 2008 at 9:08 pm
Hello Venkat,

We have a strange problem in our dashboards. Whenever users are selecting a value having special character from the prompt the answers are coming as no results.
Whereas the backend table has the records.

Is there any special setting or configuration needs to be done to support special characters in OBI.

Thanks,
Manohar
V Murali Says:
February 16, 2008 at 10:36 am
Hi Venkat,

We are not able to see/apply the OBI Dashboard

“Read” permission.
We are our using OBIEE 10.1.3.3
We are getting following permission only
No Access->Travese folder->change/delete->Full

Control

Can u suggest how to get “Read” permission

Thanks
Murali
Vishy Says:
February 19, 2008 at 3:43 pm
Hi,

We have a requirement where we need to enable Sort By and Total By on dashboard for a particular report such that All Columns are listed under Sort By and Total By and when either of them chosen, it performs the necessary operations. Sort By can be enabled for Tables in the Table Options but is there a way how we can enable similar feature for Total By such that reports get totaled by Selected Column?

Appreciate any assistance on this.

Regards,
Biswa
Vijay Kumar. Ramagiri Says:
February 20, 2008 at 11:09 am
Hi Venkat,

I need your help. We have a requirement i.e. weekly report. If we open any day in the week it will show previous week monday to sat day information only. my date feild is in text format. so please send required SQL quiry for this situation.

Regards,
Vijay.Ramagiri
Antimbala Says:
February 21, 2008 at 11:51 am
Hi,

I just want to know that how to implement local languages in Austria(lang-Austria -German DEA), Belux(lang English-Belux ENB), Greece(lang-ELL) etc.. others are supported by Oracle. how to go about these.

A quick reply will be really helpful..

thanks in advance.
Antimbala Says:
February 21, 2008 at 12:02 pm
Hi,

I have another query regarding exporting captions:
1) Can we do for all folders at once. i didn’t find any such option.
2) When we export for each folder then we get chunk of XML files for each catalog.Our requirement is to convert all the catalog folders to different languages so we need to send these XMl files to the translators to do the translations. actually we need to send so many files that will be hassle for the translator and again if we missed any then it would be a problem . Can you suggest some simple way to do the same.

waiting for your reply.
Thanks in advance.
V Murali Says:
February 22, 2008 at 8:56 am
Venkat,

how to pass nqusers and nqpassword value as a variable in Dashboard Text object.

Thanks,
Murali
Helen Says:
February 27, 2008 at 7:54 am
Hi Venkatakrishnan,
please help me with this issue:
how can i create multisheet excel output for a report?

Thanks a lot!
Helen
Gaurav Nankar Says:
February 27, 2008 at 9:42 am
Hi Venkat,

I m facing a problem with the Job Manager which does not open. I have tried re-installing the whole application but of no use.

Regards,
Gaurav
Anoop Says:
February 27, 2008 at 10:14 am
Venkat,

Am trying to retrict my dashboard wiht the respect to the company and user. I want to restict only those companies for a particular user. I also want to hide certain coloumns for certain user.

Kindly advice
Anoop
Venkatakrishnan J Says:
February 27, 2008 at 10:35 am
@Helen - There is no out of the box way to do that. I have blogged about it earlier here http://oraclebizint.wordpress.com/2008/02/07/oracle-bi-ee-101332-combining-multiple-excel-report-outputsworkbooks-to-a-single-excel-report-using-bi-delivers-bi-publisher-apis-and-vb-scripts/

@Gaurav - Do you get any specific error? Can you try starting it up from command line?

@Anoop - You need to assign privileges in your dashboard that way. Also, you can use GROUP level security or VPD to give column level access to different users.
Gaurav Nankar Says:
February 28, 2008 at 8:48 am
Hi Venkat,

Yes, I hav etried through the command line also.It does not throw any error. But the Job Manager Window does not appear. When I checked the log file at OracleBIData\jobmanager it shows the following message:

!SESSION 2008-02-28 14:16:04.115 ———————————————–
eclipse.buildId=I20050627-1435
java.version=1.4.2
java.vendor=Sun Microsystems Inc.
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en_US
Command-line arguments: -data D:\OracleBIData\jobmanager

!ENTRY org.eclipse.osgi 2008-02-28 14:16:05.147
!MESSAGE An error occurred while automatically activating bundle oracle.bi.jobmanager (5).
!STACK 0
org.osgi.framework.BundleException: The activator oracle.bi.jobmanager.JobmanagerPlugin for bundle oracle.bi.jobmanager is invalid
at org.eclipse.osgi.framework.internal.core.AbstractBundle.loadBundleActivator(AbstractBundle.java:149)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:965)
at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:316)
at org.eclipse.osgi.framework.internal.core.AbstractBundle.start(AbstractBundle.java:264)
at org.eclipse.core.runtime.adaptor.EclipseClassLoader.findLocalClass(EclipseClassLoader.java:116)
at org.eclipse.osgi.framework.internal.core.BundleLoader.findLocalClass(BundleLoader.java:337)
at org.eclipse.osgi.framework.internal.core.SingleSourcePackage.loadClass(SingleSourcePackage.java:37)
at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:386)
at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:350)
at org.eclipse.osgi.framework.adaptor.core.AbstractClassLoader.loadClass(AbstractClassLoader.java:7
at java.lang.ClassLoader.loadClass(Unknown Source)
at org.eclipse.osgi.framework.internal.core.BundleLoader.loadClass(BundleLoader.java:275)
at org.eclipse.osgi.framework.internal.core.BundleHost.loadClass(BundleHost.java:227)
at org.eclipse.osgi.framework.internal.core.AbstractBundle.loadClass(AbstractBundle.java:124
at org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:152)
at org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:142)
at org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:129)
at org.eclipse.core.internal.registry.ConfigurationElementHandle.createExecutableExtension(ConfigurationElementHandle.java:4
at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:222)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:163)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.core.launcher.Main.invokeFramework(Main.java:334)
at org.eclipse.core.launcher.Main.basicRun(Main.java:27
at org.eclipse.core.launcher.Main.run(Main.java:973)
at org.eclipse.core.launcher.Main.main(Main.java:94
Caused by: java.lang.UnsupportedClassVersionError: oracle/bi/jobmanager/JobmanagerPlugin (Unsupported major.minor version 49.0)
at java.lang.ClassLoader.defineClass0(Native Method)
at java.lang.ClassLoader.defineClass(Unknown Source)
at org.eclipse.osgi.framework.adaptor.core.DefaultClassLoader.defineClass(DefaultClassLoader.java:370)
at org.eclipse.core.runtime.adaptor.EclipseClassLoader.defineClass(EclipseClassLoader.java:233)
at org.eclipse.osgi.framework.adaptor.core.DefaultClassLoader.findClassImpl(DefaultClassLoader.java:343)
at org.eclipse.osgi.framework.adaptor.core.DefaultClassLoader.findClass(DefaultClassLoader.java:235)
at org.eclipse.osgi.framework.adaptor.core.AbstractClassLoader.findLocalClass(AbstractClassLoader.java:183)
at org.eclipse.core.runtime.adaptor.EclipseClassLoader.basicFindLocalClass(EclipseClassLoader.java:141)
at org.eclipse.core.runtime.adaptor.EclipseClassLoader.findLocalClass(EclipseClassLoader.java:82)
at org.eclipse.osgi.framework.internal.core.BundleLoader.findLocalClass(BundleLoader.java:337)
at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:389)
at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:350)
at org.eclipse.osgi.framework.adaptor.core.AbstractClassLoader.loadClass(AbstractClassLoader.java:7
at java.lang.ClassLoader.loadClass(Unknown Source)
at org.eclipse.osgi.framework.internal.core.BundleLoader.loadClass(BundleLoader.java:275)
at org.eclipse.osgi.framework.internal.core.BundleHost.loadClass(BundleHost.java:227)
at org.eclipse.osgi.framework.internal.core.AbstractBundle.loadBundleActivator(AbstractBundle.java:142)
… 28 more
Root exception:
java.lang.UnsupportedClassVersionError: oracle/bi/jobmanager/JobmanagerPlugin (Unsupported major.minor version 49.0)
at java.lang.ClassLoader.defineClass0(Native Method)
at java.lang.ClassLoader.defineClass(Unknown Source)
at org.eclipse.osgi.framework.adaptor.core.DefaultClassLoader.defineClass(DefaultClassLoader.java:370)
at org.eclipse.core.runtime.adaptor.EclipseClassLoader.defineClass(EclipseClassLoader.java:233)
at org.eclipse.osgi.framework.adaptor.core.DefaultClassLoader.findClassImpl(DefaultClassLoader.java:343)
at org.eclipse.osgi.framework.adaptor.core.DefaultClassLoader.findClass(DefaultClassLoader.java:235)
at org.eclipse.osgi.framework.adaptor.core.AbstractClassLoader.findLocalClass(AbstractClassLoader.java:183)
at org.eclipse.core.runtime.adaptor.EclipseClassLoader.basicFindLocalClass(EclipseClassLoader.java:141)
at org.eclipse.core.runtime.adaptor.EclipseClassLoader.findLocalClass(EclipseClassLoader.java:82)
at org.eclipse.osgi.framework.internal.core.BundleLoader.findLocalClass(BundleLoader.java:337)
at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:389)
at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:350)
at org.eclipse.osgi.framework.adaptor.core.AbstractClassLoader.loadClass(AbstractClassLoader.java:7
at java.lang.ClassLoader.loadClass(Unknown Source)
at org.eclipse.osgi.framework.internal.core.BundleLoader.loadClass(BundleLoader.java:275)
at org.eclipse.osgi.framework.internal.core.BundleHost.loadClass(BundleHost.java:227)
at org.eclipse.osgi.framework.internal.core.AbstractBundle.loadBundleActivator(AbstractBundle.java:142)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:965)
at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:316)
at org.eclipse.osgi.framework.internal.core.AbstractBundle.start(AbstractBundle.java:264)
at org.eclipse.core.runtime.adaptor.EclipseClassLoader.findLocalClass(EclipseClassLoader.java:116)
at org.eclipse.osgi.framework.internal.core.BundleLoader.findLocalClass(BundleLoader.java:337)
at org.eclipse.osgi.framework.internal.core.SingleSourcePackage.loadClass(SingleSourcePackage.java:37)
at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:386)
at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:350)
at org.eclipse.osgi.framework.adaptor.core.AbstractClassLoader.loadClass(AbstractClassLoader.java:7
at java.lang.ClassLoader.loadClass(Unknown Source)
at org.eclipse.osgi.framework.internal.core.BundleLoader.loadClass(BundleLoader.java:275)
at org.eclipse.osgi.framework.internal.core.BundleHost.loadClass(BundleHost.java:227)
at org.eclipse.osgi.framework.internal.core.AbstractBundle.loadClass(AbstractBundle.java:124
at org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:152)
at org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:142)
at org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:129)
at org.eclipse.core.internal.registry.ConfigurationElementHandle.createExecutableExtension(ConfigurationElementHandle.java:4
at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:222)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:163)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.core.launcher.Main.invokeFramework(Main.java:334)
at org.eclipse.core.launcher.Main.basicRun(Main.java:27
at org.eclipse.core.launcher.Main.run(Main.java:973)
at org.eclipse.core.launcher.Main.main(Main.java:94

!ENTRY org.eclipse.osgi 2008-02-28 14:16:05.163
!MESSAGE Application error
!STACK 1
org.eclipse.core.runtime.CoreException[1]: java.lang.UnsupportedClassVersionError: oracle/bi/jobmanager/rcp/Application (Unsupported major.minor version 49.0)
at java.lang.ClassLoader.defineClass0(Native Method)
at java.lang.ClassLoader.defineClass(Unknown Source)
at org.eclipse.osgi.framework.adaptor.core.DefaultClassLoader.defineClass(DefaultClassLoader.java:370)
at org.eclipse.core.runtime.adaptor.EclipseClassLoader.defineClass(EclipseClassLoader.java:233)
at org.eclipse.osgi.framework.adaptor.core.DefaultClassLoader.findClassImpl(DefaultClassLoader.java:343)
at org.eclipse.osgi.framework.adaptor.core.DefaultClassLoader.findClass(DefaultClassLoader.java:235)
at org.eclipse.osgi.framework.adaptor.core.AbstractClassLoader.findLocalClass(AbstractClassLoader.java:183)
at org.eclipse.core.runtime.adaptor.EclipseClassLoader.basicFindLocalClass(EclipseClassLoader.java:141)
at org.eclipse.core.runtime.adaptor.EclipseClassLoader.findLocalClass(EclipseClassLoader.java:122)
at org.eclipse.osgi.framework.internal.core.BundleLoader.findLocalClass(BundleLoader.java:337)
at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:389)
at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:350)
at org.eclipse.osgi.framework.adaptor.core.AbstractClassLoader.loadClass(AbstractClassLoader.java:7
at java.lang.ClassLoader.loadClass(Unknown Source)
at org.eclipse.osgi.framework.internal.core.BundleLoader.loadClass(BundleLoader.java:275)
at org.eclipse.osgi.framework.internal.core.BundleHost.loadClass(BundleHost.java:227)
at org.eclipse.osgi.framework.internal.core.AbstractBundle.loadClass(AbstractBundle.java:124
at org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:152)
at org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:142)
at org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:129)
at org.eclipse.core.internal.registry.ConfigurationElementHandle.createExecutableExtension(ConfigurationElementHandle.java:4
at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:222)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:376)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:163)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.core.launcher.Main.invokeFramework(Main.java:334)
at org.eclipse.core.launcher.Main.basicRun(Main.java:27
at org.eclipse.core.launcher.Main.run(Main.java:973)
at org.eclipse.core.launcher.Main.main(Main.java:94

Regards,
Gaurav
Parag Says:
March 4, 2008 at 10:04 am
Hi Venkat,

I have gone through your blog on the topic of rendering OBI reports in to the oracle portal using OC4J WSRP Container.

I could successfully replicate first two steps and af

Business Intelligence - Oracle

Categories

Top Posts

Bookmark

About Me

Blogroll

Subscribe

Meta

Stats

Contact Me

138 Responses to “Contact Me”