Dynamic Column Layout

Akkala Vamsi Krishna
Akkala Vamsi Krishna Active Partner
Second Anniversary Advocate First Comment
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
    Third Anniversary 100 Comments 100 Up Votes 25 Likes
    edited July 2020

    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
    Second Anniversary Advocate First Comment
    edited July 2020
    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, Community Captain
    500 Comments 250 Likes Fourth Anniversary 25 Answers
    edited July 2020
    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
    Third Anniversary 100 Comments 100 Up Votes 25 Likes
    edited July 2020
    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
    ------------------------------
    -------------------------------------------