auto repeat is possible?

Hello, Daniele,

Thank you for reaching out to us.

We suggest using the customizeCell() API call to have the desired result. Kindly check the following JSfiddle for reference: https://jsfiddle.net/flexmonster/2z61x0ps/ 
In the example above, we used the data.rows and data.level properties of the CellDataObject to get the caption of the parent.

Please let us know if it works for you. Feel free to contact us if other questions arise.

Kind regards,
Nadia

Hello, Fabrizio,

Thank you for providing us with the code.

The error appeared due to the hierarchy. Therefore, we suggest the following workaround using the getMembers API call and the custom recursive search to find the corresponding caption of the parent:

function customizeCellFunction(cell, data) {
  if (data && data.type == "header" &&
    data.member && data.label == " ") {
    let parentName = data.rows[0].parentMember;
    let members = flexmonster.getMembers("G");
    cell.text = recursiveSearch(members, parentName)
  }
}

Please you are free to use the following function: 

function recursiveSearch(members, parent) {
  for (let mmb in members) {
    if (parent === members[mmb].uniqueName) {
      return members[mmb].caption;
    }
    if (parent.startsWith(members[mmb].uniqueName)) {
      return recursiveSearch(members[mmb].children, parent);
    }
  }
}

Kindly note that we described only one of the possible approaches. You are welcome to customize it for your needs.

Please let us know if it works for you. Looking forward to hearing from you.

Kind regards,
Nadia

Hello, Fabrizio,

Thank you for the response.

We recommend making the following report adjustments to achieve the functionality shown in the screenshot:

• Remove the "Anno" field inside the slice.columns. This way, the "Mese" field would be on top.
• To hide the "Reddito Netto", you should set the "G2" field as a top-level field of the "G" hierarchy. If needed, you can exclude the "G1" from the Fields list with the "visible": false setting. You are welcome to see the code example below:

"mapping": {
        "G1": {
          "visible": false
        },
        "G2": {
          "hierarchy": "G"
        },
        "G3": {
          "hierarchy": "G",
          "parent": "G2"
        },
        //Other...
}

• To expand the "G2" top-level fields, add the drills object to your slice configuration with the following settings: 

"drills": {
        "rows": [{
            "tuple": [ "g.[ ebitda]" ]
          }, {
            "tuple": [ "g.[deprezzamenti]" ]
          }
        ]
}

Please let us know if the suggested approach helped you. Looking forward to your response.

Kind regards,
Nadia

Hi, Fabrizio!

Thank you for your feedback.

If we understood correctly, you would like to have the top member in rows ("Reddito Netto" G1), and the top field in columns ("Anno") expanded by default and then hide the expand/collapse arrow icons to prevent them from being collapsed. To achieve this, we suggest the following solution:

1.  To keep certain hierarchies expanded, you can set the expands into the slice or use the expandData() API call. We recommend expanding the needed cells via UI, saving the report with the "Save" toolbar tab, and copying the saved drills and expands into your report configuration. 
2. You can remove the expand/collapse icons and prevent the collapse/expand action with the customizeCell method. You are welcome to check the following example: https://jsfiddle.net/flexmonster/egxc94yt/

Please let us know if the suggested approaches worked for you.

Best Regards,
Maksym

Hello, Fabrizio!

Hope you are doing well.
We are wondering if you had time to check the provided solutions.
Please let us know if they worked for you.

Best Regards,
Maksym

Hi, Fabrizio!

Thank you for your reply.

For dynamic data, the same functionality can be achieved by adjusting the customizeCell function. Since, in your scenario, the cell's member name may differ, you can remove the condition for data.label in the previously provided example. The remaining conditions for removing the expand/collapse icon should be similar to these:

data.hierarchy.uniqueName == "Data" && data.level === 0

This condition checks if the cell is a top-level field of the multilevel hierarchy. 

Also, since in G1 and G2 the values may change, we would suggest a more dynamic way to expand the first level instead of explicitly specifying expands in the report configuration. For instance, it is possible to use the getMembers() API call to retrieve and expand certain hierarchy levels dynamically. Please check the following example (setDrills() function, line 57): https://jsfiddle.net/flexmonster/yjzbuht3/

We hope this helps. Please let us know if you have any other questions.

Best Regards,
Maksym

Hi, Fabrizio!

Hope you are doing well.
Could you please let us know if the suggested approaches for expanding cells and removing the expand/collapse icons from certain hierarchy levels work for you?
Looking forward to hearing from you.

Kind Regards,
Maksym

Hi, Fabrizio!

Thank you for your feedback.
Our team is glad to hear that the suggested solution worked for you.
Please let us know if any other questions arise.

Best Regards,
Maksym