Tim Vlamis is Presenting at Kscope 2017

Tim Vlamis will be attending and presenting at ODTUG Kscope 2017. Kscope 2017 takes place from June 25 to June 29, at the JW Marriot in San Antonio, Texas.

This year Tim Vlamis will be presenting:

For more information on Kscope 17 visit http://kscope17.com/.

For more information on Tim's sessions, visit our presentations page.

We are looking forward to seeing you there!

Migrating Oracle Analytics Cloud and Oracle BI Cloud Service - Favorites not working? Can't stop seeing the Product Tour? Access denied for user to path?

When working with an Oracle Business Intelligence Cloud or Oracle Analytics Cloud instance that has been migrated from one environment to another, your users may encounter an access denied for user to path error when performing actions that access their profile files. They may also not be able to see their "My Folders" or are unable to disable the Product Tour.

Oracle Business Intelligence Cloud "Access denied for user to path /users/"

Oracle Business Intelligence Cloud "Access denied for user to path /users/"

In our case, we were migrating a test BICS environment from one Oracle Cloud account to another and this included creating a new Identity Domain. We recreated the users in the source environment presuming they would either 'just work' with the target environment, or would generate entirely new profiles in the new catalog.

Neither of these things happened!

The users on the new account were given the My Folders system folders that matched their usernames as imported from the old account through the bar file. However, the permissions for those objects did not get updated to match the users in the new system. This made the new users have profile settings and files from the old system that they were unable to access or modify.

To fix this, we logged into the new system with a user that had full administrative privileges. With elevated privileges, you are given several additional options in the Catalog page. By changing the view to the Admin View, you can see all of the user-specific objects in the catalog and modify them.

Since none of the permissions from the old system worked with the new system, even our super-user account was unable to edit the files until we took ownership of the files away from the system and gave them to super-user. To do that, you have to right-click the user's folder and click properties. In the properties dialog, there is a link to "Set Ownership of this item and all subitems". Clicking that will give you the ability to set the permissions of the files.

Once you have changed the ownership, right-click the folder and click Permissions. Click the + icon at the top-right of the dialog box to add the user to the Permissions list. We found that selecting 'Users' in the list box and clicking the button labeled "Search" and retrieving our short list of users was the easiest way to select users. Once you have added the user account to the "Selected Members", click OK. You will be taken back to the Permissions box. Make sure you check the "Apply permissions to sub-folders." and the "Apply permissions to items within folder." boxes and validate that the "Replace All" is selected. Click OK.

Once these changes are made, the user should then have access to their own objects within "My Folders", be able to add items to the Favorites menu, and disable the Product Tour. These changes will have to be made for each user. If you have any great ideas on how to do this with a larger number of internal users or any questions, leave a comment. I can also be reached by email at jclark@vlamis.com or Twitter @mustachebi

Thanks for Celebrating with us!

We are thrilled at the overwhelming response to our 25th anniversary party and we would like to thank everyone who attended or wrote in our guestbook to help us celebrate.

If you would like to sign or view our online guestbook please visit http://www.vlamis.com/blog/2017/3/29/sign-our-anniversary-party-virtual-guest-book.

We hope everyone had as much fun at the party as we did. Check out some of the pictures below!

For Organizations New to Predictive Analytics, Bet on a Process and Not on a Project

Advanced Analytics Projects are Atypical

Successful projects using data mining algorithms often have returns that are well above normal business Returns on Investment. 200%, 500% or even 1000%+ ROIs are not unheard of. So why isn’t there a rush to do more Proof of Concept projects? Having designed and pitched dozens of these, I have concluded that it’s largely because of corporate politics. I’m not using the term “corporate politics” in a pejorative sense, but rather as a fact of life that results from normal business structures and organizational dynamics. So perhaps the question is not “how do we fight better to get funding for new data mining projects?”, but rather it’s “how do we lower the political risk associated with Proof of Concept projects using data mining algorithms and predictive analytic techniques?” We recently did a program with a client which did exactly that.


Place a Lot of Bets

Think like a venture capitalist. Place a large number of small bets rather than one or two large bets. We recently led a predictive analytics summit workshop at a client’s headquarters where representatives of different functional areas of the corporation were invited to bring their own data for a day-and-a-half of intense data discovery using advanced data visualization and predictive analytics tools (Oracle Data Visualization Desktop and OBIEE 12c). There were roughly 40 participants from groups as diverse as sales, service, finance, operations, and marketing. Everyone sat at round tables organized by function in one large room (a table for sales, a table for finance, etc.). The participants were largely comprised of the business intelligence system’s “power users”. A few had engineering or technical backgrounds that gave them a leg up in statistics and analytics, but most were just smart people interested in their business and data analysis. We also had plenty of help on hand including representatives from the IT staff who could solve potential data connection or data structure issues, a couple data scientists who knew statistics cold, some experts in the software interface who could help with “where do I click?” questions, and some support staff who made sure that all the conference logistics were handled.


Amazing Returns

The results were incredible. One “discovered” insight provided the >1000% ROI that qualifies as a “home run”. The workshop participant made an appointment with his VP to share the insight and its visualization for the next business day (why wait?). In totality, more than 30 projects were identified as potentially significant areas for future work and development. Was it all sunshine and unicorns? Not at all. Some people struggled to get their data sets fully prepped for predictive analytic processes. Others changed their minds during the middle of working on something and never really finished an analysis. But there was no stigma attached to not hitting the ball out of the park. Everyone who was there contributed to the success of the overall workshop. Perhaps one of the most significant outcomes was the cross-functional collaboration between the different teams. A few hours into the workshop after walking around and observing everyone and helping some people, we identified some interesting and promising results. We asked people to present their initial findings and visualizations to the entire room in the context of their business problem. It got people thinking broadly about the business and how their work might intersect with others’ work. It also showed different visualization and analytic techniques. And it provided a bit of a break from discovery work without losing momentum in the workshop.


The Secret to Success is in the Preparation

Everyone who does data mining or predictive analytics knows that half the battle and more than half the work is in preparing the data. Likewise, there is a lot of work in preparing a successful workshop and setting everyone up for success. We did several things and leveraged several of our internal processes we typically use on consulting engagements. All participants were required to write up their business cases in advance (we provided them with an outline of questions). Participants were required to submit their individual data sets in advance based on explicit directions. Finally, all participants were asked to review introductory articles and videos on predictive analytics in advance so a common foundation of terms and concepts could be leveraged in the actual hands-on work. There were also “preworkshop” meetings where we reviewed the process and answered questions and made sure that people were making progress on their business cases and data sets. Using one of the data sets, we developed a training exercise customized to their data with a step-by-step data discovery process so that participants were able to see theory applied in practice.


The Best Way to Get Started is to… Start

Want to get traction and help predictive analytics get going your business? Consider sponsoring a multi-day workshop for a sizeable (but not enormous) group of power users with several different business cases. You may not know precisely which ones will be the winners going in and the proctors may have to accept some degree of discomfort in not knowing the details of the “live” data sets, but it’s basically what venture capitalists do. They spread their bets, enable and assist where they can, and somehow, they manage to do pretty well.

If you want to talk about your business and how a workshop might help, send me a note to tvlamis@vlamis.com or just call me at 816-781-2880.