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.
Category
- Acquisitions
- All Posts
- APEX
- Bi Publisher
- Coherence
- Conference
- Data Mining
- Data Modelling
- Database
- Enterprise Performance Foundation
- EPM
- General
- Hyperion Business Rules
- Hyperion DIM
- Hyperion Essbase
- Hyperion Financial Reporting
- Hyperion Shared Services
- Hyperion Web Analysis
- Hyperion Workspace
- Informatica
- Mapviewer
- OBI EE Plus
- OLAP
- Oracle 11g
- Oracle Data Integrator
- Oracle EPMA
- OWB
- Web Center Suite
Top Posts
- Oracle BI EE 10.1.3.3/2 - Between Prompts for Date Columns - Using Presentation Variables
- Oracle BI EE 10.1.3.3/2 - Custom Drill Path Navigation
- Hyperion Essbase and JAPI - Custom Applications using JDeveloper
- Hyperion Essbase 11.1.1.0 - Transparent Partition - Using ASO as Partition target - Part 1
Pages
August 2020 M T W T F S S 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Archives
Bookmark
About Me
I am Venkatakrishnan J, a Business Intelligence enthusiast working with Rittman Mead Consulting 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 Rittman Mead Consulting or Oracle. Going forward, i would be blogging at http://rittmanmead.com/blog.Blogroll
- Abhinav Agarwal
- Adrian Ward
- Alex
- Andriy Yakushyn
- Antonio Romero
- Asktom
- Borkur Steingrimsson
- Christian Berg
- David Aldridge
- Dimitri Gielis
- Doug Burns
- Eddie Awad
- Frank Buytendijk
- Howard Rogers
- John Goodwin
- John Minkjan
- Jonathan Lewis
- Justin Kestelyn
- Karthik
- Laurent Scheider
- MAIA Blog
- Marcos Campos
- Michael Armstrong-Smith
- Oracle OLAP Blog
- Pawel Barut
- Pete Finnigan
- Peter Scott
- Ramkumar Krishnan
- Rittman and Jon Mead
- Tim Dexter
- Tim Hall
- Tom Kyte
- Vlamis
Subscribe
Meta
Stats
Egor said
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 said
Thanks Egor. Wonderful suggestion. Will use it in future entries. Thanks again.
Thomas Wong said
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 said
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)
Vazir Ahamed said
Hi Rama,
Im facing the same issue which you have faced on the year 2007.
i.e. you are able to see charts in one url and unable to view in another url.
Can you tell me how did you resolve this issue.
It will be very very helpful for me.
thanks
Vazir.
Venkatakrishnan J said
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 said
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 said
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 said
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 said
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 said
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 said
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
Janet Lovely said
I need an OBIEE Developer my direct client in Nottingham, England.
>
> The project is 2 months + and starts January 4, 2010..
>
> Ideally, I need a Sr Oracle BI Developer with extensive OBIEE Reports Development experience. The resource must have OBIA FIN/HR
>
> standard reports experience and be local to the UK.
>
> I can pay $80/hr all inclusive on a C2C or $70/hr on a W-2 in US Dollars.
>
> I wonder if you or perhaps a colleague might be interested.
>
> If so, Please send a copy of your current resume in word doc format and contact information.
>
rodney said
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 said
@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 said
@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 https://oraclebizint.wordpress.com/2007/10/24/oracle-bi-ee-101332-custom-drill-path-navigation. This would give you a basic idea.
Manohar said
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 said
Hi Venkat,
We found that the performance issue was more with database than the OBI.
Thanks,
Manohar
Pournima Patil said
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 said
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 said
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 said
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 said
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 said
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 said
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 said
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 said
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 said
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 said
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 said
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 said
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 said
hi venkat,
a blog on solaris installation will be of great help !!!
thanks,
sam
Bilal said
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 said
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 said
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 said
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 said
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 said
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 said
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 said
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 said
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 said
@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 said
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 said
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 said
very interesting, but I don’t agree with you
Idetrorce
Sofia said
Hi Venkat
Can you pls explain the concept of briefing book in detail.
Sofia
Chandra said
Hi Venkat,
How can I restrict no of rows that are coming in a page for Pivot view.
-Chandra
Peter said
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 said
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 said
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 said
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 said
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 said
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 said
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 said
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 said
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 said
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 said
Hi Asit,
Yes, its possible.
In Security section of NQSConfig.INI file use
AUTHENTICATION_TYPE = BYPASS_NQS;
hth,
bharat
Asit said
I’ll try that. Thanks Bharat.
Corbaks said
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 said
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 said
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 said
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 said
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 said
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 said
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 said
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 said
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 https://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 said
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 said
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 said
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 said
@Sree – What error do you get?
V Murali said
Hi venkat,
Is it possilbe to display dynamic tool tip in column fields.
Regards,
Murali
V Murali said
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 said
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 said
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 said
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”>”) you know:
PivotView
CubeMaxRecords 200000 /CubeMaxRecords
CubeMaxPopulated Cells750000 /CubeMaxPopulatedCells
MaxVisibleSections 1500 /MaxVisibleSections
MaxVisiblePages 2000 /MaxVisiblePages
/PivotView
Manju Nambiar said
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 said
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 said
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 said
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 said
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 said
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 said
@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 said
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 said
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 said
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 said
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 said
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 said
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 said
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 said
@Mohamed – Check my blog entry here https://oraclebizint.wordpress.com/2007/10/28/oracle-bi-ee-101332-changing-passwords-from-presentation-services/
Divya said
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 said
Yes very much. Check my blog entry here https://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 said
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 said
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 said
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:58)
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:288)
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:48)
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:58)
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:288)
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:58)
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:288)
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 said
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 said
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 said
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 said
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 said
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 said
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 said
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 said
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 said
Venkat,
how to pass nqusers and nqpassword value as a variable in Dashboard Text object.
Thanks,
Murali
Helen said
Hi Venkatakrishnan,
please help me with this issue:
how can i create multisheet excel output for a report?
Thanks a lot!
Helen
Gaurav Nankar said
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 said
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 said
@Helen – There is no out of the box way to do that. I have blogged about it earlier here https://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 said
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:78)
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:1248)
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:48)
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:278)
at org.eclipse.core.launcher.Main.run(Main.java:973)
at org.eclipse.core.launcher.Main.main(Main.java:948)
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:78)
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:78)
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:78)
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:1248)
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:48)
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:278)
at org.eclipse.core.launcher.Main.run(Main.java:973)
at org.eclipse.core.launcher.Main.main(Main.java:948)
!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:78)
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:1248)
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:48)
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:278)
at org.eclipse.core.launcher.Main.run(Main.java:973)
at org.eclipse.core.launcher.Main.main(Main.java:948)
Regards,
Gaurav
Parag said
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 after that the WebService URL from the container is also perfectly working –
http://10.10.4.182/biee/portlets?WSDL
Now – in third step while registering the WSRP provider after copying above path in my Jdev – its not able to recognize the WSDL at this path .. Inspite of giving proper proxy settings 😦
I am not supposed to use a diff path than the one above for registering my producer , isn’t it ??
Please let me know whether I have missed something ..
TIA.
Parag Naik
Debanjan De said
Hi Venkat,
I found your blog very informative and helpful. Recently we are facing some issues in our BI Publisher 10.1.3.3.1 installation. Initially we were not able to connect BI Analytics with BI Publisher. Hence we modified different setup files several times. And now we are getting the below error while logging into BI Publisher –
The server can not be used due to a configuration error, please contact the administrator. If you are the administrator, please consult BI Publisher user guide for proper configuration.
oracle.apps.xdo.servlet.resources.ResourceNotFoundException: /u01/BIEE/xmlp/XMLP/Users/~administrator/Learn/Admin/Security/principals.xml
We took back all the setup files which we modified (xmlp-server-config.xml, security.xml, principals.xml) to the initial form. But still we are unable to fix the above error.
These are the current file contents are –
xmlp-server-config.xml
======================
security.xml
============
principals.xml
==============
/u01/BIEE/xmlp/XMLP/Admin/Security> cat principals.xml
Regards,
Debanjan
Debanjan De said
Venkat,
It seems due to some problem, the file contents were not shown properly in my last message.
Here are the files –
xmlp-server-config.xml
======================
principals.xml
==============
security.xml
============
rodney weinstein said
Is there a way to run an iBot or a briefing book get now action from the command prompt or a utility?
We have a data load in scripts and want to tack onto the end of them the execution of an iBot or the running of the function that creates and compiles the brifing book.
Thanks.
Rodney
Madan said
Is there any way we can implement Business Object Touch File concept in BIEE. In BO, report scheduling is done based on these files. the process is Once ETL is done, ETL Process creates a touch file, BO scheduling look for file, If file is avilable then they are going to run the reports. Is there any way BI Ibots can look for a file in physical/network folders and then executes?
Avik said
I have been following your blog for some time now. The solutions that you provide are fabulous. I have been helped greatly by them.
Now I would like your favor in helping me out in creating a case-insensitive multi select prompt in Oracle BI-EE. It would be great if you could provide a solution, especially if it modifies the already defined JavaScript in {OracleBI} oc4j_bi\j2eehome\applications\analytics\analytics\res\b_mozilla\prompts (i.e. like by modifying the onKeypress event of the text box in the multi select box. Or by converting the text inside the text box of the multi select prompt into UPPER CASE before firing the query to database to fetch the possible set of values in the multi select box) using the for the multi select prompts. Since my report is already very loaded and are pretty slow. Any other solution should also be fine.
It is pretty urgent, so it would be very good, if you could provide me a solution as soon as possible.
V Murali said
Hi Venkat,
We need find option in OBI at report level.
Current on click of all pages option which downloads entire data into single page then go for Ctrl+F and pass the finding value.
Which is impacting our report because in our reports data is huge i.e. more than 2million.
Could you please suggest us how create search option in report level where user can able to find desired data/information.
Thanks in advance
Regards,
Murali
lakshmi said
Hi Venkat,
we have faced problems with DAC….we have 350 tasks are there..all tasks are completed when we run complete ETL but 4 tasks still in queue…there is no running tasks…can u tell me what is the problem….ASAP. i need your’s valuable suggestions.
lakshmi said
Hello Venkat,
I am Lakshmi, i need your help with your valuablesuggestions…how to run the DAC Server in Globally…how many methods are the for RUN the DAC Server…pls let me know your valuable suggestions….it’s very urgent….pls any one help me….regarding this issue.
Thanks
Lakshmi.
lakshmi said
Hello Venkat,
we are using Siebel Analytics 7.8.4 version… i need your information….for DAC what are the drawbacks are there in Siebel Analytics 7.8.4 varsion…
pls any one help me……is there any problems for DAC in 7.8.4.
Thanks
Your’s Lakshmi.
Sonal said
I have created a new repository with Physical , Business and Presentation Layer. The presentation Catalog name is ‘HR’. I made the business model ‘ Available for queries’ in business model. I also restarted the Presentation and BI Server services. When i login into Answers then I see the Subject Area ‘HR’ but i don’t see the tables which i see in presentation layer.
Please help. Do I need to do some settings ?
V Murali said
Venkat,
I want to put Dashboard prompt link under a folder,which is my customer looking for.
Please let me is it possible or not.If possible please let me know the process.
Thanks in advance.
Regards,
Murali
Jeoneence said
I’d prefer reading in my native language, because my knowledge of your languange is no so well.
Raj said
Venkat,
I have two questions.
1> is it possible to put a iBOT link on the dashboard page, so that i can schedule it rightaway?
2> I read your blog about implementing multilanguage using externalize string utility in RPD. I still have one doubt. how to implement for multiple language like french, protugese,Espanol etc together based on user selected language?
Dan said
Hi Venkat,
My client recently upgrated from 7.8.4 to 10.1.3.3 and they liked the old default colors in the charts much better (more contrast). I saw your blog about using Firebug (which is absolutely awesome by the way), but it hasn’t helped me locate where to change to default colors of charts in the .css files. When I use ‘Inspect’ it highlights the entire chart instead of each bar/piece of pie/etc. Do you know an easy way to locate where this change should be made?
Thanks in advance,
Dan
Kiran said
Hi Venkat,
I need to connect to OBI presentation server through IE .
I have done Impersonation in RPD & created user Impersonator by using help as given in OBI deployment guide. I have configured IIS accordingly.
The basic need for the task is that I want ‘Single Sign On’ on BI presentation server.
I have configured credentialstore & instanceconfig xml files using deployment guide help.
So whenever I try to connect through URL ( http:\\localhost\analytics\saw.dll?encryptString&string= ) I get error as per following:
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
So any help is appreciated.
Thanks in advance.
keerthi said
Hi!
I came across this blog when I was browsing for some help to login to BI publisher, & found interesting solutions for many questions.
Recently, I downloaded BI publisher desktop on to my laptop to practice as it was going to be started at my work place. When I installed it I could see the BI Publisher icon on Microsoft applications, but when i tried to login, it asks for user name & password which the administrator has assigned. Can we practice on BI Publisher on a PC.
I would really appreciate if your help.
Thanks
Hassan said
Hi Venkat,
I have made a repository in Administration tool following exactly the same steps which are mentioned in Oracle Tutorial for OBI. I could import and use the sample of Oracle and make Analytics on them. However when I make my own physical, business model and presentation layer based on my own database, I could not start BI server. The server works well for Oracle SH.rpd but when I change Star value in NQSconfig.ini to my own repository (Caesar) I get error 1064 and BI server does not start at all. What am I doing wrong?
Star = sh.rpd, DEFAULT;
# Star = Caesar.rpd, DEFAULT;
Regards,
Hassan
David said
Hello Venkatakrishnan, Thanks for your blog. It is very helpful. I am new to obiee and have a challenging task to figure out things by myself. Here is my question:
Assuming, I have 3 customers and each one is a member of a different group. I want to give these 3 customers permission to create new users. Here is the catch. For the security reasons, each of these customers can create users only in his own group and can not see the data for other groups. So, if my customer is a GE manager, he can only create users who belong to GE group and can not see the users in other companies.
thx
David
Sankar said
Hi Venkat,
I have installed MS Office plugin sucessfully, i go the Oracle BI tab in Excel & Powerpoint when i try to login it is throwing “Unknown Error”. When i try “Test Connection” it is saying connection sucessful.
Please let me know the solution for this as soon as possbile.
Thanks,
Regards,
Sankar
Vijay Kumar Ramagiri said
Hi Venkatakrishnan,
Your site is extremely helpful and I really appreciate all the great information.
I need your help. When i am download my dashboard report into excel, i am not get the images in excel sheet.
sravan kumar said
In graphs the values are rounded off to 2 decimals .For example if the value is 99.99456 in graph it is showing as 100.I want to show the exact value in graph.Thanks in advance
Srini said
Venkat,
You are doing an awesome job..
I am trying to change the skin dynamically using the variable SKIN. On the dashboard home page, is there gif/jpg that is available in ’sk’ folder that i can edit and add some customized text? Most of the things in that page are in ’s’ style folders…Once again, you rock man !!!!
Thanks,
Srini
John T. said
Have you ever addressed how to use the Combined Results feature (i.e. union)?
Also, I’m trying to produce a financial account report where some of the expense categories have no fact rows associated with them but yet I would like to show thos expense categories anyway and with zeroes for the amount.
Thanks
Joe said
Hi Venkat,
when i am running multi tasks parallely. my presentation services are going down.
For Ex: I am generating 4 list files at a shot. Then presentation server is going down.
PLease suggest me if any chnages required in any files.
Thanks in Advance,
Joe
Vijaylaxmi said
Hi,
Thanks a lot for publishing such useful info in this Blog.. Its really helpful.
Srukmana said
Hello,
I have installed the MS offcie plug in and every thing works fine. But when I try to open a report in power point which actually has prompts in OBIEE, a window pops up prompting to “insert views”. But when I check the values in the “insert view” window its not asking for any prompts and its display the report. But as per the help doc it sholud display the prompts and I should be able to select the values from it. I am not sure if I missed something while installing the BI Office plug in. Can any one help me with this.
Thanks.
Raso said
Can you please let me know where to setup link for download.
Same report in Answer will show links for
Modify – Refresh – Print – Download – Add to Briefing Book – Copy
but same report in Dashboard has only options
Print and Add to Briefing Book
What happend with other options.
Rafael Marques said
Hi!
Dou you know any way to show (in Java) parent first?
I’ve been searching the web about that but no success 😦
Like a simple retrieve <IChild MbrName shows me:
Chil1
Chil2
Chil3
Chil4
Parent
I’d like to show like this:
Parent
Chil1
Chil2
Chil3
Chil4
Is that possible?
Thanks in advance!
Srikanth said
“Raso Says:
May 2, 2008 at 10:56 pm
Can you please let me know where to setup link for download.
Same report in Answer will show links……..”
On the dashboard click on the page options>>edit dashboard, in the edit mode click on the properties>> Report link.
Under the report links you will find all the links which you want to display on the dashboard.
Manas said
Venkat,
I’m need to merge webcat files with different user settings in Dev and Prod. Is there a way we can do it?
Thanks,
Manas
newdb said
Hi,
I am trying to use Java SSO with OBIEE Analytics Application. I want to know if I have to install Oracle AS for this and not implement SSO with standalone oc4j. I have tried configuring the instanceconfig.xml/credentialstore.xml files with no success. Is there any way I could ORA_OC4J_SSO to extract the login information?
Thanks,
Sirisha.
siva said
Hi Venkat
I have a problem with creating time siries to compare the current year resluts with previous results.
But how can i acheive this to come more than one year. Can you pls help me in this regard
Thanks & Regards
Siva
Aniket said
Hi,
I have a report that navigates to another report based on a column named Business Unit. The report it navigates to has multiple Item codes for the selected Business Unit.
This process works fine. What I am trying to achieve is this navigation should work only if there are Item codes for a business unit. Can I restrict the navigation link only for the Business Units that have Item codes in another report.
Any suggestion would be highly appreciated.
Regards,
Aniket
Boyd Patterson said
Hi Venkat,
I am proposing OBIEE SOAP integration to a client of mine, but we have been receiving some static on it saying that he OBIEE soap integration is not stable, the better choice would be to go with BI Publisher.
Using the GO_URL would be simpler but will not provide the users with the same look and feel they currently have including the choice of columns to be added to a predefind report format.
The client needs to replace an existing application where they are using Actuate with its Flexible Framework. They currently allow they users to choose from a menu of report templates and report formats along with providing a choice of columns that can be included in the report. The reports are then run and automatically saved in pdf format. These saved reports are archived and can be viewed at a future time.
I beleive the same can be acheived using SOAP calls to OBIEE. What are your thoughts.
Thanks
Boyd
Aravind said
Hi Venkat,
It is simply great and informative blog. You are doing an awesome job venkat.
I need to know how Portal and OBI integration will take place by using GO URl parameter.
Could you please help in this regards
Thanks
Aravind
Vijay said
We have populated data into ware house tables using DAC for entities ORDERS, CONTACTS, ASSET, ACCOUNT, QUOTES, OPPORTUNITY AND VEHICLES.
Now we want to view this data into Automotive pre-built reports and dashboards. So how can we customize the vanilla repository (OracleBIAnalyticsApps.rpd) for Automotive in order to view the data in the pre-built reports?
I’m able to query for the data using answers with the results. Also in presentation layer, I’m unable to see the standard pre-built dashboards links.
Can you please make me understand as to how to implement the further process to reflect the data only into pre-built AUTOMOTIVE dashboard.
Best regards
Vj
Mais said
Hi Venkat,
We are facing a problem when BI users change their password, belwo is an overview of the problem:
•We have enabled the Users to change their passwords.
•When a User tries to change the password by clicking on change password link, it produces an error message (‘… … the repository is locked’), even though the password change works correctly (This function works only once per user per BI server restart).
•The same error message appears for every subsequent Password change attempt but the system fails to change the password.
By looking into the log files, below are the findings:
•Change password function works fine for the first time a user tries, even though an error message is displayed.
•The RPD meta-data log file gets changed when a password is changed, but the RPD itself doesn’t reflect the changes till a server restart is performed.
•OBIEE locks the RPD file whenever there’s a RPD meta-data log file change resulting in a session lock. Each subsequent attempts to change the password results in a system error ( “…….Repository is locked”) due to this lock and multiple sessions are created for the same user with every attempt.
•The RPD Meta-data log file changes are reflected on to the RPD, the sessions are killed and the lock is released up on restarting the BI server.
Questions:
1.Why does the error message come even if the user is able to change the password (first time per user per server restart)?
2.Is there a way to push the meta-data log file changes to RPD without restarting the BI server?
Thanks in advance!
Kind Regards,
Mais
mayur said
Hi Venkat,
I got a requirement like this, I need to display the row values into one column field.
For eg: There are two columns A and B
A B
xxxxx 12
xxxxx 123.f
ppp
Gopal said
Hi Venkat
Sorry i couldn’t complete the scenario.
For eg:
Column A Column B
pppp xx.1
pppp cc.0
aa dd
aa qq.2
I want the repot like the below
Column A ColumnB
pppp xx.1, cc.0
aa dd,qq.2
Thanks in Advance.
Gopal
Corinne Chaumont said
This is in regard of the posting https://oraclebizint.wordpress.com/2007/09/25/oracle-bi-ee-10133-and-mapviewer-step-by-step-integration-phase1/
I provided this link to an OBIEE Customer and they found it very helpful.
However, it is mentioned that there needs to be an oracle spatial database to have the integration between Oracle Map and OBIEE. In this scenario we would like to ask you whether this integration is possible in Disconnected mode as well. In disconnected mode we have an SQL Anywhere database. So how to manage this integration in disconnected mode?
ajay said
hi venkat ,
my scenario is i have i have created a presentation variable , CALYEAR (name of variable)
whatever i type in prompt box is stored as CALYEAR
i have 2 reports having 3 cloumns
first report
has YEAR ,ON PEAK SALES,OFFPEAK SALES
second report has
YEAR,ONPEAK WATTS,OFFPEAKWATTS,
i have 2 sections placed in same page
requirement is
if i type 2009 in prompt box (there is only one prompt box in this case)
the top table should show years less than 2009 (in this case it should show 2002,2003………2008)
the bottom table should show 2009 and above that year (in this case 2009,2010 ………)
how to do it i tried to filter by using presentation variable , it didnt work ,
PLEASE GUIDE ME asap
thanks
ajay
louis said
i have a question about external authentication, so if i used external table or ldap authentication,i can success login
but i don’t know how to grant authority,whether i must import user/group into RPD from ldap server or external database?
if not ,i want to know how to do it
Sanjeet said
Hi Venkat,
I have a problem in Dashboard. Can you tell me how to hide (ie. through Guided Navigation feature) a section which has only prompt in it and no requests.
As far as i know, we can hide a section which contains requests in it and not prompts. If there is way out then please do let me know. I would be really thankful to you.
Regards:
Sanjeet.
Anoop said
Hi Venkat,
I am facing a problem in a particular scenario when am using a column selector and filter on the column selector columns. I just used simple “and conditions” on the columns, but it does not work as i expect. When a select a particular column from the column selector the filter should apply only for that column. Is that possible? Kindly advice.
Regards,
Anoop
Sandeep said
Hi Venkat,
I need some modelling help in configuring a bridge table. We are on OBIEE 10.1.0.3.
I have a requirement to bring some MGVs(activity participants) over to analytics. The Emp
table contains the information on all employees involved for a given activity. Till now, we
were only bring in the one named “Primary Partcipant” though there were multiple persons
associated with the activity. Now we want to see all the persons on a given activity. I am
trying to use a bridge table for the purpose.
Existing rltnship : DIM1(W_EMPLOYEE_D) –> FACT1(W_ACTIVITY_F)
To Be : DIM1(W_EMPLOYEE_D) –> BRIDGE(WC_ACT_EMP_H) –> FACT1(W_ACTIVITY_F)
This bridge table needs to be setup to connect the Emp Dim to Activity Fact to get the
multiple employees associated with a given activity. Here is what i have done :
a> Added the table in physical layer.
b> Established a join with EMp and ACT fact tables.
c> Created a new table in BMM for the bridge table checked the option for “Bridge Table”.
d> Established the complex join with EMP dim and ACT fact.
Now my question is do I need to create a “New Dimension” for this bridge table just like for
the EMP table ? If so what would be the levels of the dim hierarchy? Ans what level should I
need to set the LTS of Fact table (W_ACTIVITY_F) for this new dimension. Do I need to do
anything else in BMM to get it working?
I know this is a common requirement, your suggestions are greatly appreciated.
thanks in advance,
Sandeep.
Nate said
Hi Venkat –
Great information on your blog! Thanks for starting it. I have a question which I could not find an answer to thus far, however.
I’m working with Siebel Analytics 7.8.5 administration tool. Using the Repository Import Wizard, I want to import a new subject area (presentation catalog) into production from test but it seems that some of the objects in my BMM and Physical layer are not being brought over. I believe that’s because they don’t directly have an object in the Presentation Catalog that they link to.
Is there a way in 7.8.5 to bring over the entire BMM and Physical layer folders? It seems one can only bring over Presentation folders and direct dependents.
Any help or pointers in the right direction are much appreciated. Thanks in advance!
Nate
Nate said
I’ll post a follow-up to my own question (#156). I tried the Import Wizard again (and again and again) and it worked better. It successfully imported the BMM and Physical Layers, with only a few presentation folders left out. I’m still not 100% satisfied that I know what’s going on, because I think I’ve seen this “issue” before. So if you have any thoughts still, I’d appreciate them.
Thanks.
Nir said
hello vekant 🙂
i made a comment on one of the articles. can you please in your free time try to answer it ? 🙂
thanks 🙂
I commented here :
Nir said
Hi Venkat
I made a comment on one of the articles. can you please in your free time try to answer it ? 🙂
thanks 🙂
I commented here:
https://oraclebizint.wordpress.com/2007/11/12/oracle-bi-ee-101332-working-with-clob-fields/
(sorry for the double post, you can delete the previous one)
mel said
I am interested in putting a US Maps on Dashboard. I already have drill in functionality based on the states. I see the US Maps img file on C:\OracleBI\web\app\res\s_oracle10\maps.
How to call the map image in Dashborad and have drill in functionality on the states.
Thanks
sumeet said
Hi All,
Need some clarification on Ibot. We have a ibot set up which uses
a a direct database physcial query. The problem we are facing is the
users that are getting the Ibot are getting the following error
View Display Error
Error generating view. You don’t currently have the necessary
privileges to execute Direct Database Requests.
Error Details
Error Codes: OAMP2OPY:Q4NU7XSN
File: ./project/webbedrock/handle.cpp, Line: 17
Invalid Handle Of ‘class NQWebView *’ Exception
Not sure why this is happeneing. Do we have to give them super user
access for this error to be solved , since its a physical query and
not a direct answer created report. Also the version we are using is
7.8. Any help will be appreciated.
Thanks
Sumeet
vishnu said
I have installed the OBIEE 10.3.3.1 in my machine. I found that the ‘Schedule and History links’ in BI Publisher is appearing but in ‘disabled’ mode. What is the way to make it enabled?
Thanks,
Vishnu
Ed said
I am fairly new to OBIEE and I am trying to create a new folder and report but I cannot seem to find the Create a New Folder link that is described in the Publisher tutorial on Oracle’s Technology Network site.
Srinivas Naidu said
Hi Venkat,
Please can u help me on this issue.
How to Change Drill down path dynamically as per user group.
Ex :hierarchy of a->b->c->d, and one user group
does not want b to be in the path, then how can i hide the b column from the
presentation layer using Object security or Data level security’s in the RPD. Please let me know any solutions for this.
Thanks
Srini
Sarita said
Hi Venkat,
I am trying to run Hyperion WebAnalysis(ver 9.0) through Vmware. It was working fine , till last run , wherin it gave an issue for java package.
The exception was thrown while connecting it to DB server.
The exact error message read “java.lang.NoClassDefFoundError”
Can you please let know solution to this error asap?
Sunil Epari said
Hi Venkat,
I am working on a solution dealing with dashboard Prompts:
Some of them as per requirements cannot be displayed on the dashboard, but they are evaluated based on other prompts values.
Requirement is:
Prompt1 Prompt2 Prompt3 Prompt4
Prompt2 is based on Prompt1
Prompt3 is based Prompt2 , but this prompt cannot be displayed
Prompt4 is based on Prompt3
Appreciate if you can direct or provide some guidance on this
Thanks
Sunil Epari
Sheela said
Hi Venkat,
We are using Active Directory authentication and have setup a table in the DB to get the groups. This works fine for Presentation services and Publisher.
We are now trying to see if this will work for the BI Server Admin tool login. So I have a user ‘x’ with group=”Administrators;XMLP_ADMIN”. When I try to login with user ‘x’, it gives me a login error. The server is able to get the group and assign it to “GROUP” variable but it somehow does not use it for authentication of the Admin tool itself.
Is there any other setting that needs to be done ? Please advise.
Thanks.
Amer said
Hi,
I am wondering, how BIEE is capable of providing slicing and dicing as it was from Discoverer PLus. Users are not able to open the report in Pivot Table layout and use the slice and dice capability of the tool. Users must be able to slice and dice from the report published on the dashboard. Do you have any idea about Oracle road may in desling with this issue.
Thanks.
kk said
Hi Venkatakrishnan J ,
could u plz post the installation steps with screenshots of all hyperion products.it will be gr8 help to everyone.thnx
kk
ravi said
Hi ,
plz show all answers to all users what ever the quiries they asked ,it’s so comfortable & new ones go-for good quiries.
regards
ravi
Kumar said
Can you please tell me the steps to send an e-mail using BI publisher? I am using Windows XP as my OS.
Kumar said
Can you please tell me the steps to send an e-mail using BI publisher? I am using Windows XP as my OS. My aim is to send a report as an e-mail without having any relation to delivers or iBots.
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
Vijay said
Hello venkat
I have couple of questions today.
1.Can you please tell me, how to integrate Apex with OBIEE, other than SSO approach. Can we achieve this in anyother way.
2.Can u kindly tell me how to create/enable a join type (outer/inner etc.,) in Physical layer. hmm in simple, how to create an outer join in our RPD?
Best Rgds,
Vijay
Pronab Das said
Hi Venkat,
Can we restrict the number of values a user can select in a Multiselect promt?
If you can help me in setting up this, it will be really helpful.
Thanks,
Pronab
Sudheer said
hey Venkat,
Unfortunately I replaced my nqsconfig file in windows to unix version..its not allowing me to login..how to get my old nqs config file from unix system back..pls let me know..
vijay said
hi , i have opening for oracle BI / analytics (for UK) if you are inrested drop your resume
gvijay@vtmanpower.net / vtmgvijay@gmail.com
044-64608582
regards,
vijay
Raju said
Hi Venkat,
How can i use two repository at a time?
In my configuration file (NQSConfig.INI) i have added two repository like
Star=SampleSales.rpd,DEFAULT;
Tms=TmsBI.rpd;
But when i logon to Dashboard or Answer I amd not able to see other repository and on the Dashboard it shows error for the reportes (for the Repository which is not default) like
View Display Error
Odbc driver returned an error (SQLExecDirectW).
Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 27005] Unresolved column: “CONVENIO_DATOS_V”.”PART_PASA”. (HY000)
SQL Issued: {call NQSGetQueryColumnInfo(‘SELECT CONVENIO_DATOS_V.EMPRESA, CONVENIO_DATOS_V.PART_PASA, CONVENIO_DATOS_V.PASAJEROS, CONVENIO_GPO_V.GPO_LIQ, CONVENIO_GPO_V.GPO_NOMBRE, TIMES_VIEW_CONV.ANO FROM TMSBI’)}
SQL Issued: SELECT CONVENIO_DATOS_V.EMPRESA, CONVENIO_DATOS_V.PART_PASA, CONVENIO_DATOS_V.PASAJEROS, CONVENIO_GPO_V.GPO_LIQ, CONVENIO_GPO_V.GPO_NOMBRE, TIMES_VIEW_CONV.ANO FROM TMSBI
How i can resolve this issue? is it posible to use two repository at a time?
Thanks
Raju
Kevin said
Venkatkrishnan,
I am new to Oracle BI dashboards.
I am looking to style the charts and graphs within the dashboard. I looks like the charting engine is PopCharts. Where would I find the CSS that the chart or graph (resulting flash object) references???
Thanks for any help,
Kevin
Anmol Agarwal said
Hi,
I am trying to install Hyperion DRM. But unable to configure(Web Server) it properly. Please let me know, if you any doc on Hyperion DRM.
Thanks
Anmol
Raju said
Hi Venkat,
I have a time dimension Which defines like Year,Year-Quater,Year-Month,Day and Year-Week, I want to achive that when i chose the particular Month (For Ex. May) Or Week (36) or Quater (1) I want to display all comparision from all the years in database (i.e. May-08,May-07,May-06 etc) or for Week (36-08,36-07,36-08) etc. How can i achive this?
Thanks
Raju
freddy said
Hi Venkat,
I have a requirement to implement a section collapse control on the dashboard globally.In the dashboard page, each section (box) can be collapsed. But I want to implement this feature globally. I mean if one section in a dashboard page is collapsed, that should be applied to all the sections in all the dashboard pages.
regards,
freddy
shiva molabanti said
I have a date that is stored in a varchar2 column in the physical table, like so: 20071225
Silly I know, but that’s what I’m dealing with.
Anyway, I want to create a logical column in the business model (using the Administration tool) and convert it to a date so that I can do date arithmetic with it, but TO_DATE doesn’t seem to be supported.
In Oracle SQL would do this :
SELECT SYSDATE – TO_DATE(’20050101′, ‘YYYYMMDD’) FROM DUAL
Is there any way to accomplish this same thing in the OBIEE? I see the CAST function, but there doesn’t seem to be any way to cast a string to a date?
Thanks in advance
Shiva.Molabanti
Raju said
I have pivot table having two measures dollar and unit.I want column selector which will be having option to select Dollar, unit or Both .
Dollar and unit is fine but can I have solution for Both.
How to display both dollar and unit using column selector.(or we can have alternative solution).
Please help me out.
Santhosh said
Hi Venkat,
Iam new to siebel analytics, what is the diffence between Siebel Analytics and OBIEE ?
Thanks
Santhosh
Chaitanya said
Venkat,
Please give an article for Backup and recovery process in Hyperion Planning.
Hemanth said
Venkat,
I am looking for jobs in Hyperion area.
I have some experience as Hyperion administrator.
Do you know any place where there are job openings?
I am searching every corner of internet for a job with a no luck.
I would really appreciate a lot if you can help me with this situation?
Thanks
Hemanth
Edward Eloian said
When installing OBIEE I get this error:
Oracle Business Intelligence is not supported on this Windows version. Oracle Business Intelligence is only supported on Windows XP x86, Windows 2003 x86, Windows 2003 AMD64, Windows 2003 EM64T, Windows Vista x86, Windows Vista AMD64, Windows Vista EM64T, and Windows 2000 x86.
Can you help?
Pavan said
Hi Venkat,
I would like to know if there are any log files generated for a users authenticated using an external table. Presently i could see logs files related only to Administrator. When i log in with a user i couldn’t open any log files from the dashboards. Is there any way to enable this.
Thank You
Anup said
Hi Venkat,
My name is Anup. I would need your help to know how we can improve performnace of Analytics reports without caching. We have made necessary aggregate table and also the physical queries of the reports run very fast, say 7 sec. But, the response time for the report is close to 1 min, which, combined, make the report very slow.
Can I contact you on your cell 🙂 or any number?
My number is 2012832585 and mail id is anup.hit@gmail.com
Kindly suggest me how to improve reports’ response time.
Thanks,
Anup
gurudattap said
Hi Venkat,
Have you written any article for loading value based hierarchy using Essbase Integration Services?
Regards,
Gurudatta
sridev said
hi i have doubt in obe scheduling, so anybody have a document means pls send it to bsridev@yaho.com
Sophia Hsu said
Hi Venkat,
We learned very much from your knowledgeable forum. In recent, we had a problem about the page axis of a grid in Hyperion Financial Reporting 9.3.1.
The dimension members (ex: apple, mango, and banana) have been assigned to a page axis. However, when we changed the members from the Pages drop-down list in HTML mode, the member of Pages and report data still stayed in the first member. For example, we changed the member from “apple” to “banana”, but the member and content was still the “apple”. The Pages function didn’t work in the Windows platform.
I would really appreciate your response. Thank you for sharing your knowledge and time.
Best regards,
Sophia Hsu
Raman said
Hi Venkat,
I need to install following products along with OBIEE Plus
Oracle® Business Intelligence Applications Fusion Edition
1.Oracle Partner Analytics Fusion Edition.
2.Oracle Telecom Sales Analytics Fusion Edition
3.Oracle Telecom Service Analytics Fusion Edition
4.Oracle Telecom Marketing Analytics Fusion Edition
5.Oracle Contact Center Telephony Analytics Fusion Edition
Informatica OEM PowerCenter ETL Server and PowerConnect Adapters
what i need to do,which version of OBIEE we will get this
Pls help me out this … ASAP
Thanks
Raman
Max said
Hi Venkat, I have the following problem: in my OBIEE install I can start the BI presentation services for all catalogues that I have except for one. The log indicates several times that “Query for Initialization Block ‘LOCALE’ has failed.[nQSError: 23006] The session variable, NQ_SESSION.WEBLANGUAGE, has no value definition.” Does anybody know what may have gone wrong?
Mark said
Our OBI EE Service stops (Windows box) and this following is posted to the server log:
Faulting application NQSServer.exe, version 10.1.3.3, faulting module nqsdbgatewayoci10g.dll, version 10.1.3.3, fault address 0x0000b5cf.
Himansu said
Hi Mark,
Did you get the resolution for this?
I am also getting the same issue.
Please let me know if u sorted it out.
Thanks in advance,
Himansu
Anitha Raghavan said
Hi Venkat,
Awesome blog…. Could you please include me in your blogroll..
Thanks,
Anitha
Anitha Raghavan said
please ignore my post above..thanks.
Raja said
This problem is not clear-
Dynamic Column Headers using Presentation Variables in O.B.I.E.E.
.Please clearify this this in right way.it is difficult.
Dinesh said
Hi Venkat,
Your blog contents are too good and its well maintained.Keep up this..
I’m new to BI.Currently i need to test a telecom project complete BI & its reports.kindly suggest me what could be the best way to do it.Is there any tools to test this..?
Kindly help me how to start with..
Thanks
Dinesh
ytbrad said
Hi Venkat,
Nice blog and keep on updating please.
I am a newbie to OBIEE. I am creating a report with OBIEE answer , and I can not figure it out how to display pageNumber/total pages (for ex. 1/16 ) on the report’s footer.Could you tell me how to resolve that problem?
Thanks & Regards
Brad
Nagesh said
Hi Venkat,
I am facing problem to connect relational DB from hyperion web analysis report. In web analysis we have Drill through feature.
But i am unable to connect any of the relational DB. I am getting error “Getting connection failed”. I am trying to connect Oracle DB. but i am able to connect using Oracle Mirant. but we do’t have Oracle Mirant in Drill through.
Please help me on this.
Nagesh
tom said
Hi Venkat,
Thanks a ton for all the useful information. I have a few questions for you. I would appreciate if you can help me out.
1. In Line charts, when we roll the mouse over the values(represented by for ex triangles), it just displays the Y-axis value. I tried several options to get the X-axis value too with Y. It does not work. Can you teel me how to show both the values on rollover?
2. After changing the properties in Col format options to Navigate instead of drill I am able to navigate to answer i want. However is there a way to control the navigation so that it displays the target in a new window everytime instead of navigating in the same window where we have the link?
Thanks,
tom
ash said
Hi venkat,
Well your efforts are commendable. Great work!
I have a small scenario which works well on dashboards but not for answers. I am trying to have dynamic titles based on the prompted column. The thing is the destination report is an answer and not a part of a dashboard. Can presentation variables be used for answers? In this case I navigate from dashboard to this answer.
Thanks much,
ash
Bharat said
Hi Venkat,
Please sugges How i will create the dynamic Header in report.i seeen your solution but it is difficult to understand
Sangeetha said
Hi venkat,
Please Suggest me how to clear the cache for Particular group or Few users
Thanks
Sangeetha
Subbu said
Hi Venkat,
I am very new to OBIEE. Actually i am siebel architect and my client wants to have siebel analytics. Client is asking for the architecture for OBIEE and no of servers required for setting up the OBIEE.Our OLTP system is running in HP UNIX (except web server). We have some UNIX box available for OBIEE.But we need to tell client that how many boxes we need and what are all the components can be installed together – this is for Development only
Please help us on this
Thanks
Subbu
Sum said
am trying to plot a graph that shows Persons name ( x-axis) against the revenue they generated ( Y Axis). The style i am using is vertical bar – 2d stacked ( for the quarters.. were i want Q1 to come on bottom of the vertical bar, q2 on top and so on and so forth). When i sort by Qtr, the bar for the person with highest revenue total is not arranged in descending order. The totals are arranged more or less in random fashion with a lower value bar coming 1st.. a higher value 2nd.. the lowest value coming in 3rd.
Is there a way i can plot this graph with having the person with highest total come in first and descending downards with each bar sorted ( 2d stacked) sorted by Qtrs.
Thanks
Fethiye Turgut said
I found this bug Bug 5926870 regarding Job manager not starting. I’ve also noticed, although jobmanager.ese won’t launch, you can launch it from startup.jar under JobManager folder under OracleBI
venkat said
Hi,
I have a problem, I have 2 servers 1 dev and 1 is test, in test there is no data. and I have to load data from excel to the cube in the test.I have to create a report and load the data into the cube can u please suggest me how to do it.
here excel is the data source and essbase is the target(not using essbase)
venkat said
can we create a report from a excelsheet instead of essbase using HFR 9.3 and also can we load data from Hyperion Financial Report to an essbase cube. if so please help me i am in hurry its very very urgent
Parn said
I am working on OBIEE. I have a customer requirement wherein I have to create a report using a view selector. The view selector is used to choose b/w two reports ( both pivot tables), having different multiple columns. Now the customer also wants a chart display based on each report, and it should vary with the view selector. The problem is that when we chart pivot table , it is automatically based on all the columns in the pivot table. whereas the requirement is , that chart should be based only on one specific column in pivot table. How should I achieve this?
Aparna said
Hi Iam new to OBIEE. I have a customer requirement wherein I have to create a report to calculate Year todate, Quarter to date , month to date, week to date, Daily sales, Year Ago , Quarter ago, Month ago, week ago, day ago sales, Prior year Quarter ,prior year month , prior year week, prior year day level sales. Like wise we need to calculate around 8 measures .We can calculate it using Ago and To date functions,But problem is we need to display these values dynamically which hits the performance badly. Als othe repository size keeps on growing. Which is difficult to manage.Can u plz suggest some way to avoid this
Bruno Samuel said
Hello,
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 (Active Directory – Windows 2003).
Instead of OID, I am using the Active Directory – Windows 2003 and my version’s OBIEE is 10.1.3.4.0. After creating the server windows 2003 with AD, I tested the connection with the AD server and was successful. Next I tried Import option, but got the Oracle BI Administration Tool error message: “There is nothing to import.”. I’m using the Administrator login and properly informing the base DN. Is this an AD configuration/privilege issue or OBIEE issue?
Please help me out.
Thanks,
Bruno Samuel
SP – Brazil
Rajesh said
Hi Venkat,
colud you please provide me the information regarding ‘GO URls’ in OBIEE and how can we pass the parameters in the OBIEE, so that we can navigate to the other page/ Dashboard.
Best Regards,
Rajesh.
karthikeyan said
Hi,
I need to use custom authentication, For this I have to change the nqsconfig.ini Authentication type.what is the type I should give…
Could you help me
karthikeyan said
Hi,
Any one did custom authenticators please provide some information.I have configured custom authenticators according to the rittmanmead document (http://www.rittmanmead.com/files/OBIEE_Access_Control.pdf) ,but custom authenticators is not working. what I have to do to achieve this custom authentication.
Can you help me to achieve this.
Thank you,
karthikeyan
pankaj garg said
hi venkat…
i am new person to oracle business intelligence and got stuck some where while working on bi answers and dashboards…actually we need to make a slider which is connected to a column…so that if we change a value the graph changes accordingly..can it be done???if yes please let me know the method how can we do that???
any help will appreciated
Thanks & regards
Pankaj Garg
Ravi Prakash said
Hi
Quick Over View
1. OS -> Centos 5.2 64Bit
2. Installation Purpose -> Test Hyperion Shared Services.
Installation Steps.
1. I configured Oracle Database by creating a User and with Permissions.
2. Installed Shared Services with default Apache Tomcat, and OpenLDAP.
3. I did the configuration steps to configure the Application and Database which went without any issues.
When I logged into the User Management Console with the default admin / password i am getting a error. User not found!
Screen Shots http://dba-onweb.blogspot.com/2008/11/issues-i-faced-during-hyperion.html
I checked all the basic things like
1. Shared Services running,
2. Apache
3. OpenLDAP is also running.
No other module has been Installed. Am I missing something here…
Thanks in Advance
Ravi Prakash
Asif Husain Khan said
Hi
I am working on Oracle Business Intelligence 10.1.3.3.2.I have made a section containing html code for radio buttons,on selecting the radio button it shows the corresponding saved request in the other section of same dashboard.
now the problem is that whole page is geting refreshed in selecting the radio button whereas the target to b achieved is only the section displaying the request should be refreshed.
can it b done?if yes then how.
Thanks
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
Ram Krishna said
Hi Venkat,
I apprieciate your patience and the blogs you write are very helpfull.
My question please can you explain some funtional architecture of Planning and
what are allocations
It will be very helpfull, i just want to understand the whole planning cycle work.
Regrads,
Ram Krishna
Siva said
Hi Venkat,
Your quick response is highly appreciated.
Below is the business scenario:
We are using OBI EE 10.1.3.4
1). Date Prompt (Start Date & End Date — Dashboard Prompt)
2). Product Category Prompt.
When we click on the single go button for the above two prompts
a). If the recordcount is less than or equal to 65000 then the report should be displayed in the dashboard. for displaying this we don’t any issues.
b). But for below.
If the data is more than 65000, then the report should not display instead of that “A message should be displayed” like Count is more than 65000, then the user should be able to download the data in to CSV file. As huge amount of data will be populated in the data mart per day (data feed from source system — Atleast 5 lakhs of data per day).
Let me know whether we need to write any Java script for the above scenario.
In the BMM layer we are planning to have only the Join conditions between the fact & dimension tables (Complex joins).
Also please let us know whether we will have any performance considerations if we populate the only the basic join conditions in the physical layer and in the BMM layer. All the calculated condition will be taken care off in the Data Mart.
Thanks in Advance
Siva
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
tom said
hi gurus,
we are trying to sort a column holding version numbers which is actually stored in database as varchar.
1.10.0.0.1
1.7.0.0.2
1.8.0.2.1
1.7.0.0.1
on enabling sorting on the dashboard we see that 1.10.0.0.1 comes before 1.7.0.0.1
rest all appears okay. is there a way i can sort the column that treats them link a version number. by the way I also set the sort order col prop on BL in rpd. it still does not work.
any comments would be appreciated
tom
Mike said
Just passing by.Btw, you website have great content!
_________________________________
Did you know that over 94% of personal computers have hidden corrupt dangerous files with over 150 hidden errors and bugs on them?
Divya said
Hi Venkat,
In OBIEE Answers, is it possible to apply filter and prompt on the same column? As far as I understand, the prompt has the highest priority and it overrides the filters. Is there a workaround at the Presentation Layer level?
Thanks..
Regards,
Divya
Divya said
@Tom
Hi,
Try doing this: The ‘space’ has a higher precedence than number. So,write a CASE statement in Answers for the Version No. field. In the CASE, for the one which needs to appear first put one space and write within a quote, for the second version number 2 spaces followed by Version no. withing quotes and so on.
Though just a workaround, worked for my instant requirement..
Regards,
Divya
Indra said
Hi Venkat,
Can you please send me the document for upgrading Siebel Analytics to OBIEE
jaedwein said
I don’t speak english, so i’ll go to the point.
What’s really new, easier or better with Hyperion (Web analysis, Workspace, Production Reporting, Scorecard, etc.) than with Oracle BIEE (Delivery, Answers, Intercative Dashboards, Admin Tool, Publisher, etc).
What can I do with Hyperion that I can’t with Oracle BIEE
Thanks in advance.
Saludos.
Javier.
Shyam said
Venkat,
My organization is implementing Hyperion Planning. We have about 8 dimensions and a 60G database (after agg). We are facing significant performance issues when running aggregation upto top level. This is not meeting business needs to report immediately (read few minutes) on Org level data. We have had Oracle resources look at all possible ways to tune, cutdown the database, do dynamic calc on few memebres etc with no satisfactory results. One option being approached is to do timely extraction from Planning BSO to an ASO (same outline). The thinking is that we can schedule that refresh every hour to meet business needs. DATAEXPORT of a particular scenario (Budget/Forecast) seems to be the bottleneck – takes about 40 minutes. Do you have any suggestions for:
1. DATAEXPORT to run faster
2. any other approaches to resolve the overall problem.
Your inputs are highly appreciated.
Thanks.
John Eicher said
Has anyone done What If analysis with OBIEE. Such that one would have a dynamic slide bar for currency conversion which, as you move it right or left, the Gross Revenue, Net Income, etc. would change. For example, if you start at a factor of 2.0 for Euros to Dollars and Gross Revenue is $2.000 million. If the currency exchange slider is moved to 2.5, then the Gross Revenue is $3.000 million if moved to a factor of 1.5 then Gross Revenue is $1.000 million. Thanks for the help.
R.B said
Hi Venkat,
Your blog is very informative and it really helps. I need your help in opening the repository by entering user id and password, as I don’t know the repository userid and password. How can I open the repository? Is there any way in reseting the password for the repository.
I tried using the NQSChangePassword.exe. It did not work.
Can you give me your suggestion to resolve this issue.
Thanks,
R.B
Prasanth said
hey venkat,
This blog information is very helpful. Lately,i am running into another problem with essbase
I have an Org dimension which is across 5 generations. So In my report i have the org generation starting at Gen3 which goes all the way down to Gen5. So i have a prompt with 3 gen columsn gen3, gen4,gen5.So when i select some members in the prompts from gen3 to gen5 itz giving NO results. how ever it shows results in the report if i use a normal drill down instead of the prompts. So even it has results for the selected prompt combination it gives no results. But in the drill down it shows results.
Prompt columns: gen3, gen4, gen5
Report columsn: gen3, dollars
filters in the report: gen3, gen4, gen5 are prompted
Is there any specific way to handle Essbase prompts in OBIEE. Please advice.
Thanks
Prasanth
swapna said
hello venkat,
Like most others, I am new to OBIEE.Can you tell me where I can get information about HR analytics?? Also can you tell me where I can get some knowledge of variables(static, dynamic, presentation etc)
Thanks,
Swapna
OBI fan said
Hi Venkat,
Could you please help me with below two queries
1) Is there a way to upload .xls file from within OBI dashobard/page?
2) How can i override the default collapsible functionality of section. I mean by default iwant my section to appear as collapsed instead of expanded.
Thanks in advance.
Dimitris said
hi Venkatakrishnan,your blog is really excellent.
I ‘ve been searching for a specific answer for while.
How to accomplish this scenario,set 2 periods of time using the calendar in the dashboard(set the presentations variables) and how to “pass” them in answers using the
//
FILTER(“….Fact”.”Sale_value” USING (“Calendar”.”Cal_date” BETWEEN date’@{ds1}’ AND date ‘@{de1}’))—for both periods
//
meaning have 2 filter column from the fact in the same report.
Calendar is really strange.It is really easy with drop-down or edit box…
tnks one more gor your articles…
Adeel Javed said
Venkat,
Browsed through your blog and honestly it is just amazing, we just found it a bit late. Well, we are facing a few issues with OBIEE, and here is a lengthy and detailed list of issues, so can you please take some time out and take a look:
1) When fetching data from multiple DB source: We have multiple source databases and multiple reports are built on those. All the reports are interlinked and all the reports use multiple databases. But source can only be determined at runtime. When a field value in a report is ‘A’ then data on next report should come from one database otherwise the data should come from other database. We are unable to figure out any way to accomplish this.
2) Variable passing from Dashboard to RPD physical layer: We are using complex select queries as table sources on physical layer, but we do not want these queries to fetch all the data first and then filter that data depending on the user selections from the dashboard. Can we pass a variable on selection of particular record by the user to that physical table query ? For example currently we are using queries like this (sample query)
SELECT ORDER_NO, ORDER_TYPE, ORDER_DATE FROM ORDERS
And we want to use query like this
SELECT ORDER_NO, ORDER_TYPE, ORDER_DATE FROM ORDERS WHERE ORDER_NO = VALUEOF(var)
But value of the ‘var’ is not predefined, rather the value should be the set whenever user clicks on a ORDER_NO link in a report.
3) Page level Export to excel (page contains multiple grids): On one dashboard page we have multiple data grids and we want to export all the grids into single excel file. Currently we know only of downloading single grid in excel file.
4) Multiple Target Report for single link: On one of our report we have a navigation column for which there are multiple target reports. But the actual target report that should be loaded is determined at runtime depending on the value of other column. For example if value of column A is ‘ABC then target report should be REPORT 1 and if value of A is ‘DEF’ then target report should be REPORT 2 otherwise the target report should be REPORT C. Can we do this? According to our knowledge we can specify multiple target reports but every time all the targets are shown in a context menu when we click on the link. We just need to determine single target report based on the value of column A and whenever the link is clicked, load that target report. We don’t want to show the context menu to the user with all the possible options.
Any help will be greatly appreciated. Thanks.
—
Regards
Adeel Javed
suman said
Hi,
Is there any way to store authentication details like UserID and PW outside RPD and migrate it to other environment.
Cheers
Razi said
Hi Venkat,
This blog is really excellent.
But we are having the scenario where:
In the Date Promt when the user select more than 1 day in the date between prompt, then the message should be display as “Select data only for 1 day”.
Can you please send the Java script for restricting the user to select only 1 day and then display the above message.
Also please let me know how to add more conditions to narrow it down to a single edit box in a particular page.
Thanks in Advance
Razi
saichandv said
hi Venkat,
First thank for you 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
Vikram said
Venkat,
First Thanks for Excellent Blog.
I am unable to get “More Products” link in OBIEE presentation services. I checked for the manage privellages.
Please Help Me.
Thanks in Advance.
Regards,
Vikram
Naveen said
Hi Venkat,
I am trying to do some customization on web forms in planning in order do some validations. some how i have figure out how to do customization . but not able to figure how to establish connection to call pl/sql package which is existing in other server and perform segement validations…
Please can you respond me as soon as possible…so that i can progress in my work…
blatny said
Excuse me! I’ve just begun my research about Oracle Technique and read some Oracle Documents. But I was so confused. There are many solutions for Business Intelligence. And Oracle has one. I wonder if there is any differences between Oracle BI solution and others about the common BI theory and implementation that made Oracle BI outstanding. I hope you would please to give me a hand for my very first step. Thanks in advance.
Ram said
Hi Venkat,
First I appreciate your blog it’s really very help full.
I have a requirement to create Oracle Answers report using width_bucket function, Please give me reply first is it possible or not If possible how we will implement this.
After all my research I came to know that it’s possible using Evaluate function please give me an idea how we will do this.
Your quick response is highly appreciated.
Thanks in Advance,
Ram
Artem said
Good day, Venkatakrishnan J.
Thank you for your leadership!
They helped me configure the LDAP authentication and run OC4J as a Win Service!
Many thanks again.
Artem.
Yusuf said
I have new with BI tools. Our current DB is not functional and we were tasked to play with TEXT files that we load onto our hard drive. I have load a few file and tested on the presentation layer. The following error appeared – can you assist.
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 46033] Datatype: 25 is not supported. (HY000)
SQL Issued: SELECT “HCREG.TXT”.Termyn saw_0 FROM “HEMIS P” ORDER BY saw_0
Srikanth said
Dear Venkatakrishnan,
Many thanks for sparing your time and assisting us through the blog.
My requirement is: Customer has a Pivot table and He requires dashboard prompt where in he provided paging no of pivot table.
Say if he provided 27 in the dashboard prompt. Then My page dropdown should contain values as :
1-27
28-54
55-81
. . .
. . .
. . .
I tried to impliment this similar to the solution provided by you @
https://oraclebizint.wordpress.com/2008/01/17/oracle-bi-101332-pagination-in-pivot-tables/
Buy in my case the Rou-Count Coloumn formula should use presentation variable value to perform the caliculations such as
@{P_NUM}+1 – 2*@{P_NUM} after the then clause in the case expression.
How should i go about this ?
To conclude My requirement is: I want to use simple arithmatics after the THEN cluase in the CASE EXPRESSION.
Many Thanks for your time
Regards
Srikanth
Vijai said
Hi,
can you please tellme the process for disconnected clinets on OBIEE?
Vijay said
Hi Venkat,
Can you please help me to come out from this peoblem.
How To Implement Breadcrumb in OBIEE / Siebel Analytics.
Regards
Vijay Ramagiri
James said
Need to know how to create a user and grant read permission to other dashboards …
Thanks
James.
Giuseppe said
Hi Venkat,
is it possible to create a single sign on between OBIEE and a legacy application written in asp.net on Membership.
I need the users registered on the Memebership are automatically logged when i open OBIEE page.
Is it possible ? How can i do it ?
Thanks in advance, Giuseppe.
manikanta said
hi venkata krishnan,
your blog was very useful to who are working in obiee. i am learning obiee, still i have one confustion about Guided Navigation? Can you explain with the example?
thanks,
mani
kumar said
Venkatakrishnan J,
Congratulations on joining RittmanMead….
http://www.rittmanmead.com/2009/06/22/breaking-news-venkat-joining-rittman-mead/
sirikiran said
How to set my dashboard default to other dashboard
shital said
We are running into a critical issue when we try to do iBot sharing. There are 60 some iBots that have to be made available to every individual user. So, the desire is to create those iBots once, then “share” it with other users, so they dont have to create it. But the requirement is that each user needs to be able to run the iBots on their own required schedule.
With this requirement in mind, I logged in as Administrator, created iBots, then went to ‘Manage Catalog’, Copied the iBots to Shared Folders. Now, when I log in as a user , for example ’85’, I see the shared iBot in the Shared Folders. Here is where I encounter a critical issue:
As user ’85’, when I modify the iBot under Shared Folders, say modify the schedule, and try to Save it, it gets saved under My Folders. Now, when I run the iBot which is under My Folders, what it does is that, it “reuses” the same Job Id in the s_nq_job table and updates it with userid ’85’ to the defined schedule. Now, user ‘112’ goes in, copies the iBot from the Shared folder to their own ‘My Folders’ and modifies the Schedule, I notice that it “updates” the same Job Id with user 112. That is NOT desirable. We need to be able to control the iBot schedule independently for every user. We also have a process that triggers an email for every inserted Job Id. We need all that functionality preserved and managed for every user. Hence, sharing a single job_id does not meet our requirements
This is very critical as we have over 60 iBots and several 100 users. It is not a good use of our time to be creating 60 x 100 = 6000 iBots. Can you please let us know how to achieve the functionality that I described above?
Ashwin Dube said
Hello Sir
Please advise on how to get the Demo maps running after setting up the Mapviewer successfully.
We have all the settings right except when clicking on any demo map selection it gives the error:
‘500 internal server error’! This worked once although we only got to see the blue image and no maps as such.
Thanks!
Ashwin Dube
Deep said
Hi ,
I am struggling with an OBI issue for last 2 days.
I have two confirmed dimension D1,D2 and two fact F1 and F2 tables.
D1 is joined with F1 ,F2 and D2 joined with F1,F2
We can’t go with the same structure in the BMM Layer. As OBI will throw error if we select field present from D1-F1-F2.
The alternative which I know to resolve the issue is to create alias of the Dimension and then join with the fact in the Physical layer.
If, D1 alias is D1A
And D2 alias is D2A
Then my physical joins will be something like D1-F1-D2 & D1A-F2-D2.
Now In the Business layer I will create a Logical central fact and will join all the facts and dimensions with it.
i.e with the central Fact D1,D2,F1,F2,D1A,D2A will be joined.
This Approach works but I don’t want to put the entire alias in the Presentation Layer. I only want to put the original Dimensions in the Presentation Layer not the alias. So I tried some different approach .
Approach2:
I have not created any alias in the Physical Layer.
In the Business layer I have joined the tables in the following manner.
Create a Central Fact just like my previous approach.
As I have not taken any alias this time so my Cental Fact table is joined with only,
D1,F1,D2,F2.
In the Central logical fact I have created two sources.
Source1
and
Source2
In the Source1 I have mapped the tables as D1-F1-F2
And in the Source 2 I have mapped the table as D2-F1-F2
After doing this I have found that I can able to pick data from all possible combinations.
1. D1-F1-F2
2. D2-F1-F2
3. D1-F1
4. D1-F2
5. D1-D2-F1-F2
6. F1-F2
But I am facing problem only for the condition 2, it is giving the data but when I am picking data from D2,F2,F1 then in the SQL joining condition D1 is also getting joined which should not be the ideal case.
If you know any solution then please share with me. It is very urgent.
Kind Regards,
Deep
Rajesh said
Hi,
Is it possible to schedule iBots from external application, say from a JSP page.
Many Thanks,
Rajesh
kumar said
Hi Venkat,
I need some info on OBIEE. if possible then please help me
I have one dimension “region” and two facts (Sales value & Gross margin%). Gross margin% is logical column which has been derived from two other facts column and it’s value is in range from Zero to 100.
Now, I want to generate below report. For each grossmargin% range of 5%, I want to sum the sales value for each region. Please assist
GM% Region_1 Region_2
<0 254 619
0-0.05 564 799
sakthi said
Hi,
we are using HFR as reporting tool whereas Essase and OBIEE serves back end.The essbase has higher level data and OBIEE has very granular data.we need HFR to use essbse and drill down to OBIEE from there..Can you please suggest me, how to attain this..
Thanks
Sakthi
Mustafa said
Hi,
i’ve installed Oracle BI Server 10.1.3.4.1 to my computer. But i can’t see any chart with values on dashboard. It draws only legent and axises but there is no any data on any chart. How can i solve this problem.
i’ve installed : biee_windows_x86_101341
thanks,
mustafa
SJ said
Hi Venkatakrishnan,
Can you provide some example to switch data source using same report on this URL
https://oraclebizint.wordpress.com/2009/02/27/oracle-bi-ee-10134-switching-between-production-and-development-data-sources-using-same-reports-and-dashboards/
Can you send me some more detail to sujojohn@hotmail.com
Thx
SJ
Rajesh said
Hi Venkat,
In LDAP authentication can we convert the case of users lets take i have all the users in upper case and want to convert into lower case. Can you please help
Thanks
Rajesh
Luntu said
Hi guys
I have got a problem here, i want to create a variable like this select COUNT(*) FROM EMPLOYEES, as column and use it on my case statement like case when count >0 then ‘bad’ else ‘good’ end
but it giving me erros
Alan said
Is there any information on Financial reporting annotations
Kumar said
we have a requirement to deliver Oracle BI reports generated by iBots to the specified SharePoint location. Can i have with detailed screens . or with detailed steps as there were so many blogs regarding this i can figure it out.
Sid said
When charting a column that has been converted into a HTML href column, the column value formula(‘‘ ||ED_WORK_EFF_TYPE.ORDER_TYPE|| ‘ ‘) is displayed on the chart instead of the data value. Can the data value be displayed on the chart?
Marcin said
Hi,
I’m testing complex dashboard with 3 sheets. One sheet is showing fact data. Two other sheets are used for configuration
(using WriteBack): one is used for setting budget-values, the other one is used for setting publish-date.
Setting Publish-Date also uses Write Back, that writes data to database, eventually data is read to BI variable (refresh interval 60 min)
and used in Answers. What bothers me is that when I set focus for few minutes on any of WriteBack sheets and change to fact data sheet I get following exception on sheet header (page still displays correct fact data)
“Invalid state identifier”
When I leave focus for several hours I get following error and web page without data
“Invalid request ID – kmsgClientSessionInvalidSearchID”
I looked through Presentation Server log File (\OracleBIData\web\log\sawlog1.log) and found the following error sequence
Everything starts from this warning
Cache file ‘D:\oradata\OracleBIData\tmp\sawvc\1040{RANDOM_FIL E_NAME}.sawxd’ didn’t match expected key.
Than follows error
“Invalid state identifier”
I recon that .sawxd file is being deleted by presentation service but I don’t understand why. There are lots of others .sawxd files, that are older and have not been deleted. Is it bug or known behaviour? Is it because WriteBack feature or frequently refreshed BI-variable?
Any session/cache(instanceconfig) settings have not been changed.
I appreciate any suggestions.
Phani said
This could be because of the session timeout of your request. Presentation server caches the content only for few minutes, after that request is expired from the presentation server, so objects you are referring are not longer valid.
harika said
Hi,
I want a small information for u people. Can I know free download links for OBIEE s/w…
Thanks in advance
Swetha said
Hi Venkat,
Thanks for such a wonderful blog.
We have a requirement about calendar picklist in answers. When we select a date, for example 1-Jan-2009 from the calendar picklist, it displays in the editbox as 1/1/2009. But the required format is 01/01/2009.
Can you please suggest on this.
PN said
Hi
I need to create one dummy dashboard date prompt as edit box and want to compare its value between two date i.e. start_Date and end_date columns. like 01/01/2000 between start_date and end_date
Please help me how to do it in OBIEE.
Thanks in advance
Williams said
Hello
Venkatakrishnan,
Please I need your help I want to make in the model one field that represents an html link that shows a popup whith an inlineframe, and I want to pass by url the source of that iframe, can you telme how can I do this , please is very important.
Williams said
Hello
Venkatakrishnan,
Its me again the thing is like this: I click in the link and have to show a popup and inside the popup its have to be an iframe with the source that I stablished, I know how to show this in a window but its shows the url, and for my aplication I most show this window within the url, I use this method
‘ Ver la ficha de esta persona” target=_blank onmouseover=”style.color=”Red”” onmouseout=”style.color=”MIDNIGHTBLUE”” onclick=”javascript:window.open(”’ || VALUEOF(“path”) || CAST (area.”Datos”.Id AS VARCHAR ( 10 )) || ”’,”Ampliación de la Ficha”,”width=1000,height=560,left=100,top=100,location=0,menubar=0,resizable=0,scrollbars=0,titlebar=0,toolbar=0”)” >Ver Ficha ‘
I create this as a field in the model but this show the url, I want to hide the url or show a popup whith an iframe
Hema said
Hello Venkat,
I have been through your blogs on Business Intelligence – Oracle site. I could not find a solution to the issue im facing with Hyperion Fusion Edition Workspace.
While logging onto Workspace im getting an error message like “You must supply a valid user name and password to log onto the system”. I m able to login to shared services, planning etc with this id and password as its an admin id.
In workspace.log file i could see the message as NO workspace components found in registry
Missing product context CALC
Checking HSS for context under product code CALC-9.5.0
Attempting workspace services connection for HSS
Failed to connect and retrieve info for CALC-9.5.0
Please help me with this issue. Its urgent
Siddharth Shah said
Hi venkat
I’ve been reading your posts regularly
Is there a way of displaying the name of a saved selection as a report name. I;ve tried every possbile thing but havent been successful
Is there any feature that allows us to display the name of a saved selection on the dashboard
Regards
Siddharth
rualonor said
I have been through your blogs on Business Intelligence – Oracle site. I could not find a solution to the issue im facing with XML huge files.
How can we charge and parse with OWB, ODI or any other tool that Oracle BI can provide us.
Thanks in advance.
Krishna said
Hi Vekat,
Thanks for such a great blog.
I am trying to call BI Publisher report from OBIEE – IBOT, this is my objective.
I am following below link from your blog.
https://oraclebizint.wordpress.com/2008/01/04/oracle-bi-publisher-101331-creating-applications-using-jdeveloper-11g-and-web-service-soap-apis/
I am getting error while I compile code in Jdevloper “package samplesoap.proxy does not exist” and also
Also I have changed
From
String userName = “Administrator”;
String passWord = “Administrator”;
To
String userID = “Administrator”;
String password = “Administrator”;
as I saw in WSDL document from url on local.
I am using OBIEE 10.1.3.4 and Jdeveloper 11g.
I am not sure if I am missing any JARs to be included or not anything…
Can you please help me resolve this and also guide me if I am on right way to acheive my objective..
Thanks in advance.
Thanks!
Josh said
When returning the HTML of an OBIEE report (from HtmlViewService) and writing it to a file, I am getting an Access Denied error when viewing the report in the browser. I think it has to do with the iframe that is embedded. Any suggestions on how to bypass this?
Jimmy said
Venkat,
I’m relatively new to Siebel Analytics and currently working on the upgrade from Siebel Analytics 7.8 to OBIEE 10.1.3.4 in development.
The upgrade went successfully but when viewing the rpd file it indicates global consistency check issues and throws errors and warnings in OBIEE.The very same rpd did not indicate any global consistency check issues while previously in Siebel Analytics.
The webcat migration was successful using the sawmigrate.exe utility.The installation is Windows based (Windows 2003 R2)
Any ideas as to why the conistency checks are showing up in OBIEE and not in Siebel Analytics ?
Thanks
Jimmy
Stefan said
Hello Venkat,
while searching for a solution for my current problem I found your site! Your site is really great and helpfull! Thank you at this point!
But,
I do have a issue with a report:
In the report you have to select a start-month and a end-month (Exp. 201001 to 201008).
The reports shows sales per month and a total. Now I want to show the sales for the periode 12-Month ago (200901 to 200908). I have created a logical colum with AGO(…, -12) and it works so far. But now, If I use in exp. employe and not month is the table I don’t get a sum-total. I can see 8 lines (for 200901 to 200908). How is it possible to aggregate the report to employe getting one sum for 201001-201008 and anoth for 200901-200908)??
I found out that viewing the report in pivot-mode, the agg. works but not in the table view.
I think I am doing s.th. worng…
The request is to have a variable month selection so the “customer” can define the month to show and calculate.
Many thanks for your answer!
Best regards from germany,
Stefan
Ps: I hope you understand by bad english!?! 😉