Next
Essbase Was Invented by Who? When? @gadashek - 29-Apr-2017 11:43 - ODTUG EPM
With a filing date of April 5, 1990 - Google Patent listing

It appears that there were co-inventors: Wesley C. Sampson & Michael J. Olan


Take a look at a few of the images! Looks like a cube to me!








Let me clear with this post. In my mind there is a difference between who invented Essbase versus who founded/established Arbor Software Corporation.


The Arbor co-founders were Bob Earle and Jim Dorian in 1991. Their company shipped the first version of Essbase (or eSSbase) Online Analytical processing OLAP software. Their company became publicly held on the NASDAQ by 1995. In 1997, Arbor acquired Orlando, Florida-based Appsource. In 1998, Hyperion Software merged with Arbor and combined the company, and renamed it Hyperion Solutions. They sold products called Essbase, Hyperion Enterprise and Hyperion Pillar. In 1999, Hyperion acquired Sapling Corporation, and added products called Hyperion Performance Scorecard and Hyperion Business Modeling. In 2000, Hyperion introduced 2 web based packaged products, Hyperion Planning (same name as today) and Hyperion Financial Management (same as today HFM) and also partnered with WebTrends Corporation along the way. In 2002, Hyperion introduced a new product called Hyperion Business Performance Management Suite. In 2003, Hyperion acquired Brio Technology (which started with DataPivot on the Apple Macintosh.. why has "Hyperion" not given love to the Mac community yet!), Data Prism as well as The Alcar Group. In 2005, Hyperion acquired Razza Solutions (today we call it DRM). In 2006, Hyperion acquired UpStream (today we call it FDMEE). In 2007, Hyperion acquired Decisioneering (Crystal Ball). And also in 2007, Oracle announced the agreement to acquire Hyperion for $3.3B.
Essbase Was Invented by Who? When? - 29-Apr-2017 11:43 - Gary Adashek
With a filing date of April 5, 1990 - Google Patent listing

It appears that there were co-inventors: Wesley C. Sampson & Michael J. Olan


Take a look at a few of the images! Looks like a cube to me!








Let me clear with this post. In my mind there is a difference between who invented Essbase versus who founded/established Arbor Software Corporation.


The Arbor co-founders were Bob Earle and Jim Dorian in 1991. Their company shipped the first version of Essbase (or eSSbase) Online Analytical processing OLAP software. Their company became publicly held on the NASDAQ by 1995. In 1997, Arbor acquired Orlando, Florida-based Appsource. In 1998, Hyperion Software merged with Arbor and combined the company, and renamed it Hyperion Solutions. They sold products called Essbase, Hyperion Enterprise and Hyperion Pillar. In 1999, Hyperion acquired Sapling Corporation, and added products called Hyperion Performance Scorecard and Hyperion Business Modeling. In 2000, Hyperion introduced 2 web based packaged products, Hyperion Planning (same name as today) and Hyperion Financial Management (same as today HFM) and also partnered with WebTrends Corporation along the way. In 2002, Hyperion introduced a new product called Hyperion Business Performance Management Suite. In 2003, Hyperion acquired Brio Technology (which started with DataPivot on the Apple Macintosh.. why has "Hyperion" not given love to the Mac community yet!), Data Prism as well as The Alcar Group. In 2005, Hyperion acquired Razza Solutions (today we call it DRM). In 2006, Hyperion acquired UpStream (today we call it FDMEE). In 2007, Hyperion acquired Decisioneering (Crystal Ball). And also in 2007, Oracle announced the agreement to acquire Hyperion for $3.3B.

When I first started working on Hyperion Planning, clients and consultants would call the hotline and ask how they could see their existing security because back in the 1.0 days it was not available. So I dove into the database and wrote a Microsoft Access database that enabled consultants and clients the ability to see their security. We distributed the database and instructions if people asked nicely or loudly until the feature was written into the tool.

The Oracle EPBCS/FCCS platform does not come with a nice way of exporting and importing object security the way the on-prem version of Hyperion Planning had with its command line utilities. I decided to take a stab at hopefully making it easier.

EXPORTING SECURITY

This entry will focus on exporting the current security of an application and formatting it into a csv file so you can easily edit the security or view its contents.

I am going to focus on group security since it is a best practice to apply security at a group level. You can follow this process for users as well.

The first step is to extract the current application security using the migration component of EPBCS. You can use a complete application extract or just extract the security. Below I am just extracting the group security.

Once the migration is executed download it to your machine. Unzip the file and you will find your currently assigned security in super fun XML files for each group.

Here is what it looks like in XML.

Its pretty simple XML but not great to edit. Now that you have the files I have written a Powershell script that will convert all of the files in a directory to a combined csv file. By no means am I a Powershell master but I like it because its extremely quick, and handles XML, JSON, and CSV formats extremely well. Generally you will find it installed on most new servers or clients. Here is some documentation to enable it on windows.

It can also run on your mac or linux environment.

You can download the script here. Once you download it place it in a directory where you plan to execute it from.

The script accepts two parameters. The first is the directory where the XML files are stored and the second is the name of the file you want to create. If you don’t put a path the file will be saved in the same directory as where you execute the script. The parameters should be separated with a space.

Once you launch the shell navigate to the directory you have saved the script in.

Here is the command :

./sec2csv.ps1 “V:\POWERSHELL\BLOG\HP-TOYS\resource\Security\Access Permissions\Groups\” security.csv

Place quotes around the directory if you have spaces in it.

It will look like this in the shell.

Once the script runs it will generate your export.

It has now combined all of your group files into one csv file that will look like this.

The information in this file will be very similar to what was required for the import and export utility in planning. The definition of these fields can be found here. The only one that is really different is the IsUser field. For group security this will always be N.

CONCLUSION

I hope you find this first part of this conversion helpful. I am testing the CSV to XML script now, it has been working great and I should have that up soon. I hope this helps you manage security in the cloud!!


Where is my import/export security utility??? - 28-Apr-2017 14:41 - Anthony Manfredi

When I first started working on Hyperion Planning, clients and consultants would call the hotline and ask how they could see their existing security because back in the 1.0 days it was not available. So I dove into the database and wrote a Microsoft Access database that enabled consultants and clients the ability to see their security. We distributed the database and instructions if people asked nicely or loudly until the feature was written into the tool.

The Oracle EPBCS/FCCS platform does not come with a nice way of exporting and importing object security the way the on-prem version of Hyperion Planning had with its command line utilities. I decided to take a stab at hopefully making it easier.

EXPORTING SECURITY

This entry will focus on exporting the current security of an application and formatting it into a csv file so you can easily edit the security or view its contents.

I am going to focus on group security since it is a best practice to apply security at a group level. You can follow this process for users as well.

The first step is to extract the current application security using the migration component of EPBCS. You can use a complete application extract or just extract the security. Below I am just extracting the group security.

Once the migration is executed download it to your machine. Unzip the file and you will find your currently assigned security in super fun XML files for each group.

Here is what it looks like in XML.

Its pretty simple XML but not great to edit. Now that you have the files I have written a Powershell script that will convert all of the files in a directory to a combined csv file. By no means am I a Powershell master but I like it because its extremely quick, and handles XML, JSON, and CSV formats extremely well. Generally you will find it installed on most new servers or clients. Here is some documentation to enable it on windows.

It can also run on your mac or linux environment.

You can download the script here. Once you download it place it in a directory where you plan to execute it from.

The script accepts two parameters. The first is the directory where the XML files are stored and the second is the name of the file you want to create. If you don’t put a path the file will be saved in the same directory as where you execute the script. The parameters should be separated with a space.

Once you launch the shell navigate to the directory you have saved the script in.

Here is the command :

./sec2csv.ps1 “V:\POWERSHELL\BLOG\HP-TOYS\resource\Security\Access Permissions\Groups\” security.csv

Place quotes around the directory if you have spaces in it.

It will look like this in the shell.

Once the script runs it will generate your export.

It has now combined all of your group files into one csv file that will look like this.

The information in this file will be very similar to what was required for the import and export utility in planning. The definition of these fields can be found here. The only one that is really different is the IsUser field. For group security this will always be N.

CONCLUSION

I hope you find this first part of this conversion helpful. I am testing the CSV to XML script now, it has been working great and I should have that up soon. I hope this helps you manage security in the cloud!!


PBJ 1.0.4 – New password options and start of CLI - 28-Apr-2017 11:24 - Jason Jones
The PBJ library has been getting a lot of attention lately from various developers using it to integrate with their own software and projects. Francisco Amores did a great blog post about using PBJ to help with data loading in an FDMEE project. Probably the coolest thing about his efforts is that it’s  use-case I never […]
The PBJ library has been getting a lot of attention lately from various developers using it to integrate with their own software and projects. Francisco Amores did a great blog post about using PBJ to help with data loading in an FDMEE project. Probably the coolest thing about his efforts is that it’s  use-case I never […]

Tech Days

GAOUG will be hosting their Tech Days conference in Atlanta on May 9th. This is a TWO DAY event full of hands-on training and training across database, big data, middleware, and applications. It will be at the Loudermilk Conference Center

Come hear my session

Title:  Maintaining, Monitoring, Administering, and Patching Oracle EPM Systems

Time: Wednesday May 10th, 4-5pm Anna Cablik room.

Content for Tech days is here

Register here

 

 

 

Logo white

INNOVATE17 is a collaborative initiative of the Northeast PeopleSoft and New York – New Jersey JD Edwards User Group (NERUG), the Greater Philly PeopleSoft and JD Edwards User Group (PHRUG), the Oracle Human Capital Management Users Group (OHUG) and the Oracle Applications Users Groups of New Jersey, Metro New York City and the Mid-Atlantic (OAUGNJ, OAUGNYC and MAOAUG) in partnership with Oracle

This event will be held Thursday, May 11, 2017 from 7:30 AM to 4:30 PM at the Renaissance Woodbridge Hotel in Iselin, NJ 08830

Come to my session on comparing cloud options for Hyperion/EPM customers:

Showdown: SaaS vs. IaaS vs. Cloud vs. On-premise. A detailed comparison of all Oracle EPM Deployment Scenario

Time: 12:50 – 1:40

This session will qualify for 1 CPA CPE Credit.

Registration and details here

 


Tech Days

GAOUG will be hosting their Tech Days conference in Atlanta on May 9th. This is a TWO DAY event full of hands-on training and training across database, big data, middleware, and applications. It will be at the Loudermilk Conference Center

Come hear my session

Title:  Maintaining, Monitoring, Administering, and Patching Oracle EPM Systems

Time: Wednesday May 10th, 4-5pm Anna Cablik room.

Content for Tech days is here

Register here

 

 

 

Logo white

INNOVATE17 is a collaborative initiative of the Northeast PeopleSoft and New York – New Jersey JD Edwards User Group (NERUG), the Greater Philly PeopleSoft and JD Edwards User Group (PHRUG), the Oracle Human Capital Management Users Group (OHUG) and the Oracle Applications Users Groups of New Jersey, Metro New York City and the Mid-Atlantic (OAUGNJ, OAUGNYC and MAOAUG) in partnership with Oracle

This event will be held Thursday, May 11, 2017 from 7:30 AM to 4:30 PM at the Renaissance Woodbridge Hotel in Iselin, NJ 08830

Come to my session on comparing cloud options for Hyperion/EPM customers:

Showdown: SaaS vs. IaaS vs. Cloud vs. On-premise. A detailed comparison of all Oracle EPM Deployment Scenario

Time: 12:50 – 1:40

This session will qualify for 1 CPA CPE Credit.

Registration and details here

 


The Importance of User Groups! - 27-Apr-2017 11:00 - Multiple
Hi guys, this is just a quick post about the coming seminar The Importance of User Groups. In the modern, digital world in which we now live, what is the value of a user group? Can we not get the content from Google, YouTube or Oracle direct? Join Debra and Natalie as they discuss where […]
Hi guys, this is just a quick post about the coming seminar The Importance of User Groups. In the modern, digital world in which we now live, what is the value of a user group? Can we not get the content from Google, YouTube or Oracle direct? Join Debra and Natalie as they discuss where […]
Next