Skip to Content
author's profile photo Former Member
Former Member

Transformation file (.xlsx) not available for selection

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jul 23, 2014 at 03:09 AM

    Hi,Rohit Khatak

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Fred Wei

      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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.