cancel
Showing results for 
Search instead for 
Did you mean: 

Transformation file (.xlsx) not available for selection

Former Member
0 Kudos

Hello Experts,

We are working on BPC 7.5 M, Currently our Dimension files, Reports,Input templates,transformation files,Conversion files are in Office 2003 format (.xls and .xlt), we would like to convert them in Office 2007 format (.xlsx/m and .xltx/m).

I have changed the MEMBERSHEET_VERSION from '2003' to '2007 in tbldefaults table and also added [ALL] in DEFAULT_EXTENSIONS and ALLOW_EXTENSIONS properties under Appset parameters in BPC Admin module.

After this I processed all the dimensions and they got created in .xlsx (Office 2007 format).

I am seeing in issue while opening the transformation/conversion file,the issue is that when I try to open the Transformation file I see only ".xls" file type available to be opened, please find the screenshot below.

Do I need to add/modify any property to have .xlsx format to be visible while opening transformation/conversion file.

Please Advice.

Thanks & Regards,

Rohit

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hi,

For transforamtion file and conversion file,you don't need to change the format to 2007.

It works fine with 2003 format.

Even in Apshell,it is 2003 format as well.

Please refer to SAP note  1287801 which explains how Office 2007 files

are supported in Data Manager. On the bottom of the note is mentioned th

at we do not support Excel 2007 file format (xlsx) for transformation/conversion files.

Don't worry about it.

Former Member
0 Kudos

Hi Fred,

Thanks for your reply, SAP note 1287801 is about BPC 5.1 and there it was limitation that Excel 2007 file format (xlsx) for transformation/conversion files are not supported.

There is no such limitation with BPC 7.5, I have opened the test.xls transformation file in BPC 7.5 and SaveAs it as test.xlsx and Validate and Processed it and it went successfully and also TDMx file is created in Transformation directory. The only issue I am seeing is that when I try to open the Transformation file I see only ".xls" file type available to be opened and not the .xlsx option.

Thanks & Regards,

Rohit

0 Kudos

Hi,Rohit

I checked with with BPC MS developer before and got the confirmation that the limitation still applys to 7.5 version.And even in BPC 10,it is also xls format.

If you create a new transforamtion file in office 2007 and save it by validating it,what is extension of the file? It is xls as well.

Former Member
0 Kudos

Hi Fred,

I have tried creating a transformation file in 2007 and save it by validating and while saving I got all the File types options, I choose the All Excel Files option and saved the file with .xlsx and file got created with .xlsx and .TDMx in transformation directory. (please look at screenshot attached)

The issue is when I went to Manage Transformation File menu item then I only see file of type .xls in Open window.

Thanks & Regards,

Rohit

0 Kudos

Hi,Rohit

I tested again in my system.

After you created it in xlsx exention and try to open it again from Manage Transformation File menu,the first option is 'XLS'.But you can select All Excel Files option from the drop down list.If you select the 'all excel files'option,the XLSX file you saved just now will appear.

Former Member
0 Kudos

Hi Fred,

That's the issue as I am not getting All Excel file option while opening transformation file.

My original question was I have changed the MEMBERSHEET_VERSION from '2003' to '2007 in tbldefaults table and also added [ALL] in DEFAULT_EXTENSIONS and ALLOW_EXTENSIONS properties under Appset parameters in BPC Admin module.

Do I need to add/modify any property to have All Excel file option available while opening transformation/conversion file.

Thanks & Regards,

Rohit

Answers (0)