Apptio for All

I. Exordium

I'm sure many of you are having a hard time with the data processing related issues you encountered while building it. So what I would like to introduce this time is one method of data processing using editable tables. I'm glad if you can use it as a reference.


we have entered static data separated by commas in Possible Value .

It's like this.
#ApptioforAll
#ACE
#casestudy

Great work, @Ta Thi Minh Phuong!
A while ago I wrote the following (link) ​for a use case involving Editable Tables.

------------------------------
Regards, Guillermo
------------------------------

Original Message:
Sent: 12-14-2022 20:45
From: Ta Thi Minh Phuong
Subject: Resolving Incomplete Data Problems with Editable Tables

I. Exordium

I'm sure many of you are having a hard time with the data processing related issues you encountered while building it. So what I would like to introduce this time is one method of data processing using editable tables. I'm glad if you can use it as a reference.

II. Content

1. Procedure for creating an editable table that will be a place to save data

- Click New on the Home tag and select Editable Table

- Blank Table or Enriched Table here to create a table

- This time, I would like to bring in data from another table, so I will create an Enriched Table

- Enter the table name in Name and click the OK button

- Editable Table was created here

2. Procedure for creating a table in which data can be edited on the report side

- Select the " Report " tag from the menu bar and select Editable Table

- If necessary, drag and drop columns from Editable Table created in 1. to Included Columns

- You can now edit and add data on the report side

+ Editing data

Click on the item you want to edit and modify the data

Click the Save button and the data has been updated

+ Add new data

Click the Add Row button on the bottom left to insert a new row

Click the Save button and was able to add the new data

- Edited and added data could be saved in Editable Table

- By specifying a table in E ditable Table Steps , you can acquire data from E ditable table and use it in another table

- Here we were able to solve the problem when there was a data deficiency or a necessary change in data processing

3. What you especially want to share with the Editable table

How to get data from another table to Dropdow List in Editable Table .

we have entered static data separated by commas in Possible Value .

It's like this.

and on the screen

I ran into a problem here.
"Even if there was a change in the data, it occurred that it was not reflected in the Dropdown List data. "

And I was able to solve the problem by writing below.


After rewriting " % Reference Table Name/!LIMIT_COLUMNS[Column Name] " to Possible Value, I was able to get the data from the specified Reference Table Name.

Result is

*Thing to note here

Reference Table Name cannot specify an Editable Table .

III. Results

1. Outcome

I got the following results:

- Resolved missing data issue

- It was easy to do when it was necessary to edit or add data

2. Lessons learned

- I was able to learn that it is very important to process data correctly in order to display reports and allocate costs correctly

- Constantly learning to manage data efficiently

- Care about data accuracy



@Debbie Hagen
​​​

#ApptioforAll
#casestudy
#ACE

@Ed Hayman sharing this Case Study of a use case for Editable tables.  If you enjoy it, please give @Ta Thi Minh Phuong a "like".​​

------------------------------
Debra Hagen
Apptio
------------------------------

Original Message:
Sent: 12-15-2022 01:15
From: Guillermo Cuadrado
Subject: Resolving Incomplete Data Problems with Editable Tables

Great work, @Ta Thi Minh Phuong!
A while ago I wrote the following (link) ​for a use case involving Editable Tables.

------------------------------
Regards, Guillermo

Original Message:
Sent: 12-14-2022 20:45
From: Ta Thi Minh Phuong
Subject: Resolving Incomplete Data Problems with Editable Tables

I. Exordium

I'm sure many of you are having a hard time with the data processing related issues you encountered while building it. So what I would like to introduce this time is one method of data processing using editable tables. I'm glad if you can use it as a reference.

II. Content

1. Procedure for creating an editable table that will be a place to save data

- Click New on the Home tag and select Editable Table

- Blank Table or Enriched Table here to create a table

- This time, I would like to bring in data from another table, so I will create an Enriched Table

- Enter the table name in Name and click the OK button

- Editable Table was created here

2. Procedure for creating a table in which data can be edited on the report side

- Select the " Report " tag from the menu bar and select Editable Table

- If necessary, drag and drop columns from Editable Table created in 1. to Included Columns

- You can now edit and add data on the report side

+ Editing data

Click on the item you want to edit and modify the data

Click the Save button and the data has been updated

+ Add new data

Click the Add Row button on the bottom left to insert a new row

Click the Save button and was able to add the new data

- Edited and added data could be saved in Editable Table

- By specifying a table in E ditable Table Steps , you can acquire data from E ditable table and use it in another table

- Here we were able to solve the problem when there was a data deficiency or a necessary change in data processing

3. What you especially want to share with the Editable table

How to get data from another table to Dropdow List in Editable Table .

we have entered static data separated by commas in Possible Value .

It's like this.

and on the screen

I ran into a problem here.
"Even if there was a change in the data, it occurred that it was not reflected in the Dropdown List data. "

And I was able to solve the problem by writing below.


After rewriting " % Reference Table Name/!LIMIT_COLUMNS[Column Name] " to Possible Value, I was able to get the data from the specified Reference Table Name.

Result is

*Thing to note here

Reference Table Name cannot specify an Editable Table .

III. Results

1. Outcome

I got the following results:

- Resolved missing data issue

- It was easy to do when it was necessary to edit or add data

2. Lessons learned

- I was able to learn that it is very important to process data correctly in order to display reports and allocate costs correctly

- Constantly learning to manage data efficiently

- Care about data accuracy



@Debbie Hagen
​​​

#ACE
#casestudy
#ApptioforAll

@Ta Thi Minh Phuong

Great job on this use case using Editable Tables!​
Original Message:
Sent: 12-15-2022 09:41
From: Debra Hagen
Subject: Resolving Incomplete Data Problems with Editable Tables

@Ed Hayman sharing this Case Study of a use case for Editable tables.  If you enjoy it, please give @Ta Thi Minh Phuong a "like".​​

------------------------------
Debra Hagen
Apptio

Original Message:
Sent: 12-15-2022 01:15
From: Guillermo Cuadrado
Subject: Resolving Incomplete Data Problems with Editable Tables

Great work, @Ta Thi Minh Phuong!
A while ago I wrote the following (link) ​for a use case involving Editable Tables.

------------------------------
Regards, Guillermo

Original Message:
Sent: 12-14-2022 20:45
From: Ta Thi Minh Phuong
Subject: Resolving Incomplete Data Problems with Editable Tables

I. Exordium

I'm sure many of you are having a hard time with the data processing related issues you encountered while building it. So what I would like to introduce this time is one method of data processing using editable tables. I'm glad if you can use it as a reference.

II. Content

1. Procedure for creating an editable table that will be a place to save data

- Click New on the Home tag and select Editable Table

- Blank Table or Enriched Table here to create a table

- This time, I would like to bring in data from another table, so I will create an Enriched Table

- Enter the table name in Name and click the OK button

- Editable Table was created here

2. Procedure for creating a table in which data can be edited on the report side

- Select the " Report " tag from the menu bar and select Editable Table

- If necessary, drag and drop columns from Editable Table created in 1. to Included Columns

- You can now edit and add data on the report side

+ Editing data

Click on the item you want to edit and modify the data

Click the Save button and the data has been updated

+ Add new data

Click the Add Row button on the bottom left to insert a new row

Click the Save button and was able to add the new data

- Edited and added data could be saved in Editable Table

- By specifying a table in E ditable Table Steps , you can acquire data from E ditable table and use it in another table

- Here we were able to solve the problem when there was a data deficiency or a necessary change in data processing

3. What you especially want to share with the Editable table

How to get data from another table to Dropdow List in Editable Table .

we have entered static data separated by commas in Possible Value .

It's like this.

and on the screen

I ran into a problem here.
"Even if there was a change in the data, it occurred that it was not reflected in the Dropdown List data. "

And I was able to solve the problem by writing below.


After rewriting " % Reference Table Name/!LIMIT_COLUMNS[Column Name] " to Possible Value, I was able to get the data from the specified Reference Table Name.

Result is

*Thing to note here

Reference Table Name cannot specify an Editable Table .

III. Results

1. Outcome

I got the following results:

- Resolved missing data issue

- It was easy to do when it was necessary to edit or add data

2. Lessons learned

- I was able to learn that it is very important to process data correctly in order to display reports and allocate costs correctly

- Constantly learning to manage data efficiently

- Care about data accuracy



@Debbie Hagen
​​​

#casestudy
#ApptioforAll
#ACE

@Ed Hayman

Comments and likes make me very happy.
Thank you very much. ​

Original Message:
Sent: 12-15-2022 11:24
From: Ed Hayman
Subject: Resolving Incomplete Data Problems with Editable Tables

@Ta Thi Minh Phuong

Great job on this use case using Editable Tables!​
Original Message:
Sent: 12-15-2022 09:41
From: Debra Hagen
Subject: Resolving Incomplete Data Problems with Editable Tables

@Ed Hayman sharing this Case Study of a use case for Editable tables.  If you enjoy it, please give @Ta Thi Minh Phuong a "like".​​

------------------------------
Debra Hagen
Apptio

Original Message:
Sent: 12-15-2022 01:15
From: Guillermo Cuadrado
Subject: Resolving Incomplete Data Problems with Editable Tables

Great work, @Ta Thi Minh Phuong!
A while ago I wrote the following (link) ​for a use case involving Editable Tables.

------------------------------
Regards, Guillermo

Original Message:
Sent: 12-14-2022 20:45
From: Ta Thi Minh Phuong
Subject: Resolving Incomplete Data Problems with Editable Tables

I. Exordium

I'm sure many of you are having a hard time with the data processing related issues you encountered while building it. So what I would like to introduce this time is one method of data processing using editable tables. I'm glad if you can use it as a reference.

II. Content

1. Procedure for creating an editable table that will be a place to save data

- Click New on the Home tag and select Editable Table

- Blank Table or Enriched Table here to create a table

- This time, I would like to bring in data from another table, so I will create an Enriched Table

- Enter the table name in Name and click the OK button

- Editable Table was created here

2. Procedure for creating a table in which data can be edited on the report side

- Select the " Report " tag from the menu bar and select Editable Table

- If necessary, drag and drop columns from Editable Table created in 1. to Included Columns

- You can now edit and add data on the report side

+ Editing data

Click on the item you want to edit and modify the data

Click the Save button and the data has been updated

+ Add new data

Click the Add Row button on the bottom left to insert a new row

Click the Save button and was able to add the new data

- Edited and added data could be saved in Editable Table

- By specifying a table in E ditable Table Steps , you can acquire data from E ditable table and use it in another table

- Here we were able to solve the problem when there was a data deficiency or a necessary change in data processing

3. What you especially want to share with the Editable table

How to get data from another table to Dropdow List in Editable Table .

we have entered static data separated by commas in Possible Value .

It's like this.

and on the screen

I ran into a problem here.
"Even if there was a change in the data, it occurred that it was not reflected in the Dropdown List data. "

And I was able to solve the problem by writing below.


After rewriting " % Reference Table Name/!LIMIT_COLUMNS[Column Name] " to Possible Value, I was able to get the data from the specified Reference Table Name.

Result is

*Thing to note here

Reference Table Name cannot specify an Editable Table .

III. Results

1. Outcome

I got the following results:

- Resolved missing data issue

- It was easy to do when it was necessary to edit or add data

2. Lessons learned

- I was able to learn that it is very important to process data correctly in order to display reports and allocate costs correctly

- Constantly learning to manage data efficiently

- Care about data accuracy



@Debbie Hagen
​​​

#ApptioforAll
#casestudy
#ACE

@Debbie Hagen

Thank you from the bottom of my heart.
I would like to continue to do my best.​

Original Message:
Sent: 12-15-2022 09:41
From: Debra Hagen
Subject: Resolving Incomplete Data Problems with Editable Tables

@Ed Hayman sharing this Case Study of a use case for Editable tables.  If you enjoy it, please give @Ta Thi Minh Phuong a "like".​​

------------------------------
Debra Hagen
Apptio

Original Message:
Sent: 12-15-2022 01:15
From: Guillermo Cuadrado
Subject: Resolving Incomplete Data Problems with Editable Tables

Great work, @Ta Thi Minh Phuong!
A while ago I wrote the following (link) ​for a use case involving Editable Tables.

------------------------------
Regards, Guillermo

Original Message:
Sent: 12-14-2022 20:45
From: Ta Thi Minh Phuong
Subject: Resolving Incomplete Data Problems with Editable Tables

I. Exordium

I'm sure many of you are having a hard time with the data processing related issues you encountered while building it. So what I would like to introduce this time is one method of data processing using editable tables. I'm glad if you can use it as a reference.

II. Content

1. Procedure for creating an editable table that will be a place to save data

- Click New on the Home tag and select Editable Table

- Blank Table or Enriched Table here to create a table

- This time, I would like to bring in data from another table, so I will create an Enriched Table

- Enter the table name in Name and click the OK button

- Editable Table was created here

2. Procedure for creating a table in which data can be edited on the report side

- Select the " Report " tag from the menu bar and select Editable Table

- If necessary, drag and drop columns from Editable Table created in 1. to Included Columns

- You can now edit and add data on the report side

+ Editing data

Click on the item you want to edit and modify the data

Click the Save button and the data has been updated

+ Add new data

Click the Add Row button on the bottom left to insert a new row

Click the Save button and was able to add the new data

- Edited and added data could be saved in Editable Table

- By specifying a table in E ditable Table Steps , you can acquire data from E ditable table and use it in another table

- Here we were able to solve the problem when there was a data deficiency or a necessary change in data processing

3. What you especially want to share with the Editable table

How to get data from another table to Dropdow List in Editable Table .

we have entered static data separated by commas in Possible Value .

It's like this.

and on the screen

I ran into a problem here.
"Even if there was a change in the data, it occurred that it was not reflected in the Dropdown List data. "

And I was able to solve the problem by writing below.


After rewriting " % Reference Table Name/!LIMIT_COLUMNS[Column Name] " to Possible Value, I was able to get the data from the specified Reference Table Name.

Result is

*Thing to note here

Reference Table Name cannot specify an Editable Table .

III. Results

1. Outcome

I got the following results:

- Resolved missing data issue

- It was easy to do when it was necessary to edit or add data

2. Lessons learned

- I was able to learn that it is very important to process data correctly in order to display reports and allocate costs correctly

- Constantly learning to manage data efficiently

- Care about data accuracy



@Debbie Hagen
​​​

#casestudy
#ACE
#ApptioforAll

@Guillermo Cuadrado

Thank you for sharing the information.
I would like to refer to.​

Original Message:
Sent: 12-15-2022 01:15
From: Guillermo Cuadrado
Subject: Resolving Incomplete Data Problems with Editable Tables

Great work, @Ta Thi Minh Phuong!
A while ago I wrote the following (link) ​for a use case involving Editable Tables.

------------------------------
Regards, Guillermo

Original Message:
Sent: 12-14-2022 20:45
From: Ta Thi Minh Phuong
Subject: Resolving Incomplete Data Problems with Editable Tables

I. Exordium

I'm sure many of you are having a hard time with the data processing related issues you encountered while building it. So what I would like to introduce this time is one method of data processing using editable tables. I'm glad if you can use it as a reference.

II. Content

1. Procedure for creating an editable table that will be a place to save data

- Click New on the Home tag and select Editable Table

- Blank Table or Enriched Table here to create a table

- This time, I would like to bring in data from another table, so I will create an Enriched Table

- Enter the table name in Name and click the OK button

- Editable Table was created here

2. Procedure for creating a table in which data can be edited on the report side

- Select the " Report " tag from the menu bar and select Editable Table

- If necessary, drag and drop columns from Editable Table created in 1. to Included Columns

- You can now edit and add data on the report side

+ Editing data

Click on the item you want to edit and modify the data

Click the Save button and the data has been updated

+ Add new data

Click the Add Row button on the bottom left to insert a new row

Click the Save button and was able to add the new data

- Edited and added data could be saved in Editable Table

- By specifying a table in E ditable Table Steps , you can acquire data from E ditable table and use it in another table

- Here we were able to solve the problem when there was a data deficiency or a necessary change in data processing

3. What you especially want to share with the Editable table

How to get data from another table to Dropdow List in Editable Table .

we have entered static data separated by commas in Possible Value .

It's like this.

and on the screen

I ran into a problem here.
"Even if there was a change in the data, it occurred that it was not reflected in the Dropdown List data. "

And I was able to solve the problem by writing below.


After rewriting " % Reference Table Name/!LIMIT_COLUMNS[Column Name] " to Possible Value, I was able to get the data from the specified Reference Table Name.

Result is

*Thing to note here

Reference Table Name cannot specify an Editable Table .

III. Results

1. Outcome

I got the following results:

- Resolved missing data issue

- It was easy to do when it was necessary to edit or add data

2. Lessons learned

- I was able to learn that it is very important to process data correctly in order to display reports and allocate costs correctly

- Constantly learning to manage data efficiently

- Care about data accuracy



@Debbie Hagen
​​​

#ApptioforAll
#ACE
#casestudy

Good job. ^^
Original Message:
Sent: 12-14-2022 20:45
From: Ta Thi Minh Phuong
Subject: Resolving Incomplete Data Problems with Editable Tables

I. Exordium

I'm sure many of you are having a hard time with the data processing related issues you encountered while building it. So what I would like to introduce this time is one method of data processing using editable tables. I'm glad if you can use it as a reference.

II. Content

1. Procedure for creating an editable table that will be a place to save data

- Click New on the Home tag and select Editable Table

- Blank Table or Enriched Table here to create a table

- This time, I would like to bring in data from another table, so I will create an Enriched Table

- Enter the table name in Name and click the OK button

- Editable Table was created here

2. Procedure for creating a table in which data can be edited on the report side

- Select the " Report " tag from the menu bar and select Editable Table

- If necessary, drag and drop columns from Editable Table created in 1. to Included Columns

- You can now edit and add data on the report side

+ Editing data

Click on the item you want to edit and modify the data

Click the Save button and the data has been updated

+ Add new data

Click the Add Row button on the bottom left to insert a new row

Click the Save button and was able to add the new data

- Edited and added data could be saved in Editable Table

- By specifying a table in E ditable Table Steps , you can acquire data from E ditable table and use it in another table

- Here we were able to solve the problem when there was a data deficiency or a necessary change in data processing

3. What you especially want to share with the Editable table

How to get data from another table to Dropdow List in Editable Table .

we have entered static data separated by commas in Possible Value .

It's like this.

and on the screen

I ran into a problem here.
"Even if there was a change in the data, it occurred that it was not reflected in the Dropdown List data. "

And I was able to solve the problem by writing below.


After rewriting " % Reference Table Name/!LIMIT_COLUMNS[Column Name] " to Possible Value, I was able to get the data from the specified Reference Table Name.

Result is

*Thing to note here

Reference Table Name cannot specify an Editable Table .

III. Results

1. Outcome

I got the following results:

- Resolved missing data issue

- It was easy to do when it was necessary to edit or add data

2. Lessons learned

- I was able to learn that it is very important to process data correctly in order to display reports and allocate costs correctly

- Constantly learning to manage data efficiently

- Care about data accuracy



@Debbie Hagen
​​​

#casestudy
#ACE
#ApptioforAll