Sunday, April 12, 2015

Collaborate2015

Hi all,

I will be attending and presenting @Collaborate2015.

In case you wish to meet there just let me know!

Update 13th April 
For DRM customers, we knew FDMEE is was going to be integrated with DRM so we can maintain our mappings in DRM and import them into FDMEE (you may have been doing this with custom solutions)
It seems that Oracle is also delivering the integration the other way back...having DRM as target in FDMEE so we will be able to load metadata from our ERP systems into DRM using FDMEE.
To wrap up:
- DRM as a source for mappings import
- DRM as a target for metadata loading 
Cool!

Also, as FCM is getting more powerful, FDMEE-FCM integration will provide more capabilities to users during the month close.

For SAP integration, we will able to load metadata from SAP BW into our EPM apps. Why no SAP ERP? Basically metadata is too spread for SAP ERP so metadata can come from many different places whereas SAP BW metadata is easier to access. First step for a better future integration.

Internet Explorer 11 is now supported in 11.1.2.4. What about 11.1.2.3? we will have to wait until summer :-)

All this is planned to be released in the next PSUs.

And what about next release? 11.1.2.5? 12.x.x? although not officially confirmed, I would bet all my money on the second option. In that way, we would have EPM aligned with the Oracle application stack. When? 2016

Roadmap

  • Non-numeric data loading into Planning
  • Metadata loading from heterogeneous systems (files...)
  • Mapping review mode
  • Mobile functionality for drill-thru page

Please, not that this information is not officially published yet so do not use for making important decisions :-)

Monday, April 6, 2015

Mayday, Mayday, I cannot see the source columns in drill-through details page!

Often seemingly insignificant things make us waste time more than expected.
From my experience, issue below is one the most common for FDM users getting into FDMEE.
Customers sometimes complain about not being able to see source accounts when they drill-through from EPM applications into FDMEE.
Even if we try to select columns from View option, we don't see them:
Are they gone? maybe under the sofa? don't panic :-)
The reason is that FDMEE takes the column names from your import format so if they are not correctly setup in it you will not be able to select them from the View menu in the drill-through details page:
As a good practice, try to set column names for your import even if they have the same name as the target dimension. You can also use some meaningful name or alias.
Then when you drill-through you will see source columns as expected. Column name will show the name you set in the import format plus the dimension assigned in the import format. Now you have time to fix your next issue and forget about this one.
All this applies also to Excel Trial-Balance templates for both single and multiple periods. Documentation says:
"When you an Excel Trail Balance template, the template can contain one or more periods. When
doing a multiple period load, you need to create a dummy import format that indicates multiple
periods. If just a single data value is in the Excel file, then you don't need an import format"
But what is a dummy import format? empty one? If you leave it empty, then you will experience issue above.
In that situation, create a dummy import format (it won't be used anyway), set all column names to what you want to see in the drill-through details, and assign 1 to field number.

Enjoy!

Where was I? What have been doing?

Hey folks!

I have been very busy with my little baby, not sleeping so much, and becoming an expert on diaper changing :-)
Being said that, I hope you all understand why I was not blogging so often.

So now trying to normalize my life, one of the TO-DO bullets is to keep on sharing FDMEE stuff with all the EPM community.

As I always say, the show must go on!!!