Skip to Content
avatar image
Former Member

How to update a single dimension in a local model or individual dimension with Data Import?

Hello,

Is it possible to update a single dimension (from master data) either from a file or, better yet, using an Import connection that can be scheduled just for that purpose?

I'm trying to import data to from Excel to a model and to only update a single dimension, but I can't get past it because it apparently requires all dimensions mapped. (see attached image).importtodimensionboc.png

Regards!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Mar 31, 2017 at 09:25 PM

    Please refer this note

    2380656 - Importing data from files into an existing model does not add new dimensions in BusinessObjects Cloud

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 30, 2017 at 09:39 AM

    Hi Ricardo,

    i can confirm - this is a feature requirement that i am also tracking for another customer. Unfortunately there's not currently an elegant way to 'automate' the retraining of dimension tables only.

    However, there is a new workflow to 'Update' new records to your model (previously only "Append" or "Clean and Replace" import method)

    If you repeat 'import data from file' into an already existing model (+ re-confirm the mappings)

    then you activate this "Import Now" feature which preserves the master-data customizing.

    Not what you need, i realise.. but good to know i think .

    Kind regards,

    H

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 27, 2017 at 11:44 AM

    I was looking for the same thing, but do experience the same thing. The model I built needs measures.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 31, 2017 at 09:19 PM

    Hi...Currently updating one dimension manually to import the model is not possible either by append/clean and replace, we get dimension mapping issues in the model and new data gets rejected during import and it only imports old records...Only way to achive is to upload using file server method.

    BR,

    Lakshmikanth Adharapurapu

    Add comment
    10|10000 characters needed characters exceeded