What's "Target Header Type" for Local File exports?

Answered

DSP User

• January 15, 2018 04:59

We want to generate target export reports (transform) with two headers, technical field and field description. Our export type is “local file.” We have seen that in Transform > Target Export > Vertical View > click on Package link > Vertical View of the package > Advance Properties ... there's a field named Target Header Types, but it's not showing what we expect. Has anyone faced this requirement?

1

• Best answer

  

  DSP Expert

  • January 15, 2018 06:21

  VGazquez: Hi Alejandro, Yes, it is possible; it is a standard. As you mentioned, when you select Report Type = Local file, you can select what information you want to display (technical, translated or both) in the Assemble package

  Your issue is that you need to have an associated Catalog assigned in CranPort to make it work. I have taken the chance to create a post in Data Insiders where I go through all the details:

  https://support.syniti.com/hc/en-us/community/posts/360000002387--How-To-Export-Reports-with-Technical-and-Translated-column-headers 

  Or go to Data Insiders > DSP Tips and Tricks > [How To] Export Reports with Technical and Translated column headers Regards

  0
• 

  DSP Expert

  • January 15, 2018 06:12

  PTowe: There is a generic workaround solution to this that I have used in the past for non-DSP reports and will do just as well for dsp reports:

  Re-write the query behind the report to make it a union query. The first line of "Data" should use the same field names as a the body, but the data is actually the description. Like this: Select 'Site' as WERKS, 'Material Number' as MATNR union ALL select WERKS, MATNR from MAPL

  0

Please sign in to leave a comment.