Apptio for All

 View Only

 Only show report component in DEV but hide in STG and PROD

Jump to  Best Answer
  • ApptioforAll
  • Reports
Apptio Community Member's profile image
Apptio Community Member posted Tue May 02, 2023 05:53 PM

I have a use case where a client would like to add html and/or slicers to reports that are only visible in Development but are hidden in Stage / Production. These notes/slicers are meant to provide reminders or necessary filtering for the TBMAs to tie out the reports to other sources of truth, which they would do in Development, but they do not want the slicers/notes to be visible in Stage and Production.

Using the eval() function for report component visibility to limit by Role will not suffice because when they are demoing these reports on calls, the notes/slicers would be visible. 

If anyone knows a formula that would return the environment, I could use that with eval function to set the visibility based on the environment. Thanks in advance for any help!


#ApptioforAll
#Reports
Jenny Franklin's profile image
Jenny Franklin posted Thu May 04, 2023 09:16 AM  Best Answer

A good idea came back from the internal channels: "While not a solution for the Stage/Prod use case, they could use the Visibility function to limit by role and ensure TBMAs have a unique role that other users don't.  The notes will show in Dev/Stage/Prod but only to the TBMAs."


#ApptioforAll
Apptio Community Member's profile image
Apptio Community Member posted Wed May 03, 2023 06:21 PM

Hi Christine,

not sure if this will work as I would have to wait for stage to calculate the formula. Maybe this might help?

=GetInfo(“project.isRealTimeCalculation”)

Regards Mark


#ApptioforAll
Guillermo Cuadrado's profile image
Guillermo Cuadrado posted Thu May 04, 2023 05:12 AM

I have always had trouble with the Visible section of the report, so I eventually gave up on it.
My experiments using @Mark Johnson's excellent tip are a bit contradictory:

I created a formula in a Formula pipeline step:
Are we in DEV=If(GetInfo("project.isRealTimeCalculation")="true","hidden","visible")    /* yes, it's the reverse logic, but bear with me... */
This yields "visible", which is NOT what I expected: we are in DEV and it should have returned "true"

I then unfolded the formula in two:
DEV==GetInfo("project.isRealTimeCalculation")                     /* Correctly returns "true" */
Are we in DEV=If(DEV="true","hidden","visible")                       /* Which is what you want */

I do not understand why the first try doesn't work. There might be something I'm not seeing.

I remember there was a thread in Community about this topic. I have found one about button visibility (link), and another one about the HTML component (link), but they're not exactly the same.

Maybe @Jenny Franklin can help.


#ApptioforAll
Jenny Franklin's profile image
Jenny Franklin posted Thu May 04, 2023 08:45 AM

Haven't seen anything like that - pitching to the folks internally to see what comes up - will keep y'all posted!


#ApptioforAll
Jenny Franklin's profile image
Jenny Franklin posted Thu May 04, 2023 09:56 AM

Received another idea: "Could add them to the report in dev and just not check in the changes. Makes editing harder but I don't think there's a way to surface the environment on the report dynamically unless we can somehow parse the URL in real time."


#ApptioforAll