Skip to Content

Analysis for Office 2.3 / 2.4 - Number of new lines in planning

Hi everybody,
I have an issue with a planning Scenario. I know that this question was opened many times but in my research I didnt find an answer for my following question:

The Business department wants to plan data and in this context they want to add / push back manually data lines into the source (cube).

I found the default value 5 in the design area of Analysis and I have read that in former Versions (1.x) the absolute / recommended limit was 1000 regarding this.
Is this now increased with AO in Version 2.3 respectively 2.4. Do anyone of you have experience with that?
and how can we understand this Limit? is it the number of total data lines which will be written into the source (cube) or is also the combination of characteristic values important (such like a ‘Limit of possible combinations of values’)?

Thanks and regards,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Nov 22, 2016 at 01:12 PM

    Hi Hakan,

    the limit seems to be still 1000 new lines. As we could not find any other working configuration/setting.

    There is a request on the IdeaPlace, but no update so far:



    Add comment
    10|10000 characters needed characters exceeded

  • Nov 30, 2016 at 02:24 PM


    Depending of the amount of columns, rows in combination with characteristic Relations it will be a pain to enter even a much lower amount of lines. So you sould try it before thinking about productive usage with large amounts of records.



    Add comment
    10|10000 characters needed characters exceeded

  • Oct 11, 2017 at 04:09 PM

    We too would like to see this limitation increased. Any updates on this one?

    In our scenario we use a planning DSO to allow users to input 1000s of Sender/Receiver percentages. It is not reasonable to have them scroll and locate each combination in the cross-tab to make updates. So, we use the DSO as a temporary workspace. A planning function copies the lines to another provider then deletes all lines from the DSO workspace. Therefore, each time they open the workspace it is empty and they can simply paste in all the new percentages. Works great, except there are several thousand Sender/Receiver entries that need to be made.

    I suppose the flat file upload is a viable work-around, but I dislike the idea of the users having to prep files and upload when they could just cut and paste into a template.

    I did vote for the "idea" though.

    Add comment
    10|10000 characters needed characters exceeded