Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Creation of dynamic table, without the using of a column selector

Accepted answer
41
Views
7
Comments

Hello team,

I would like to create a dynamic table in which I can select dynamically the columns thare are in it. We created an analysis, in which we have a column selector, but this solution isn't an option for the customer, since it seems not so clear to utilize for a user. Is there a way to create a dynamic table with these characteristics?

Regards

Best Answers

  • True, and that's why I started by repeating that the column selector was the official solution for that need…

    Anything else done by hand would have some downsides, like the empty columns still there.

    You can of course write a javascript thing to get rid of the empty columns etc., but is it worth it? At what point are you stopping using product features and just start writing your own frontend if you go down that path?

    Everything is about find a balance between what is requested, what you get out of the box, what alternatives you can implement with more or less downsides. Not much more can be done.

  • [Deleted User]
    [Deleted User] Rank 7 - Analytics Coach

    Every self service analytics tool in 2024 works more or less the same. Even Excel requires a minimum of comprehension, skill, and training.

    I'm not saying "use Excel" but rather "even if they use Excel and don't know what they're doing they won't be happy".

    How about creating a minimum rights user with the rights to create basic DV Workbooks and train them?

Answers

  • [Deleted User]
    [Deleted User] Rank 7 - Analytics Coach

    If the usage of column selector is "Not clear to utilize for a user" then you have a different problem.

    In OAC you have DV which is the definition of self-service analytics in and of itself. In Answers you have column selectors. If those two capabilities are not what the user can utilize then the problem is user training. Not sure how you could make the process more "banal" or what the user expects there to be. Columns have to be selected in some way in order to be shown as a table or chart or whatever.

  • _vero_
    _vero_ Rank 4 - Community Specialist

    Hello,

    I fully agree, unfortunately during the presentation of our solution to the customer the use of the column selectors did not seem clear, even though it didn't seem that way to us. We were looking for a possible other solution to simulate a table with dynamic columns, which was not precisely the column selector or include/exclude columns.

  • Hi,

    a dynamic table in which I can select dynamically the columns that are in it

    a column selector, but this solution isn't an option for the customer

    That was the feature designed in the product to handle the case…

    Use a prompt to select the columns, then saving the value in a presentation variable and having the logic in the analysis to decide what to display.

    It's a static solution trying to look like dynamic (because in the end you need to decide in advance how many columns can be selected at best).

  • _vero_
    _vero_ Rank 4 - Community Specialist

    Hello,

    we actually tried the solution, however unlike the column selector it is not possible to somehow "hide" the unselected columns, for example by decreasing their size, therefore we discarded it since it would keep null rows where the column is not valued from the presentation variable.

  • _vero_
    _vero_ Rank 4 - Community Specialist

    Thanks everyone for the replies