Create Dimension set id for the combination of three 'Dimension code': Dept,Project and Channel.

Answers

• ManiNav Member Posts: 120

  2019-12-16

  Hi everyone,
  
  Please guide me for the above query.
  
  Thanks,
  Mani.

  0
• KTA8 Member Posts: 399

  2019-12-16

  You should create a temporary dimension set entry something like this:
  
  
  DimSetEntry.INIT;
  DimSetEntry."Dimension Set ID":=-1;
  DimSetEntry."Dimension Code":=lt_DimSetEntry."Dimension Code";
  DimSetEntry."Dimension Value Code":=lt_DimSetEntry."Dimension Value Code";
  DimSetEntry."Dimension Value ID":=lt_DimSetEntry."Dimension Value ID";
  DimSetEntry."Dimension Name":=lt_DimSetEntry."Dimension Name";
  DimSetEntry."Dimension Value Name":=lt_DimSetEntry."Dimension Value Name";
  DimSetEntry.INSERT(FALSE);
  
  Using this function, you will get the id
  GetDimensionSetID(recDimSetEntry)

  0
• ManiNav Member Posts: 120

  2019-12-16

  Hi KTA8,
  
  Thank you so much for your reply.
  Here I am not able to get, where you add my required three 'Dimension code': Dept,Project and Channel. and for which record you are using lt_DimSetEntry.
  
  Please tell me. your will be appreciable.
  
  Thanks,
  Mani.

  0
• Phogue Member Posts: 76

  2019-12-16 edited 2019-12-16

  Each of your dimensions is inserted as a Record of Dimension Set Entry, using the following block from KTA8:
  

  DimSetEntry.INIT;
  DimSetEntry."Dimension Set ID":=-1;
  DimSetEntry."Dimension Code":=lt_DimSetEntry."Dimension Code"; //This is your three codes: project, dept & channel
  DimSetEntry."Dimension Value Code":=lt_DimSetEntry."Dimension Value Code"; //This is the value from your dimension codes
  DimSetEntry."Dimension Value ID":=lt_DimSetEntry."Dimension Value ID";
  DimSetEntry."Dimension Name":=lt_DimSetEntry."Dimension Name";
  DimSetEntry."Dimension Value Name":=lt_DimSetEntry."Dimension Value Name";
  DimSetEntry.INSERT(FALSE);
  

  
  Then, once you've inserted all 3, you pass it as a parameter to the GetDimensionSetID Function, which is in the Dimension Set Entry table.
  

  0
• ManiNav Member Posts: 120

  2019-12-18

  Hi KTA8/Phogue,
  
  below code is not working as i need.
  
  DimSetEntry.INIT;
  DimSetEntry."Dimension Set ID":=-1;
  DimSetEntry."Dimension Code":=lt_DimSetEntry."Dimension Code"; //This is your three codes: project, dept & channel
  DimSetEntry."Dimension Value Code":=lt_DimSetEntry."Dimension Value Code"; //This is the value from your dimension codes
  DimSetEntry."Dimension Value ID":=lt_DimSetEntry."Dimension Value ID";
  DimSetEntry."Dimension Name":=lt_DimSetEntry."Dimension Name";
  DimSetEntry."Dimension Value Name":=lt_DimSetEntry."Dimension Value Name";
  DimSetEntry.INSERT(FALSE);
  
  I am not able to get your whole code:
  1.DimSetEntry."Dimension Set ID":=-1;
  ---> why you assign to -1,what it will do?
  2.DimSetEntry."Dimension Code":=lt_DimSetEntry."Dimension Code"; //This is your three codes: project, dept & channel
  ---> here, for which record you are using 'lt_DimSetEntry', is it variable for 'Dimension set entry'? I am using 'DimSetEntry' with property-Temporary = Yes.
  
  so, please tell me in details, because i am not getting how it will generate Dimension set id for my given three Dimension code combination: Dept, channel and project.
  
  Plese guide me,
  
  Thanks,
  Mani.

  0
• ManiNav Member Posts: 120

  2019-12-18

  Hi KTA8/Phogue,
  
  Actually i am creating purchase invoice to take the value from one table, where i have three dimension code combination, but for this i need to update one dimension set id for all dimension code. For this I need to create dimension set id.
  
  Please help me further.
  
  Thanks,
  Mani.

  0