System Maintenance Tasks: Maintain Setup Data

As well as staging table data, Data Management/FDMEE stores various setup components in SQL tables behind the scenes. We do not have direct access to these tables in PBCS, however there are a number of ‘System Maintenance Tasks’ within data management which can be used to update and maintain these hidden tables.


This blog will focus on the ‘Maintain Setup Data’ task only.

Maintain Setup Data

This task is useful to clean up the setup component tables, including clearing invalid import formats, data load rules or locations from data management.

Occasionally, “phantom” artefacts seem to get stuck in the background tables, with no way of deleting them from the front-end. For example, if there are rules which are selectable from the Workbench but do not appear in the Data Load Rules list and therefore can’t be removed.

When this happens, the ‘Maintain Setup Data’ task can resolve the issue, providing a way to view and remove these stuck artefacts.

There are two modes to choose from when running the Maintain Setup Data task:


1. Preview Mode

Before deleting anything from data management, use the preview mode to view any invalid import formats, data load rules or locations. Example Log for ‘Preview’ mode:

 


The above log is showing that we have the following invalid components stuck in the tables:

Invalid Import Formats; TestERPFormat, TestPlanFormat
Invalid Data Load Rules; TestRule1, TestRule2, TestRule3

The above list of components will be deleted when executing the ‘Maintain Setup Data’ task in Delete mode.

2. Delete Mode

After using the Preview mode to review the list of invalid import formats, data load rules or location, use the Delete mode to remove all of the listed artefacts from Data Management. Example Log for ‘Delete’ mode:



As with any process in Data Management, go to the ‘Process details’ area to view the progress of the maintenance job.

Once complete, navigate back to the relevant area to ensure the stuck component has been removed. 

Comments

  1. Srinu Vasu3 April 2020 at 06:50

    Hi, I really loved reading this article. By this article i have learnt many things about this topic, please keep me updating if there is any update
    FDMEE Online Training
    FDMEE Training

    ReplyDelete
  2. Bryant25 April 2021 at 21:59

    I am really very happy for the nice approach is visible in this blog and thank you very much for using the nice technology in this blog.I really appreciate your work.If you require about opc company registration fees in delhi | one person company registration in delhi please click on it.

    ReplyDelete
  3. baltazarjaber28 February 2022 at 02:38

    Is casino online safe? - Wooricasinos
    At 부들 이 벗방 any casino you will find that you can choose from 벳 센세이션 casino games like slots, blackjack, roulette, video poker, 부들 이 벗방 But the 1xbet 먹튀 online 배당사이트 gambling industry is

    ReplyDelete

Post a Comment

Popular posts from this blog

Executing Smart View Retrievals using VBA

Image
When working with Hyperion systems, Smart View is a key tool used for reporting, as well as inputting data. It provides a valuable link between Hyperion and Excel, which allows users to retrieve data from the database straight into Excel with ease. Smart View functions are available through the Smart View toolbar and can be used with Essbase, HFM, Planning or Cloud connections. Occasionally, it is necessary to perform Smart View functions behind the scenes using VBA code, rather than manually using the Smart View toolbar. For example, a spreadsheet which will refresh all the Essbase retrieval sheets on opening, so that users can view the most up to date data, without having to remember to refresh each of the retrieval sheets themselves. This blog will be cover how to retrieve data using a Smart View refresh function in VBA. For more information about Smart View Excel VBA functions, go to the Oracle Hyperion Smart View Developers Guide .  System Requirements T
Read more

Loading Actuals from Fusion ERP Cloud to PBCS

Image
If you’re looking to set up a data load of Actuals from ERP to PBCS and have heard this is an “Out of the box” integration, then good news! Not only is the OOTB connector included within PBCS Data Management but the integration is simple to setup and to schedule using EPM Automate. This blog will detail how to setup the ERP to PBCS connector in Data Management and some of the common errors found when running the data load. The first thing to know about this integration is that the data source is actually the ASO Essbase cube which sits underneath the Fusion ERP tables, holding the period Actuals values. This ERP Essbase cube is created using job ‘Create General Ledger Balances Cube’ when configuring the ERP system. This cube must be created before the integration can be set up correctly and can be accessed directly via Smart View for reconciliations. Set up the Source System As this is an Oracle built connector, it’s as simple as providing a name for the source system
Read more

Loading multi-period row data files using Data Management

Image
The ability to load multi-period data with the Period and/or Year in the rows is not particularly new (since release 16.10), however it is something that most people seem to forget is possible in Data Management. This really is something worth remembering as it eliminates the need to either split the data files into one file per month or try to pivot the month into the columns. In order to set this up, let’s firstly look at how to add the Period and Year columns to the import format. Add the Period and Year columns using the Add -> Source Period Row dropdown, and input: The Source Column name – e.g. PERIOD The Field Number (file column) – e.g. 3 Any required expressions for that field  As these are Period/Year dimensions, the mappings are not held in the usual Data Load Mappings area. Instead they are configured in the Period Mappings , under the Source Mapping tab. Select the Source System as File to add a new mapping calendar for loading the data file
Read more