Brendan Tierney writes that he had a query about one of the functions BUCKET_WIDTH. The question was wondering if it was possible to get the width of the bucket in each case. There does not seem to be a build in feature to get this value, so we have to calculate this ourselves. He gives an example of how to calculate this.
Boris Dahav says, “The problem is a “popular” one. You have 2 facts with different levels of aggregation. It’s often Orders fact and Order Lines fact (where there are Order Total in the Orders fact and Lines values in Lines Fact that might not the same due to shipping or general discount). In my case this is Fines fact and Payments fact. In this case they sums often don’t match since they might be only partial payment of the fine.”
Jeff Smith says, “Oh, I so DO love hearing about things that ‘we cannot do.’ This morning I read that in an article that Oracle doesn’t allow you to copy data from Excel and paste directly to a table.”
Read the post and the discussion that results from this post here.
Cameron recruited Tyler Feddersen of Performance Architects to write about this really clever technique to enhance validations in Hyperion Planning. He concludes, saying, “And there you have it – a really clever way to handle validations in Planning using the functionality built into the tool. Thanks again Tyler for sharing this.”
The art of writing superb analyses and building popular interactive dashboards is not something that we see much of in the OBIEE blogsphere. Sure we have to build fast databases, and configure the servers, but what the customer sees is the dashboard.
I will look a bit harder this week for front end tips, so please get yours published on the groups, blogs and tweets.
I am actually trying to hire a couple of dedicated dashboard developers, so please take a look at the jobs page to see if you are what I am looking for.
Bojie says, “Today I am going to talk about writeback in OBIEE. As you know, writeback is a feature in OBIEE that allows users to update reports that they see in OBIEE without having to deal with the ETL process and reloading table.”
Cameron Lackpour introduces the first part of a three part blog post on how to achieve awesomeness in ASO Planning and beyond. In Part 1 he gives an introduction to the CDFs you most likely don’t know about.
Gerd says, “In ISO calendar the week turns on Mondays. When not reporting on real-time data and having a one day load frequency you will see no results each Monday. So it would be best to see previous week data on Mondays and of course having not change the filter criteria in the report.”
Praveen says, “Unfortunately, OBIEE doesn’t have a sort Control on the Grand Total and, creating a column with a total doesn’t get me what I have required. It has ends up being another metric in the pivot.”
For that we need add another metric name which Praveen shows us how to achieve.
Anjum Ara blogs about Error message : INST-08010: Error in validing the port range for auto port allocation. At Least 2 ports should be free within the range 7500-7500 for the Adminserver and Adminserver SSL
Kevin and Stewart discuss how the development lifecycle is hard in OBIEE. This rarely surfaces in the first implementation, but frustratingly creeps-in over time. However, this blog posts introduces a solution – Checkmate! Read the blog post for full details.
John Goodwin begins by saying: “If you have been working with planning then no doubt you have experienced the web application JVM crashing at some point which can be caused by a number of different factors.”
Paul Cannon informs us, “Oracle have just released the next patch set for OBIEE allowing any 188.8.131.52.0 installation to be upgraded to version 184.108.40.206.140527.” He says there are no new features in this patch – it’s just a bug fix patch and the list of bugs fixed is rather long !!
Boris Dahav was asked about an analysis where he compares the list of top 10 products of a company with the top 10 off all the others. This blog posts describes the solution and in the next post he will give some ideas of how this could be done better.