Oracle Analytics Cloud and Server

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

Dynamic columns in Excel Template

82
Views
5
Comments
PabloArro
PabloArro Rank 1 - Community Starter

Hi all,

Is there something simillar to "for-each@cell" in excel template? In order to make dynamic columns like i can do with rtf template but in this case with an excel template ?

Thanks in advance!!

Pablo.-

Tagged:

Comments

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    For Answers / OBI / OAS? No. That's the opposite of what these tools do.

    Bring data INTO the system and use it properly. Don't dump it out of the system into a joke of an uncontroled, glorified notepad like Excel where there is zero governance, control or security.

  • PabloArro
    PabloArro Rank 1 - Community Starter

    That was the user's request and i am not the functional consultant. I'm just a developer trying to do some magic with the given requirement. You could have said "this can't be possible" to my question and it would have been enough.

    Regards,

    Pablo.-

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    I could have, but then the next question is "can we make it possible".

    Your job desscription may not literally and in letter say "functional consultant", but as a subject matter expert it falls into your domain to educate.

    The ability to select columns of data you want is called "self service" and is an integral part of analytic since Answers exists as that is what Answers does.

    "User requests" are most often based on a reluctance to change their ingrained ways and hence waste invested money, work and effort. What that ends up with is .... the next product your employer will buy where they will do the same thing in green. And then in blue.

    Making your organization better at doing things and utilizing their investments is in the best interest of everybody. Be they developer or functional or backoffice or customer facing.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Also, the forum is a place for all participants to benefit. Marking responses helps others who have similar issues or questions. Please make the forum a place for all to benefit, not just the people asking the question in the first place.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    @PabloArro if your question has been answered please close the thread so that other forum users may benefit as well. The forum is geared towards providing solutions to all participants, not just the original user asking the question.