Sunil S. Ranka's Weblog

Superior BI is the antidote to Business Failure

Mapping the Maze, Online Bloggers to Real World Faces : Pythian Blogger Meetup at OOW10

Posted by sranka on September 27, 2010

Mapping the Maze, Online Bloggers  to Real World Faces : Pythian Blogger Meetup at OOW10

Bloggers Meet

It was that time of the year again — Oracle OpenWorld time — and Oracle bloggers meetup. For those of you who don’t know the history… The Bloggers Meetups during the Oracle Open World were started by Mark Rittman and continued by Eddie Awad, Keeping on with the tradition, Alex Gorbachev from Pythian re-hosted Bloggers meet this year at Jillians.

This was my 1st year of attending the event, When I got the invitation/information through Oracle ACE New Letter, I was very excited but towards the end I was not too sure about attending.  But eagerness to map name to faces made me take steps from Mascone North to Jillian. For people who couldn’t attend the event it was on Wed, 22-Sep-2010, 5:30pm at Lower Dining Room, Jillian’s Billiards @ Metreon, 101 Fourth Street, San Francisco, CA 94103.

I reached at venue just before 5:25PM and saw bunch of people waiting outside the party area at Jillians. I could see some of the know faces of fellow bloggers or Oracel Aces like Asif Momin, Alex Gorbachev, Paul Vallee etc. The doors were opened sharp at 5:30 and we all walked into the private party area. As expected everyone were handed out beer/wine coupon. Even though I didn’t know many faces but sense of connection was prevalent.  I could feel the connection with individuals.  Venue being close to Mascone helped the attendance. As promised in Alex Gorbachev’s blog it was chance to meet online buddies face-to-face in relaxed and informal atmosphere. The event started right on time 5:30PM.

The expectation was to have around 60 people attend, but more 60 people showed up and they almost ran out of beer/wine coupon. Living upto the expectation, Pythian opened up the Tab for everyone. Being strict vegetarian food has been a constant challenge but Pitta with Humus and Veg Spring Roll were quite delicious.

Upon arrival, Alex Gorbachev Welcomed every one, announced about food,  Beer, Wine and most importantly , directions to Rest Rooms . Also Alex Gorbachev asked for a volunteer to read his slide for his Thursday presentation. They had kept T-shirt art contest, on stylish Pythian designer t-shirts. HP X310 Data Vault, price was a motivation factor for getting it signed by fellow bloggers. Also For the best, most creative blog post about the meetup itself, Pythian announced an Apple TV. But, there were  a few small rules.

  1. the blog post must use as many names of people in attendance as possible.
  2. the blog post must be readable. It needs to make sense to someone who wasn’t there. It must be a story and not a list.
  3. the blog post must contain one other small tidbit of information about each individual that you’ll uncover during your “networking” as you weave your fascinating stories of the evening (like their blog name, a contact detail, favorite color, title, hobby, cat’s name, certification, what they were drinking, how much they had to drink…).
  4. the entry must be posted by midnight on Sunday the 26th of September. Please reference this post in your blog and it should be automatically picked up by the blog engine and posted in the comment as a track-back (if it doesn’t appear in the comments for some reason — please do post the link in your comment!

This helped new people to mingle with others. It was a different experience, it was short and nice, it gave me an opportunity to interact with my fellow bloggers. While doing this I solved the puzzle of mapping blogger name to real life faces.I started my T-shirt signing with

1.       Alex Gorbachev : The host. CTO at Pythian. You can find his work and details at http://www.pythian.com/about/management_team/alex_gorbachev/

2.       Paul Vallée : Executive Founder of Pythian. Met him first at collaborate 10 Vegas. Amazing dynamic personality with avid business sense.

3.       Minda : Works in CEG startup and friends with Paul Valle (CEO of Pythian)

4.       Asif Momen – I met Asif During Oracle ACE cruise dinner, he presently works in UAE and had flown from middle east for attending the conference. He blogs about DBA and for details you can visit him at http://momendba.blogspot.com/

5.       George Woods : He was visiting fro Pittsberg and he an Oracle DBA/SAP Basis, you could visit him at http://gvwoods.blogspot.com/

6.       Martin Nash : He was visiting from UK and when I asked him any interesting thing, he mentioned tha POPE came to visit UK.  You could visit him at http://oraganism.wordpress.com/

7.        Chet Justice :  The infamous oracleNerd, when asked about something special he mentioned his daughter Katezilla. You can visit him at www.oraclenerd.com

8.       Kamran Agayev : I had ran into Kamran during Oracle ACE dinner but didn’t get chance to talk with him, when asked about any thing exciting or different, hementioned that he doesn’t drink beer, same like me. You can visit him at http://kamranagayev.wordpress.com/

9.       Svetoslav Gyurov: He is from Bulgeria, you can call him Sve, and writes about Unix & Oracle stories. You can visit him http://sve.to/

10.   Fuad Arshad : A Database Architect. you can find his writting at http://www.fuadarshad.net

11.   Christian Bilien : An Ex-Blogger, after looking at Kevin Closson thinking of blogging again.

12.   Iftikhar Mirza : Loves to compare DB2 – Oracle – DB2.

13.   Tariq Farooq : The brainsurface guy. He is trying to revolutionalize IT collaboration. You can see his concept/work at http://www.brainsurface.com/

14.   Jarid Still : Even though his last name is Still, he loves Fast cars. You can visit him at http://www.jaredstill.com

15.   Riyaj Shamsudeen : Lives in Dallas, TX USA. Loves Crashes and Dumps. He can be visited at http://orainternals.wordpress.com/

16.   Micahel Majaka : The framework Guy

17.   Iggy Fernandez : The Iggy Pop, I met Iggy last year at Collaborate. Fun guy to talk with. An Accomplished database professional. He has written books on DB. You can get more details at http://iggyfernandez.wordpress.com/

18.   Philip Mwai – Guy from Kenya, and shares same last as current President.

19.   Leighton : Wites on Oracle DB.

20.   Eric Bezille : The box guy from Sun. He is Chief Technologist, Hardware Business Unit France, Oracle. You can visit him at http://blogs.sun.com/EricBezille/

21.   Jeremy Schneider : Writes about DB and thinks BI is sexy. You can visit him at http://www.ardentperf.com/

22.   Phil Jaenke : Guy from northeast ohio Unix, Storage, Virt, Cloud guy. Know by his nick name rootwyrm. You can follow him at twitter @ rootwyrm.

23.   Jacob Ramirez : He works at HP and blogs about RAC

24.   John Flack : Oracle Develop guy, at Oracle Events he asks people are you Musician. You can see some of his writing at http://it.toolbox.com/blogs/jjflash-oracle-journal

25.   Karl Arao : A DBA By heart and attende Oracle Closed World. You can visit him at http://karlarao.wordpress.com/

26.   Mohan Dutta : aka OCP_ADVISOR, I met Mohan in collaborate through a common friend. Avid blogger and veru active in Oracle User Groups. You can visit him at http://ebizocp.blogspot.com/

27.   Jacco H. Landlust : An Oracle ACE. One more Oracle Closed World Guys. During the conversation he mentioned “Its’ not ablout Caliber, its all about Projectile” A quote from Oracle Closed World. You can visit him at http://oraclemva.wordpress.com/

28.   Vanessa Simmons : The “Log Buffer” lady works for Pythian (The Host) and didn’t know about DB till Jan of this year

29.   Meg Bear : Of talentedApps fame. You can visit her at http://talentedapps.wordpress.com/

30.   Ben Prunsinki : A fellow ACE Director, I have met Ben on several occasion. He likes to Live on the Edge. He has written several books on DB topic.

31.   Kevin Closson : An OakTable Member and you can follow him at http://kevinclosson.wordpress.com/about/appearances/

32.   Mark Fielding : A Pythian, likes to work on cutting edge Oracle Technology. Currently working and blogging on Exadata. Visit him at www.pythian.com/news/author/fielding/

33.   Gwen Shapira : aka Chen. Lives in the same neighborhood as me, Cupertino, California. I liked her tag line her blog “I’m just a simple DBA on a complex production system”, you can visit her at http://prodlife.wordpress.com/about/

34.   Keith Millar : VP sales at Pythian, Paul Vallée introduce me to him. You can visit him at http://www.pythian.com/about/management_team/keith_millar/

35.   David Haimes :He blogs on Apps. You can visit him at http://davidhaimes.wordpress.com/

36.   Richard Foote : An ACE Director, An Australian, An OakTable member, Blogs about Indexes. He likes to listen to the music of David Bowie. You can visit him at http://richardfoote.wordpress.com/

37.   John Piwowar : Survived OracleNerd during OOW10. You can visit him at http://only4left.jpiwowar.com/

38.   Kim Njeru : Napster Guy.

39.   Bjoern Rost : Calls him self Brian in US. A StarBucks incident helped him change his him. You can visit him at http://blogs.portrix-systems.de/brost/jakekuramoto

After T-shirt Art contest the winners were judged and announced, Sunil S Ranka (Me), Asif Momin, and Fuad Arshad. It was close tie between me and Asif and finally Guy from KAS (Asif) won the HP contest. On the closing note “Pythian Thanked Every Blogger for attending the event”. Most importantlyPythian  announced that “THEY ARE HIRING”.

Posted in Uncategorized | Tagged: , , , , , , , , , , , , | Leave a Comment »

How does SAW cache work ?

Posted by sranka on September 25, 2010

Hi All

Came across an interesting problem recently. The issue was when reports were generating the same logical SQL, inspite of NO cache setting the results were cached. All the setting  CacheMinUserExpireMinutes, CacheMinExpireMinutes,  CacheMaxEntries in instanceConfig.xml were set to 0 (zero).

After debugging the issue it was nail down to an interesting fact that , if the same operation is done within an intervel of 30-38 sec, the results were getting refreshed. Following note from metalink made the finding more concrete.

Details on How does SAW Cache Work

The Analytics Engine uses the LRU algorithm (Least recently used) to clean out the cache entries. This works in conjunction with the parameter settings.

Anything that exists longer than CacheMaxExpireMinutes may and probably will be expired once the cleanup routine (which runs every minute or so) detects it. This is regardless of the CacheMinExpireMinutes setting.

When CacheMaxEntries is exceeded it will try to get rid of anything any entries with a time greater than CacheMinExpireMinutes (in LRU order though). In extreme cases it won’t even honour the CacheMinExpireMinutes setting.

The CacheMinUserExpireMinutes will generally keep a cache entry around for that # of minutes longer (even if CacheMinExpireMins or CacheMaxExpireMins have been exceeded). It’s user specific though in that other users will not use a cache entry that is being kept alive by another user if CacheMaxExpireMins has been exceeded.

Hope This Help

Sunil S Ranka

“Superior BI is the antidote to Business Failure”

Posted in OBIEE, sunil s ranka | Tagged: , , , | Leave a Comment »

The Myth : Usage Tracking Measures For Tracking The Performance Of Report Retrieval Time

Posted by sranka on June 22, 2010

Hi All,

Took some time off from the blog and other thing to take care of some family priorities, and now back to reality of OBIEE world.  I had been on a Ops call for more than 7 days, issue was very typical, during this debug I explored Usage Tracking in detail.  Following are the detail, this was taken from Doc ID 973090.1]

TOTAL_TIME_SEC is not a good measure of the time it takes from user submittal to retrieval completion because OBI has a zero footprint client, and Usage Tracking is only able to account for the time from when a request enters the OBI Presentation Server to the time that OBIPS releases the results to the client. The Time spent between UI and OBIPS is not accounted for in Usage Tracking.TOTAL_TIME_SEC is the time that the OBI server spent working on a query.This includes the clock time spent waiting for queries to complete. If multiple physical queries are running in parallel, the time reported is how long OBI is spent waiting for the database.This basically is the run time of the longest running query. The total time of all physical queries spawned by a single logical query is reported in CUM_DB_TIME_SEC. This is not part of TOTAL_TIME_SEC. Time spent waiting for resources is not included in TOTAL_TIME_SEC.Note also that START_TS and END_TS have nothing at all to do with TOTAL_TIME_SEC.

START_TS is the time when a user submits a query.This could be when they hit the Results tab in Answers or when they select a dashboard page.
END_TS is when the results are returned to the client.The difference between START_TS and END_TS also includes any time spent waiting for resources, such as waiting for a free connection. In the example where the TOTAL_TIME_SEC is 0 but the difference between START_TS and END_TS is 14 minutes, the 14 minutes could have been spent waiting.

If it is evident that a report is delayed, it is because it is waiting for a connection pool connection, a dbgateway thread or a server thread.
Connection pool connections are set in the .rpd. Dbgateway and server threads are set in nqsconfig.ini. Connection pooling is also handled by nqsserver, not sawserver. TOTAL_TIME_SEC is the time clocked once the request reaches nqsserver. Any wait for connections would happen before the request reached nqsserver. These would be reflected in the difference between START_TS and END_TS as mentioned above.

If you decide that server thread and dbgateway thread need to be adjusted, it is recommended that you get a site review from professional services.
Oracle recommends that unless you are experiencing a specific problem, that the settings be left at default.Problems involving sessions or thread ranges set too small would involve requests being queued. There are several settings that could come into play here including thread ranges and connections from connection pools.  Normally performance monitor counters would be set up to diagnose what setting is likely to be the bottleneck.As for the stack sizes, again you would need to be experiencing some sort of problem for Oracle to recommend a change.

Hope This Help

Sunil S Ranka

“Superior BI is the antidote to Business Failure”

Posted in OBIEE, sunil s ranka | Tagged: , , , , | 1 Comment »

How to Download Detail Data Directly in Excel through OBIEE

Posted by sranka on May 2, 2010

Hi All,

Recently I can across a requirement, where from the summary report client wanted to download the data directly to excel. Following was the use case :

Once Account Manager sees the opportunity total, he/she wants to see the detail data behind it. Eg. Line level details of install base, sales order number, Purchase Order details etc. Also they didn’t want too many clicks.

Following was the desired flow :

User sees the Opportunity Total –> User Clicks on the link and gets the detail data behind the Opportunity in an excel.

While working on this requirement challenges were different :

  • Browser hangs when we are trying to show too many rows (Over 3000 rows)
  • From UI perspective showing more than 25-35 rows, looses user attention.
  • Normal data rows include was more than 5000 rows

We looked at the various options of detail download :

  • WebService
  • Integrating with any external application which send data as an email
  • Any home grown tool

As the requirement was to get synchronous response, above tools/options were not viable.

After looking at the different venues, with my trust and belief in OBIEE architecture, I started finding my ways to find native solution. After spending few hours, to my surprise I was close to a solution which was native, scalable and easy to deployable .

Following Fig shows the detail :

Fig 1 – The base report which shows the total opportunity data

Fig 2 – This is the report which will be executed once download link is clicked on the base report.

Fig 3 – The popup report in the design mode.

This is the base report, clicking on Download Link, it will download data into an excel.

Base Report (Fig 1)

This is the popedup report

PopUp Report (Fig 2)

Report Design For PopUp Report

Report Design For PopUp Report (Fig 3)

Following piece of JavaScript was written in the PopUp report.

view source
print?
01<!-- Following Java Scrip will be written as part of "Download JavaScript (Narrative View) Section" -->
02<script>
03 
04<!-- Following code will remove all the dashboard page tabs,so that it looks like a popup window -->
05 
06var aElm=document.getElementsByTagName('TABLE');
07for(var i=0; i<aElm.length; i++) {
08 
09 if ((aElm[i].className.indexOf("TabTable") > -1)
10 || (aElm[i].className.indexOf("PortalBanner") > -1)
11 || (aElm[i].className.indexOf("PortalBottomTable") > -1)){
12 aElm[i].style.display = "none";
13 }
14 
15}// end of table loop
16<pre><!-- Following code will get SerachId and ViewId -->
17</pre>
18var aElm=document.getElementsByTagName('DIV');
19var searchId;
20var viewId;
21for(var i=0; i<aElm.length; i++) {
22 if (aElm[i].getAttribute("sid") != null){
23 searchId = aElm[i].getAttribute("sid");
24 }
25 if (aElm[i].getAttribute("vid") != null){
26 viewId = aElm[i].getAttribute("vid");
27 }// end of if
28}// end of table loop
29 
30// BaseURL is created "format=txt and Extension=.csv" is important
31var baseDownloadURL = 'saw.dll?Go&PortalPath=<Dashboard>&Page=<PageName>&Action=Download&Format=txt&Extension=.csv&ItemName=<ReportName>&';
32 
33baseDownloadURL = baseDownloadURL + 'SearchID='+searchId+'&ViewID='+viewId;
34 
35Download(baseDownloadURL);
36 
37</script>


Hope This Helps


Sunil S Ranka

"Superior BI is the antidote to Business Failure"

Posted in Uncategorized | Leave a Comment »

Collaborate-10 : Round Up

Posted by sranka on May 1, 2010

Hi All,

Its been pending for a week, but go caught-up with “something” (I will share “something” in next few weeks, due to contractual agreement can’t do it for now).

Attended Collaborate-10 at Las Vegas,Nevada,USA. It was good turn around compare to last year at Collaborate-09. Last year at Collaborate-09, we all speakers had a common joke, “only speakers are at the conference, no audience !!!!!!!”. This year it was different, we had lot many people, may be Vegas was the key differentiators. I personally didn’t step out of Luxor, but people said it was nice weather for 1st two days and later it became windy. Due to windy reason the beach party was moved inside the Ballroom. Some of the people from Europe missed out due to Iceland Volcano break out.

The content presented at Collaborate-10 was little different than Collaborate-09/OOW-09 but key differentiator was the Oracle’s commitment to 11g Release. They didn’t announce the dates but it was evident that Oracle has put in lot many hours and its will get into Beta pretty soon. I am hoping, if I can get my hands around it.

Some of the highlights of the Collaborate-10 were :

  • Oracle’s Commitment
  • BI/DW Tracks
  • ACE Dinner on Sunday
  • Monday Game Night with ACE
  • BIWASIG Reception
  • My Session on Wedneday
  • Meeting with fellow ACES
  • BIWA “Get Analytical Training Days”

Oracle’s Commitment

The best part of collaborate-10 was Oracle’s commitment towards 11g and attendees. Mr Robert Gersten (SVP,EPM Products) and Mr Gaurav Rewari (VP EPM Products) presented vision and road map for EPM Products. It was so easy to talk with Mr Robert and Mr Gaurav, with lots of patience they answered all the questions. They even answered questions like “When are you introducing version control, caching etc.” Robert was guest of honor during BIWASIG Reception, his commitment towards customer satisfaction was creditable. One thing is rest assure that EPM product is in very good hands.

BI/DW tracks:

During Collaborate-10, I was focusing more on BI/DW tracks, some of the sessions were really insight full. Oracle’s session about Hyperion by Dave Collins was worth attending. He explained the jargon word EPM. I will try to cover this as part of my next blog. Mike Donohue, covered BI Publishers’s hands on lab. An ETL Framework using Oracle Warehouse Builder by Iam Abramson was worth attending. BIWA SIG‘s discussion panel and BIWA SIG’s reception were highlight.

ACE Dinner on Sunday

Oracle hosted all ACE attending Collaborate-10, at Rick Moonen’s RM Seafood. It was first time ever I had such a great veg dinner at a sea food restaurant.It was my first ACE event, met with fellow ACEs Mark Rittman,Dan Vlamis, “Iggy”, OracleNer Ron Batra,Basheer Khan and Arun Nanda.

Game Night with Oracle ACEs
IOUG arranged a Game nite with all ACEs at IOUG booth in the exhibit hall. It was great opportunity to talk with people and sharing thoughts.

My Session

I presented on Wednesday, April 21, 2010 “How to enrich OBIEE UI using Custom JavaScripting”, it was well received session. Even though it was right after lunch, it was very well attended. Repsponse was positive and had many questions to be answered during and after session.

BIWA “Get Analytical Training Days”

BIWA “Get Analytical Training Days” was a BI conference within collaborate, Shyam,Dan, John, Mark did awesome job on executing the whole event.and for me the highlights of this stream were the bootcamp sessions (single streams that covered a technology from start to finish over the day, with no overlap).

On the closing note, I would like to thank all the OAUG,IOUG, and BIWA volunteer for their hard work and contribution for making this as a huge success.

Thanks,

Sunil S Ranka,
“Superior BI is the antidote to Business Failure”

Posted in Uncategorized | Leave a Comment »

My session at Collaborate 10 – Las Vegas, Nevada, USA

Posted by sranka on April 18, 2010

Dear All,

I am posting this page from Luxor, Las Vegas, Nevada, USA. I am here for Collaborate 10. I will be presenting session topic “How to enrich OBIEE UI using Custom JavaScripting”, Wednesday, April 21, 2010.

Below are the details :

Session ID: 245
TITLE: How to enrich OBIEE UI using Custom JavaScripting
DATE: Wednesday, April 21, 2010
TIME: 1:00:00 PM until 2:00:00 PM
ROOM: REEF F

Hoping to see some of you around.

Thanks

Sunil S Ranka

Posted in OBIEE | 1 Comment »

Oracle ACE Award

Posted by sranka on March 2, 2010

Dear All,

I have been confirmed with Prestigious Oracle ACE award. I want to take this moment to thank all friends, colleague, and family for all the support and feedback. More than me, you all deserve this award.

About Oracle ACE Program : Click Here .

My Profile in Oracle ACE Directory

Please continue your support.

–
Thanks,

Sunil S Ranka
“Superior BI is the antidote to Business Failure”

Posted in ... | 5 Comments »

BIWA Wednesday TechCast Series – “Need For OBIEE’s Web 2.0 Journey “

Posted by sranka on February 8, 2010

Hi All

I will be presenting in — BIWA Wednesday TechCast Series — on Wednesday, February 10, 12 noon Eastern.

Topic : Need for OBIEE’s Web 2.0 Journey

Date : Wednesday, February 10, 2010

Details : http://oraclebiwa.org/

Place : Over Phone

Audio Dial-In: 866 682 4770  Audio Meeting ID:  1683901  Audio Meeting Passcode:  334451
List of  International Toll-Free Numbers:    http://www.intercall.com/oracle/access_numbers.htm

Web Conference:      Please browse to https://stconference.oracle.com and enter 6009368 in the Conference ID field and your name in the Your Name field.

Compatibility Check:  If you have not used Oracle’s web conference system before, please ensure your system    compatibility by going to https://stconference.oracle.com/imtapp/app/nuf_sys.uix.

Hope this helps

Sunil S Ranka
“Superior BI is the antidote to Business Failure”

Posted in OBIEE | Tagged: , , , , , | Leave a Comment »

My NorCal-2010 OAUG Presentation

Posted by sranka on January 15, 2010

Hi All,

Finally done with my slide for NorCal-2010. I will be presenting on Jan 19th, 2010 at Santa Clara convention center, Santa Clara, CA between 2:30 – 3:30PM (PST) in Mission City Room 1. If you guys are around please attend.

Title: ‘How to enrich OBIEE UI using Custom JavaScripting’
The abstract for this presentation:

‘JavaScript is primarily used in the form of client-side JavaScript for the development of dynamic websites. OBIEE uses prepackaged JavaScript for rendering contents on the browser. During this presentation we will talk about how using simple javascript call in conjunction with OBIEE prepackaged JavaScript API, how we can get handle to the report XML structure. Using custom JavaScript parser how XML structure can be read and utilized. Some of the custom JavaScript usages are: What if analysis, Integration with Operational system, how to provide custom download feature on reports, custom messaging, replacing multiple go button with single go button etc.’

Hope to see some of you.

Hope this helps

Sunil S Ranka
“Superior BI is the antidote to Business Failure”

Posted in ... | Leave a Comment »

OBIEE Answers (Ad-Hoc Reporting) Best Practices

Posted by sranka on January 7, 2010

Wishing you all a very Happy New Year 2010!!!! . I was waiting for some exciting topic to start with my 2010 blogging. Before holidays I had a deliverable of documenting best practices for Answers implementation (Ad-hoc reporting). Answers, a topic close to me. Since requirements keep changing as new ideas starts flowing in from the end users, OBIEE ANSWERS comes is key for success of any operational and tactical Business Intelligence project.

OBIEE ANSWERS Ad hoc reporting empowers power business users to create their own reports and perform in-depth analysis of real-time information right in their Web browsers. Sometimes, business users need reporting capabilities for one-time questions or want to build specialty reports without having to request that the IT department create a new report for them. Ad hoc reporting allows end users to get answers on demand and customize their queries so that their reports contain only the information needed.

Best Practices

  • Getting critical information from the right people at the right time, detail Business Requirements analysis is critical to the success of Ad hoc reporting.
  • Ad Hoc reporting user will have access to most granular level of data, hence data and Object level security is high priority item.
  • A single security model should be used for both canned and ad hoc reporting
  • Empower and educate key end users on content and OBIEE to develop their own reports in a managed Ad hoc report environment.
  • Don’t release all the detail measures in the first phase, have phased approach for releases.
  • A separate OBIEE sas and web servers are preferred for better performance and scalability.
  • Join Fact and Dimension using numeric key for better performance.
  • Don’t overload the user with too many Fact and Dimension, keep the Dimensional modeling simple with few facts and Dimension for ease of use.
  • Training for comprehensive understanding of the subject area that will be queried should be given to End Users.
  • Educate users on restricting number of rows displayed on browser to less than 25.For detail data use download to data option.
  • Measures and Dimension should be logically grouped for better user experience.
  • Performance and detail unitesting of each and every measure with all the dimensions.
  • Create and save variables and filters for returning the most relevant results.
  • Basic and advanced statistical calculations needs to be done at the repository level
  • Answers access should be restricted only to power users.
  • Keep track of Answers subject area using Usage Tracking for improvements and enhancements.
  • Keep an eye on the db so that users don’t use most of the resources bu using some naked queries.
  • In past we have seen that when users are trying to download huge data SAS server crashes, so please make sure you have enough storage space defined for — DATA_STORAGE_PATHS,SORT_MEMORY_SIZE,SORT_BUFFER_INCREMENT_SIZE,VIRTUAL_TABLE_PAGE_SIZE — variable in NQSConfig.INI confige

Hope This Helps

–
Thanks,

Sunil S Ranka
Blog :: http://sranka.wordpress.com
“Superior BI is the antidote to Business Failure”

Posted in ..., OBIEE | Tagged: , , , , , | 1 Comment »

« Previous Entries