Extra Columns Are Created In Ad Hoc Grids Imported by Smartview (Doc ID 2039101.1)

Last updated on AUGUST 14, 2015

Applies to:

Hyperion Financial Management - Version 11.1.2.4.000 and later
Information in this document applies to any platform.

Symptoms

Smartview 11.1.2.5.400 with HFM 11.1.2.4

1. Given the following data grid, where columns are:

        Cols:  Year: Year-1; Period:Period-1
        Row:   top entity

2.  Import the above data grid using Smartview into Office 2013 and hit refresh
3.  Smartview  will returns 2 data fields (2 col and 1 row)
4. Try to expand by double clicking on "top entity" You get the following extra columns will appears:

       Col: Year: Year-1; Year: Year-1; Period: Period-1; Period: Period-1  (4 columns with tow extra columns generated incorrectly by Smartview)
       Row: expanded entity hierarchy

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms