Dynamic Column Layout

Options
Akkala Vamsi Krishna
Akkala Vamsi Krishna Active Partner
Advocate First Comment First Anniversary
edited July 2020 in Platform
Hi

Can we have a dynamic column Layout using Pager ?  (The columns of the Layout should change depending on the Pager entity selected)

Thanks,
Vamsi.

------------------------------
Vamsi Krishna
Associate Software Engineer
SIMBUS TECHNOLOGIES PRIVATE LIMITED
India
------------------------------
Tagged:

Answers

  • Brendan Broughton
    Brendan Broughton Active Partner
    Level 200: Leveraging Board for Business Insights Level 100: Foundations of Building in Board First Anniversary First Comment
    edited July 2020
    Options

    There's no inbuilt functionality for that, but depending on exactly what you need (are the columns entities or cubes?) you could use a combination of cubes and/or entities/relationships to make it work.

    We have developed something similar for a client, where depending on the site (which is applied as a screen selection) the columns that are hidden/visible in the dataview change.

    Can you provide any more details?

    ------------------------------
    Brendan
    bbroughton@bi5.com.au
    Australia
    ------------------------------
    -------------------------------------------
  • Akkala Vamsi Krishna
    Akkala Vamsi Krishna Active Partner
    Advocate First Comment First Anniversary
    edited July 2020
    Options
    The Columns are Entities. 

    Please find the details of the requirement:

    1. I have a pager with two entities Entity1 and Entity2.
    2. When I select Entity1 the layout should have columns Month, Store, Region, and when I select Entity2 the columns should be Month, Store, Brand.

    Please let me know if the above scenario can be achieved.

    ------------------------------
    Vamsi Krishna
    Associate Software Engineer
    SIMBUS TECHNOLOGIES PRIVATE LIMITED
    India
    ------------------------------
    -------------------------------------------
  • Helmut Heimann
    Helmut Heimann Employee
    March Badge of the Month February Badge of the Month Community Captain April Badge of the Month
    edited July 2020
    Options
    Hi @Vamsi Krishna,

    did you think about using the "Quick Layout Edit" function described here in our manual: https://www.boardmanual.com/Board_10.6_Release_Notes.htm

    Kind Regards,
    Helmut

    ------------------------------
    Helmut Heimann
    Senior Consultant
    Board Community
    Germany
    ------------------------------
    -------------------------------------------
  • Brendan Broughton
    Brendan Broughton Active Partner
    Level 200: Leveraging Board for Business Insights Level 100: Foundations of Building in Board First Anniversary First Comment
    edited July 2020
    Options
    HI Vamsi, Not quite sure what you're wanting to show still, as that'll give a lot of columns with multiples of each entity.  What is by row in the layout?

    Any chance you can paste a snip of the two desired dataviews in here to give a better idea?

    ------------------------------
    Brendan
    bbroughton@bi5.com.au
    Australia
    ------------------------------
    -------------------------------------------

Categories