Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Oracle BI Suite Enterprise Edition | Forum profile

Forum profile page for Oracle BI Suite Enterprise Edition on http://www.oracle.com. This report page is the aggregated overview from a single forum: Oracle BI Suite Enterprise Edition , located on the Message Board at http://www.oracle.com. This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period. Additional forum profile information for "Oracle BI Suite Enterprise Edition " on the Message Board at http://www.oracle.com is also shown in the following ways:

1) Latest Active Threads
2) Hot Threads for Last Week

Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.

Site: www.oracle.com - Oracle BI Suite Enterprise Edition
(site profile, domain info oracle.com)
Title: Oracle BI Suite Enterprise Edition
Url: http://forums.oracle.com/forums/forum.jspa?foru...
Users activity: 23 posts per thread
Forum activity: 328 active threads during last week
 

Posting activity on Oracle BI Suite Enterprise Edition :

  Week Month 3 Months
Threads: 328 1,076 2,741
Post: 749 2,524 6,356
 

Oracle BI Suite Enterprise Edition Posting activity graph:

Posts by:  day  week  month 

Top authors during last week:

Name
Posts
Ed Higgins, Alt...
55
user's latest post:
Changing the page tab structure...
Published (2009-11-26 03:59:00)
The xml files are all stored in the web catalog and can be viewed and edited using the catalog manager, I don't think that is necessarilty what you are after though, most of the appearance of dashboard objects controlled by css classes. For instance, the tab itself that appear at the top of each page is made up of small images and css classes that control the text appearance e.g making the active tab darker and the text bold. If you wish...
adb
45
user's latest post:
Filter Measure using Variable
Published (2009-11-27 06:57:00)
I guess it's not a simple report...problem is probably situated in other object of your report.... Kr, A
Prash11
30
user's latest post:
Pivot table on Dashboard
Published (2009-11-25 07:21:00)
Go to the report and display results. By default you will see a table view embedded in the compound lay out. Now delete the view Now in the top pane click on "add view" and select the pivot table and save the report. You will see the pivot table in the dashboard. Always use the preview button present on the right side top pane of the Answers and that will give you the view which represents what you see in the dashboard. Another easy...
Raghu Murari
26
user's latest post:
Work of PortalNav function,...
Published (2009-11-26 02:30:00)
JavaScript:PortalNav('event',' _portal/test ','C1','V1', '"@"');\">"@" It should be /shared/.../_portal/test (complete path) Regards, Raghu
KART
25
user's latest post:
Filter Measure using Variable
Published (2009-11-27 04:35:00)
FILTER(Measure.Measure1 USING "Year"."Years" = '@{StVar CurrYear}' I'm not sure about it. Please give it a try
Stijn Gabriels
24
user's latest post:
Changing the page tab structure...
Published (2009-11-27 08:04:00)
I doubt if there is a XML file in which you can edit to change this. Not everything in the UI is editable..
ed.co.
20
user's latest post:
NQSconfig 46029
Published (2009-11-26 08:20:00)
43093 is before
gerardnico
19
user's latest post:
Fact vertical capabilities -...
Published (2009-11-27 10:44:00)
The left outer join is made on the dimension values So, I don't really see how OBIEE can make an outer join if one dimension have no relationship with one fact table ...
user608279
15
user's latest post:
Change format to Calendar Prompt
Published (2009-11-26 00:23:00)
Hi, i applied this change http://108obiee.blogspot.com/2009/05/how-to-add-leading-zeros-after.html . but no changes! I restart presentation service and bi server.... Any idea?
Christian Berg
15
user's latest post:
Star schema in Physical Layer
Published (2009-11-27 09:30:00)
but I don't really know what happens when you do that and what the consequences are. I think I have read once that your joins will be "fixed" and the BI Server doesn't have the ability to choose between joins. Yeah that's exactly what happens Stijn. You lose the flexibility on the one side and need to actually think about how to construct your joins precisely in the BMM aigain (rather than just having them in the...
 

Latest active threads on Oracle BI Suite Enterprise Edition ::

www.oracle.com
Started 1 day, 2 hours ago (2009-11-28 15:06:00)  by David_T
There are several things that come to mind, but let's start with this one. You say in report 2 you filter on the column clicking the filter button, then Add>Variable>Presentation Variable. OK, if you use this method, you only type level1_val in the field, not @{level1_val}. Did you do that? You only use the "at sign" @, when you "convert the filter to SQL." ...
Thread:  Show this thread (2 posts)   Thread info: Presentation variable in dashboard prompt Size: 774 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Presentation variable in dashboard prompt :: Oracle BI Suite Enterprise Edition
 :: www.oracle.com"
www.oracle.com
Started 2 days, 14 hours ago (2009-11-27 03:05:00)  by KART
use case statement like case when sales is null then 0 else end.
Thread:  Show this thread (8 posts)   Thread info: Pivot table show data for all dimension values Size: 303 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Pivot table show data for all dimension values :: Oracle BI Suite Enterprise Edition
 :: www.oracle.com"
www.oracle.com
Started 1 day, 12 hours ago (2009-11-28 05:08:00)  by user10395126
In OBI there are three layers - Physical, Business Model and Mapping (BMM) and Presentation. As the name specifies the Physical layer mainly contain physical aspect of the application like which connection to use, which schema (also catalog in case of SQL server) to connect and also which table to use. This layer confirms the PK_FK joins for the related ...
Thread:  Show this thread (3 posts)   Thread info: Whar are logical table, Physical table Logical data Source Size: 1,624 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: What are logical table, Physical table Logical data Source :: Oracle BI Suite Enterprise Edition
 :: www.oracle.com"
www.oracle.com
Started 2 days, 15 hours ago (2009-11-27 01:14:00)  by gerardnico
Your problem comes from that you have LEFT OUTER JOIN and not a FULL OUTER JOIN. Really strange behaviour. Do you have the two fact table F1 and F2 as logical source table in ONE logical fact table in the Business Model Layer ?
Thread:  Show this thread (6 posts)   Thread info: Fact vertical capabilities - Full outer Join - How to? Size: 481 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Fact vertical capabilities - Full outer Join - How to? :: Oracle BI Suite Enterprise Edition
 :: www.oracle.com"
www.oracle.com
Started 2 days, 4 hours ago (2009-11-27 13:04:00)  by sheri.bracewell...
Yes, you 1. find the analytics.ear file under the $APP_HOME/j2ee/home/... 2. download the ear file to your PC (if BIEE platform is Unix) 3. Start the enterprise manager for your app server ( http://app:port/em 4. deploy the analytics.ear file using this interface. Instructions are in the app server documentation. Be sure you name it analyticsSOAP and ...
Thread:  Show this thread (5 posts)   Thread info: Sample of Web.xml file with analyticsSOAP Size: 954 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Sample of Web.xml file with analyticsSOAP :: Oracle BI Suite Enterprise Edition
 :: www.oracle.com"
www.oracle.com
Started 2 days ago (2009-11-27 16:31:00)  by qqq
You would grant the user the group Presentation Server Administrators. However, don't do that directly. Make users a part of the group which is assigned "Presentation Server Administrators". If you are integrating with EBS or Siebel, all you would have to do is assign the user to that responsibility in Siebel.
Thread:  Show this thread (3 posts)   Thread info: Admin user for analytics with SSO on Size: 550 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Admin user for analytics with SSO on :: Oracle BI Suite Enterprise Edition
 :: www.oracle.com"
www.oracle.com
Started 3 months, 1 week ago (2009-08-23 12:50:00)  by Merlin128
correction to your jar command: "jar -cf analytics.war -C app" is suppose to have the '.' after it as far as I can tell.. and you need a different name than the file that already exists. so the command would be: "jar -cf analytics_new.war -C app ." this will create the new file.. however It still uses the default 9710 no matter what I put in the web.xml......
Thread:  Show this thread (6 posts)   Thread info: can OBIEE run two rpd files at the same time? Size: 1,097 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: can OBIEE run two rpd files at the same time? :: Oracle BI Suite Enterprise Edition
 :: www.oracle.com"
www.oracle.com
Started 2 days, 7 hours ago (2009-11-27 09:14:00)  by gerardnico
You have to add the parameters in your statement with the help of a bind such as : select emp.name from emp where emp.name = :YourParameters Check here for a step by step : http://www.oracle.com/technology/obe/obe_bi/bipub/ intro/gettingstarted.htm#t4 And yes, you can have two data set in your publisher report. Cheers Nico...
Thread:  Show this thread (6 posts)   Thread info: Different Data Model Size: 823 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Different Data Model :: Oracle BI Suite Enterprise Edition
 :: www.oracle.com"
www.oracle.com
Started 5 days, 16 hours ago (2009-11-24 00:57:00)  by Raghu Murari
'GO' is not stored in image format. Instead it is a text. you could modify the text. http://bischool.wordpress.com/2009/07/18/change-go -button-name-of-obiee-dashboard-prompt/
Thread:  Show this thread (13 posts)   Thread info: How to change "Go" button? Size: 583 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: How to change "Go" button? :: Oracle BI Suite Enterprise Edition
 :: www.oracle.com"
www.oracle.com
Started 1 day, 23 hours ago (2009-11-27 17:34:00)  by mma1709
create same bins in rpd and use the new column in both prompt and the report.
Thread:  Show this thread (2 posts)   Thread info: Dashboard prompts against columns with Bins Size: 316 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Dashboard prompts against columns with Bins :: Oracle BI Suite Enterprise Edition
 :: www.oracle.com"
 

Hot threads for last week on Oracle BI Suite Enterprise Edition ::

Oracle BI Suite Enterprise Edition
Started 6 days, 14 hours ago (2009-11-23 02:24:00)  by John Minkjan
The "problem" is the MAX part here, a VALUEOF(NQ_SESSION..) can only have one value You could switch of the warnings for obsolete method in you consistency checker. regards John http://obiee101.blogspot.com/
Thread:  Show this thread (21 post)   Thread info: Importance of Global Consistency check Size: 564 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Importance of Global Consistency check :: Oracle BI Suite Enterprise Edition
 :: www.oracle.com"
Oracle BI Suite Enterprise Edition
Started 2 days, 12 hours ago (2009-11-27 04:10:00)  by adb
Hi, and what's the question exactly as this should be possible. Kr, A
Thread:  Show this thread (14 posts)   Thread info: Filter Measure using Variable Size: 345 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Filter Measure using Variable :: Oracle BI Suite Enterprise Edition
 :: www.oracle.com"
Oracle BI Suite Enterprise Edition
Started 5 days, 16 hours ago (2009-11-24 00:57:00)  by Raghu Murari
'GO' is not stored in image format. Instead it is a text. you could modify the text. http://bischool.wordpress.com/2009/07/18/change-go -button-name-of-obiee-dashboard-prompt/
Thread:  Show this thread (13 posts)   Thread info: How to change "Go" button? Size: 583 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: How to change "Go" button? :: Oracle BI Suite Enterprise Edition
 :: www.oracle.com"
Oracle BI Suite Enterprise Edition
Started 3 days, 14 hours ago (2009-11-26 02:23:00)  by Ed Higgins, Alt...
Kart, Could you explain a little more please, what's wrong with the current page tabs, are you embedding a whole dashboard or individual pages? Regards Ed
Thread:  Show this thread (10 posts)   Thread info: Changing the page tab structure in the Dashboard Size: 422 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Changing the page tab structure in the Dashboard :: Oracle BI Suite Enterprise Edition
 :: www.oracle.com"
Oracle BI Suite Enterprise Edition
Started 3 days, 11 hours ago (2009-11-26 05:30:00)  by mod100
Hi, Unless you have an extremely funky physical data model then you are defining stars at the physical layer, i.e. W_ORG_D, W_REVN_F, W_OPTY_D, W_POSITION_D (as an example from the apps) are just a small portion of one of the phsyical stars. Just check out the data model reference for the applications, they show all the physical stars. The BMM layer is...
Thread:  Show this thread (10 posts)   Thread info: Star schema in Physical Layer Size: 771 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Star schema in Physical Layer :: Oracle BI Suite Enterprise Edition
 :: www.oracle.com"
Oracle BI Suite Enterprise Edition
Started 4 days, 15 hours ago (2009-11-25 01:55:00)  by adb
Hej Joos, just remove your joins once...and recreate them. To see what's the sql executed, check your NQQuery.log file...or the log in manage sessions. Kr, A
Thread:  Show this thread (9 posts)   Thread info: Outer Join not working Size: 448 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Outer Join not working :: Oracle BI Suite Enterprise Edition
 :: www.oracle.com"
Oracle BI Suite Enterprise Edition
Started 6 days, 3 hours ago (2009-11-23 13:23:00)  by Ed Higgins, Alt...
Fabio, It's worth reading the presentation services administration guide to get to grips with these, it's one of the better pieces of documentation. To reference a presentation variable use @{variablename}, if you are writing this into an expression you can set a default value using @{variablename}{defaultvalue} regards Ed
Thread:  Show this thread (9 posts)   Thread info: Session and Presentation variables. Any examples? Size: 607 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Session and Presentation variables. Any examples? :: Oracle BI Suite Enterprise Edition
 :: www.oracle.com"
Oracle BI Suite Enterprise Edition
Started 5 days, 17 hours ago (2009-11-23 23:51:00)  by BrightShan
kart wrote: Hi all, I want to remove oracle logo from the dashboard page.. i know it might be some where in the xml file.. i dont want to delete the jpeg file but just want to disable it in the xml file level... thanks in advance kart well, change the file name in the directory which contain images of Oracle Dashboard into other name like copy...
Thread:  Show this thread (8 posts)   Thread info: How to remove oracle Logo? Size: 897 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: How to remove oracle Logo? :: Oracle BI Suite Enterprise Edition
 :: www.oracle.com"
Oracle BI Suite Enterprise Edition
Started 2 days, 14 hours ago (2009-11-27 03:05:00)  by KART
use case statement like case when sales is null then 0 else end.
Thread:  Show this thread (8 posts)   Thread info: Pivot table show data for all dimension values Size: 303 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Pivot table show data for all dimension values :: Oracle BI Suite Enterprise Edition
 :: www.oracle.com"
Oracle BI Suite Enterprise Edition
Started 5 days, 12 hours ago (2009-11-24 04:33:00)  by ed.co.
When I put filter on colum wich I want to sum , it filters polices wich mesure is <0. But I don't want that, I want to remove sum <0.
Thread:  Show this thread (7 posts)   Thread info: implement having sum(...) >0 Size: 378 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: implement having sum(...) >0 :: Oracle BI Suite Enterprise Edition
 :: www.oracle.com"

This page was found by:   kishore guggilla  oracle.apps.xdo.security.ValidateException  nQSError: 15018