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 sim...
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!