Forum Discussion

Sarikap96's avatar
Sarikap96
New Contributor II
2 years ago

How to make the column names dynamic in BI-Viewer pivot or Grid

Hello,

I am facing a problem in making dynamic names for BI-viewer.

I have a data adapter with Command type as Cube view. I am using this adapter in BI-viewer. I want to make the column names similar in cube view. 

For example, in my scenario I have columns changing according to the time. 

but here it will show as Col0Value, Col1Value. As per cube view headers, Col0 is 2024M1 and Col1 is 2024M2 and this will change according to time updated for next periods. It will not be same every time.

How to get the same names as per cube view into BI-viewer column list. 

 

 

BI Viewer
  • JackLacava's avatar
    JackLacava
    Community Manager
    2 years ago

    Have you tried using the Command Type "Cube View MD" instead? It returns records in a more natural fashion, in my experience.

    • Mubarak_H's avatar
      Mubarak_H
      New Contributor II
      2 months ago

      Hello Jack,

      I'm encountering a similar problem with dynamic column names based on WFYear while using a SQL data adapter. When I modify the WFYear, an error occurs, It's because Bi Viewer may not be compatible with dynamic column names. Do you know of any potential solutions for this issue?

      I've noticed that we can pass parameters through the properties tab, but it appears that we can't utilize them for naming columns.

      I'd greatly appreciate any insights or suggestions you might have regarding this matter.

      Thank you for your assistance!