Dimensions are saving as .xls instead of .xlsx

[Former Member]

I am on BPC 7.0. My dimensions are currently saving as .xls (Excel 2003) files when I process the dimesnion from Admin. How can I change this so that the dimensions will save as .xlsx (Excel 2007) files? I have tried opening the dimension file in Excel 2007, then saving it as an .xlsx file, but when I try to open the dimension from Admin afterward, it does not recognize the file.

Any help would be appreciated. Thanks.

[james_lim · Accepted solution]

Khristina,

What service pack are you using it?

I tested it SP6 and it works well.

If you are not using SP6, please try it.

Maybe it was fixed between your version and SP6.

Thank you.

James Lim

[Former Member · Accepted solution]

Thank you so much for your response.

I believe that we are on Service pack 2.x.

Do you know how BPC knows which file to open for a dimension? Is it stored as a system configuration or in a database table somewhere?

[former_member599120 · Accepted solution]

Dear Khristina Hutabarat,

You can find the SAP BPC notes which talk about Ms.Excel 2007 format at SAP Service Marketplace. For more information about Ms.Excel 2007 in SAP administration console, please open SAP service website at [http://service.sap.com/instguidesEPM-BPC] and search notes 1265872. If you want to upgrade your version of SAP BPC 7M to be SAP BPC 7M SP06, you can read the SAP notes 1388412 before.

Best Regards,

Wandi Sutandi

[Former Member · Accepted solution]

Hi Khristina,

The SP2 does support excel 2007 format. However, there are few catches.

When you process dimension for the first time, a message window will pop up asking to select the version, 2003 or earlier, or 2007. Once this option has been selected. It creates an entry in the table tblDefaults and cannot be changed later.

If you have selected 2003 or earlier, then the dimensions will be saved with .xls extension. In this case, all the excel versions (including 2007) can open the dimension sheets.

If you have selected 2007, the dimensions will be saved with .xlsx extension. In this case, the dimension sheets can be opened only if your system has 2007. If any system has 2003 or earlier version, then they will not be able to open the dimension sheets.

Hope this helps you.

[srinivas_thota5 · Accepted solution]

Hi,

I have similar problem,

right now i am using BPC 7.0 Ms SP04 with microsoft office 2003. I have a BPC application set with which is built in MS 2007 and all the dimensions, Input shedules and reports are in .xlsx format. When i restore the application set i am not able to see the dimenstion memember or reports as both excel version are different.

how to fix this problem.......

I appriciate your inputs.

[james_lim · Accepted solution]

Only thing you can do is converting input template and report manually.

I mean open it using Excel 2007 and save it as XLS format so that 2003 and 2007 can open it.

Thank you.

James Lim.

[Former Member · Accepted solution]

Thank you so much for the reply. This has solved my problem. I am working in a development environment and so was able to change the Value where the KeyID = MEMBERSHEET_VERSION from '2003' to '2007' and this fixed our issue.

Thank you!