Already a member?
Sign in
Welcome! This is a website that everyone can build together. It's easy!
Location: Business Intelligence
Threads
???keywordTags???
???noTags???
Posting...
Note: You can enter up to [REMCHARS] additional characters.
Did you know you can edit the content of this page by clicking EasyEdit?
Did you know you can edit the content of this page by clicking EasyEdit?
| Started By | Thread Subject | Replies | Last Post | |||
|---|---|---|---|---|---|---|
| PrasadPZ | How to Dynamically aggregate user selections using Oracle Bi Beans | 0 | Sep 19 2008, 5:05 PM EDT by PrasadPZ | |||
|
Thread started: Sep 19 2008, 5:05 PM EDT
Watch
Does Bi Beans allow dynamic aggragation capability?
Below is the use case and I would like to find out how I can implement this using Bi Beans. We have a concept of analyzing the data by a "Group". A group is a set of 3 different dimensions. Say 'A','B' an d 'C'. There may be 30000 members in Dimension A, 100K in B and 20 in C but for a group X will have only 5 members from A, 10 from B and 4 from C. So when user search by Group - X, I would like to perform an aggregation only on 5 memebers from A, 10 from B and 4 from C and the Bi Beans crosstab should display aggrega tion for only this group, also when I drill down on A I will n eed to show only 5 member records and not 30000 members of A. Thanks for your suggestions in advance. . Can you please help with documentation or a tutorial how we can implement this solution? We tried to use supress NA rows option but it is impacting our application performance. |
||||||
| shyamvaran | Oracle BIWA SIG at OOW and BIWA Summit 2008 at Oracle HQ | 0 | Sep 16 2008, 11:43 AM EDT by shyamvaran | |||
|
Thread started: Sep 16 2008, 11:43 AM EDT
Watch
Learn about BIWA Summit, visit http://BIWASummit08.org
BIWA SIG Sessions at Oracle OpenWorld - Sep 21, 2008 Oracle BIWA SIG presents to you, 7 sessions at SIG Day - Sunday Sep 21 at Oracle Openworld Building Cubes and Analyzing Data with Oracle OLAP 11g (IOUG) S301022 8:30 AM, Dan Vlamis, Vlamis Software Solutions, Moscone West 2001 Be the Master of Your Domain: MDM Explained (IOUG) S301156, 10:00 AM, Ian Abranson,, Moscone West 2001 A Retail Business Intelligence Accelerator: Oracle Data Warehouse for Retail (IOUG) S301009, 1:00 PM, Shyam Varan Nath, Deloitte Consulting, BIWA SIG President, Moscone West 2001 Case Studies: Implementing Oracle Business Intelligence Suite Enterprise Edition in Three Environments S301190, 2:30 PM, Richard Solari, Teresa Wong, , Moscone West 2001 The State of Oracle Business Intelligence and Data Warehousing: BI Discussion Panel (IOUG) S301191, 4:00 PM, Joe Thomas , other Panelists, Moscone West 2001 Note Different Room Extending and Customizing the Oracle Business Intelligence Applications Data Warehouse S301063 8:30 AM, Mark Rittman, , Moscone West 2008 2009: A BI Odyssey S301163, 10:00 AM, Matt Vranikar, , Moscone West 2008
1
out of
1 found this valuable.
Do you find this valuable?
Do you?
Keyword tags:
biwa summit
oracle
|
||||||
| Nissa100 | Oracle Discoverer in Oracle 11 | 2 | Sep 11 2008, 3:05 PM EDT by Nissa100 | |||
|
Thread started: Sep 9 2008, 11:54 AM EDT
Watch
Hello,
Is Oracle Discoverer supported in Oracle 11g (Desktop and web)? Thanks
Show Last Reply
|
||||||
| ManiBachu | What are the steps to implement SCD2 in "rpd" in OBIEE ? | 0 | Jul 7 2008, 9:06 AM EDT by ManiBachu | |||
|
Thread started: Jul 7 2008, 9:06 AM EDT
Watch
* What are the steps to implement SCD2 in "rpd" in OBIEE ?
* Can you please share some links? * Can you please share some documents etc. |
||||||
| shyamvaran | BIWA Summit 2008 Call for Presentations is open | 0 | Jun 22 2008, 4:22 PM EDT by shyamvaran | |||
|
Thread started: Jun 22 2008, 4:22 PM EDT
Watch
Please submit your proposals for BIWA Summit, visit http://OracleBIWA.org under summit 2008 tab.
Email us at conference@oracleBIWA.org if you have any questions. Thanks Shyam
3
out of
5 found this valuable.
Do you find this valuable?
Do you?
Keyword tags:
analytics
BI Publisher
BI SIG
BI/DW
BIWA
Data Warehousing
Discoverer
ILM
OBIEE
OLAP
Oracle Data Mining
Siebel
|
||||||
| entwistle | The Fall DC2008 Call for Presentations is now open! | 0 | May 3 2008, 4:57 PM EDT by entwistle | |||
|
Thread started: May 3 2008, 4:57 PM EDT
Watch
Is your organization's business intelligence initiative linked with Oracle EBS, JDE, or PeopleSoft? The Oracle BI SIG is looking for presentations that provide our users with solid information about business intelligence as it relates to the Oracle technology stack.
Share your lessons learned, tips and techniques, or insights with Oracle users from all over the globe. Accepted presenters receive a complimentary registration to Fall DC2008 in recognition of their contribution to the Oracle BI community. Submit your abstract today! http://desktopconference.org/node/68 Join the BI SIG for a Cognos/OBIEE Webcast Quarterly Webcasts are free to registered BI SIG members.
2
out of
2 found this valuable.
Do you find this valuable?
Do you?
Keyword tags:
analytics
BI Publisher
BI SIG
BI/DW
BIWA
Data Warehousing
Discoverer
ILM
OBIEE
OLAP
Oracle Data Mining
Siebel
|
||||||
| td1947 | DISCOVERER: Quick Tips | 2 | Apr 25 2008, 7:03 AM EDT by td1947 | |||
|
Thread started: Jan 8 2008, 10:26 AM EST
Watch
DISCOVERER QUICK TIPS (covers 4.1.48, but may cover other levels) :
1) After cloning a DB and APPS code tree, the Discoverer part will not always work. Ensure that the pref.txt file has the correct IP address of the "new" server that runs the Discoverer code, and after the Discoverer services are started, create an "unregisterall.sh" script (like the "registerall.sh" script, but runs all 3 "unreg*" scripts one after the other). Run this, followed by a "registerall.sh", then "applypreferences.sh", and check the errors.txt file for zero length (no errors present). Run checkdiscoverer.sh, also to check all is OK. 2) switch off Query Prediction (QPPEnable – make his zero in the pref.txt), as it can help performance. 3) There are often several levels of heavy hash-joins going on in the PLAN that the CBO sets up for Discoverer report runs. If not catered for, these overflow into the TEMP TS, and get slowed down ten-fold by excessive disk I/O in there. I would recommend if your DB server has , say 32GB memory, set your pga_aggregate_target to a quarter of this, to 8GB, but also override the AUTO settings, by adding hash_area_size = 200M or even 400M, and the sort_area_size to 100M, or 200M in the init<DB>.ora if still getting disk sorts. 4) Check for orphaned ws processes on the Discoverer server (or on your main DB server if running all under on code-tree), and kill them regularly. These can occur after a “Memory Heap” error in the user stack. I have user session logging on, so I can detect this with a cron check of the user logs, then locate the process list, and kill them. This stops CPU hogging. I can provide the scripts I use for this if you need them. 5) When stopping Discoverer services each night (If you are not 24x7) for cleanup, ensue that all the following files are removed from /tmp, as they are sometimes missed: /tmp/orb*, /tmp/dc*, /tmp/opm*
2
out of
4 found this valuable.
Do you find this valuable?
Do you?
Keyword tags:
analytics
BI Publisher
BI SIG
BI/DW
BIWA
Data Warehousing
Discoverer
ILM
OBIEE
OLAP
Oracle Data Mining
Siebel
Show Last Reply
|
||||||
| wganesh | Different Business Processes | 1 | Mar 16 2008, 12:22 AM EDT by BalToro | |||
|
Thread started: Mar 13 2008, 2:39 PM EDT
Watch
Hello,
I am looking for documents, where I can see what are the business processes in general related to different industries like pharma, HR, Manufacturing and how they are addressed in RPD when Oracle publishes lets say Pharma Analytics or Marketing Analytics etc. Also where can I get RPD for these different flavour like Marketing Analytics etc? Ganesh
1
out of
2 found this valuable.
Do you find this valuable?
Do you?
Keyword tags:
analytics
BI Publisher
BI SIG
BI/DW
BIWA
Data Warehousing
Discoverer
ILM
OBIEE
OLAP
Oracle Data Mining
Siebel
Show Last Reply
|
||||||
| entwistle | Data Modelling Webinar | 0 | Feb 20 2008, 12:20 PM EST by entwistle | |||
|
Thread started: Feb 20 2008, 12:20 PM EST
Watch
Join the BI SIG for a web presentation and discussion on the importance of data modelling. http://bidwsig.org/node/8
Tuesday, March 11. Meeting details will be published no later than 5 March.
4
out of
6 found this valuable.
Do you find this valuable?
Do you?
Keyword tags:
analytics
BI Publisher
BI SIG
BI/DW
BIWA
Data Warehousing
Discoverer
ILM
OBIEE
OLAP
Oracle Data Mining
Siebel
|
||||||
| entwistle | Oracle BI SIG | 0 | Nov 30 2007, 3:28 PM EST by entwistle | |||
|
Thread started: Nov 30 2007, 3:28 PM EST
Watch
For more information about the Business Intelligence Special Interest Group, go to http://www.oraclebisig.org
13
out of
19 found this valuable.
Do you find this valuable?
Do you?
Keyword tags:
analytics
BI Publisher
BIWA
Discoverer
OBIEE
Siebel
|
||||||

