Essbase

Get Involved. Join the Conversation.

Topic

    Nachiket Mehendale
    Target Application and Import Format details in FDMEE
    Topic posted December 4, 2018 by Nachiket MehendaleRed Ribbon: 250+ Points, tagged Cube Designer, Essbase, OAC Enterprise Edition 
    111 Views, 3 Comments
    Title:
    Target Application and Import Format details in FDMEE
    Content:

    We have sample outline and data file for a cube which we have been able to load through a Rules file. 

    Now we are trying to load the data through FDMEE. We require your help in understanding where are we going wrong.

    Outline image and sample data file image is attached here.

    In the FDMEE application, Target Application,

    It shows us 5 columns - Amount Product Measures Market Year

    In our data file, we do not have Amount and Measures dimension. We have sub parts (children) of Measures dimension.

    We have

    Dimension.Product    
    Dimension.Market    
    Dimension.Year    
    Dimension.Scenario    
    Measures.Sales    
    Measures.COGS    
    Measures.Marketing    
    Measures.Payroll    
    Measures.Misc    
    Measures.Opening Inventory    
    Measures.Additions

    In this case, how do we add these columns in Target Application ?

    And how to give positions (field numbers) to them in Import Format option ?

    Image:

    Comment