Hello,

Has anyone tried to call multiple Copytable functions within one report button?  I have two reports that each have their separate button to copy data into a dataset.  Both are model reports, so when I run the first button, the second reports values change.  I want to capture the values from each report prior to running either of the button functions and have those values loaded into each data sets.  My thought is by running both functions from one button, each function will call and copy the data before the model refreshes. 

Thanks,

Jeff

Hi Jeffrey,

You sure can call mulitple copytable functions in a single script, I am just worried the result will still change the behavior of the model, and cause the results to be different from what you expect.

You can literally just create extra copy table functions in the same button script, or you can create subroutines that pass through parameters, depending on how you want to construct the script.

Are you looking to capture the data to 2 datasets for reporting purposes, or are you encountering an issue where the backing data you are copying is changing (due to the model calc) and the resultant data is bad?

Seth

Seth,

I am encountering an issue where the backing data I am copying is changing (due to the model calc) and the resultant data is bad.  I was hoping that having the copytables both contained in same button would work (I figured it was a long shot).

I was not able to get the two copytable functions to work with in the same button.  How would they be separated?  Could you explain the right way to do this even if it will not solve my issue above.

Thanks,

Jeff

Hi Jeff,

You should be able to simply list two copytable functions after another in the script to execute. I find it useful copying and pasting into notepad or any other text editor, as the text character constraints inside the button action can be challenging when editing longer script strings.

Here is an example of two copy table functions that are executed as part of a script in order to bring data into two different datasets (IFRS_CM_DataSet1 and IFRS_CM_DataSet2) in the current project, this assumes you have knowledge of Apptio data paths and how copytable functions are constructed.

--

CopyTable("<%=DomainName()%>:<%=ProjectName()%>/Data/<%=CurrentDate("MMMM:yyyy")%>/APPTIO_IFRS1_CMD/.RawTable/","<%=DomainName()%>:<%=ProjectName()%>","IFRS_CM_DataSet1","January:2014")

CopyTable("<%=DomainName()%>:<%=ProjectName()%>/Data/<%=CurrentDate("MMMM:yyyy")%>/APPTIO_IFRS1_FYD/.RawTable/","<%=DomainName()%>:<%=ProjectName()%>","IFRS_CM_DataSet2","January:2014")

--

Hope this helps!

Seth