on 06-28-2016 5:24 PM
Hi,
I recently ran into the following issue. I have a dimension with over 60,000 members. When I use the Admin Client to Export the dimension (Model > Dimension Library > Dimension > Export Dimension) the resulting xlsx file (PC_MS\Data\Webfolders\Model\ADMINAPP) is cut off at 60,000 rows.
So I have say 60,548 rows in a mbr* table, but the extract from the admin console is cutting off the results at 60,000 in the xlsx file and this ultimately results in having issues with processing the dimension.
Is anyone aware of a max size for a BPC dimension, or a parameter to increase the max size for the admin console?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
10.1
When I use the Admin Client to Export the dimension (Model > Dimension Library > Dimension > Export Dimension) the resulting xlsx file (PC_MS\Data\Webfolders\Model\ADMINAPP) is cut off at 60,000 rows.
I have reviewed the link you sent, but I didn't see a fix in there. Is there a setting somewhere that determines the max number of rows able to be exported.
Hi Jon,
That document suggests that the "Each dimension a user has access to gets cached during the first login on a given machine and then subsequent logins, when changes are made. The XML cache files consist of one line per dimension member / hierarchy that a user has access to. Each line documents all of the properties associated with that dimension member."
and can load upto 100,000 members in a dimension. No such limitation is given for dimension members, thats what I wanted to point out!.
Have you tried to export master data using data manger package? CPMB/EXPORT_MD_TO_FILE process chain.
Regards,
JP
Hi, Check this parameter.....Dont know this helps or not. Just a thought!
Environment Parameters - SAP Business Planning and Consolidation - SAP Library
Required | MEMBERSHEET_VERSION | Determines whether you use the .xls Excel workbook type or .xlsx Excel workbook type for the dimension member sheet. The default value is 2007, which uses the .xlsx workbook type. You can change it to 2003 to use an Excel 2003 workbook. However, when you change it to 2003, you must runExport Dimension in the Administration client for all of the dimensions. When you change the value from 2003 to 2007, however, you do not have to run Export Dimension because the Administration client converts it automatically. |
Regards,
JP
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.