Platform

Hello,

We have created a new custom table in TBM studio to capture some data that we wanted to report on in Apptio BI. However, even after checking in and promoting that table to production, we are not able to add that table into Apptio BI using Data Source Management. The table and it's fields do not show up at all in the Data Configuration screen. Can someone help?

Does that table have a model step in TBM Studio?

Hello,

We have created a new custom table in TBM studio to capture some data that we wanted to report on in Apptio BI. However, even after checking in and promoting that table to production, we are not able to add that table into Apptio BI using Data Source Management. The table and it's fields do not show up at all in the Data Configuration screen. Can someone help?

@Jenny Franklin beat me by a day or two 😎😎😎

The same way you need a model step to report inside TBM Studio, you'll need it for Apptio BI.

Does that table have a model step in TBM Studio?

Hello,

We have created a new custom table in TBM studio to capture some data that we wanted to report on in Apptio BI. However, even after checking in and promoting that table to production, we are not able to add that table into Apptio BI using Data Source Management. The table and it's fields do not show up at all in the Data Configuration screen. Can someone help?

Hello,

Yes, we have created the model step. However, I checked TBM studio again now based on your question and I see some error/warning in our model step. Can you please review the attachment and let me know if this is what is causing the issue? If yes, how do we resolve this error/warning?

@Jenny Franklin beat me by a day or two 😎😎😎

The same way you need a model step to report inside TBM Studio, you'll need it for Apptio BI.

Does that table have a model step in TBM Studio?

Hello,

We have created a new custom table in TBM studio to capture some data that we wanted to report on in Apptio BI. However, even after checking in and promoting that table to production, we are not able to add that table into Apptio BI using Data Source Management. The table and it's fields do not show up at all in the Data Configuration screen. Can someone help?

Pls ignore that error, I was not in the right month which had the data. When I selected the right month having the data , I do not see any error in the model step. 

Hello,

Yes, we have created the model step. However, I checked TBM studio again now based on your question and I see some error/warning in our model step. Can you please review the attachment and let me know if this is what is causing the issue? If yes, how do we resolve this error/warning?

@Jenny Franklin beat me by a day or two 😎😎😎

The same way you need a model step to report inside TBM Studio, you'll need it for Apptio BI.

Does that table have a model step in TBM Studio?

Hello,

We have created a new custom table in TBM studio to capture some data that we wanted to report on in Apptio BI. However, even after checking in and promoting that table to production, we are not able to add that table into Apptio BI using Data Source Management. The table and it's fields do not show up at all in the Data Configuration screen. Can someone help?

This is a tricky problem, @Ashwin Jain. You seem to have defined in the upload step something other than "Ad-hoc updates", e.g.:

That deletes the Date column and you get the model step error. As we cannot set the Date Range in Apptio BI, it'll default to the current calendar month, and it'll find the model error and ignore the object.

A couple of suggestions:

1. Change the update method to Ad-hoc updates
2. Promote to PRD
3. See if the object is available in Apptio BI
4. Configure the report as desired
5. Revert the change of the update method (not sure if this will work)

Alternative: avoid step 5.

Good luck!

Pls ignore that error, I was not in the right month which had the data. When I selected the right month having the data , I do not see any error in the model step. 

Hello,

Yes, we have created the model step. However, I checked TBM studio again now based on your question and I see some error/warning in our model step. Can you please review the attachment and let me know if this is what is causing the issue? If yes, how do we resolve this error/warning?

@Jenny Franklin beat me by a day or two 😎😎😎

The same way you need a model step to report inside TBM Studio, you'll need it for Apptio BI.

Does that table have a model step in TBM Studio?

Hello,

We have created a new custom table in TBM studio to capture some data that we wanted to report on in Apptio BI. However, even after checking in and promoting that table to production, we are not able to add that table into Apptio BI using Data Source Management. The table and it's fields do not show up at all in the Data Configuration screen. Can someone help?

Thanks Guillermo. I tried the steps you suggested, but still do not see the object (table) available in Apptio BI.

Here's a screenshot of the upload method:

This is a tricky problem, @Ashwin Jain. You seem to have defined in the upload step something other than "Ad-hoc updates", e.g.:

That deletes the Date column and you get the model step error. As we cannot set the Date Range in Apptio BI, it'll default to the current calendar month, and it'll find the model error and ignore the object.

A couple of suggestions:

1. Change the update method to Ad-hoc updates
2. Promote to PRD
3. See if the object is available in Apptio BI
4. Configure the report as desired
5. Revert the change of the update method (not sure if this will work)

Alternative: avoid step 5.

Good luck!

Pls ignore that error, I was not in the right month which had the data. When I selected the right month having the data , I do not see any error in the model step. 

Hello,

Yes, we have created the model step. However, I checked TBM studio again now based on your question and I see some error/warning in our model step. Can you please review the attachment and let me know if this is what is causing the issue? If yes, how do we resolve this error/warning?

@Jenny Franklin beat me by a day or two 😎😎😎

The same way you need a model step to report inside TBM Studio, you'll need it for Apptio BI.

Does that table have a model step in TBM Studio?

Hello,

We have created a new custom table in TBM studio to capture some data that we wanted to report on in Apptio BI. However, even after checking in and promoting that table to production, we are not able to add that table into Apptio BI using Data Source Management. The table and it's fields do not show up at all in the Data Configuration screen. Can someone help?

Did you promote to PRD?

Thanks Guillermo. I tried the steps you suggested, but still do not see the object (table) available in Apptio BI.

Here's a screenshot of the upload method:

This is a tricky problem, @Ashwin Jain. You seem to have defined in the upload step something other than "Ad-hoc updates", e.g.:

That deletes the Date column and you get the model step error. As we cannot set the Date Range in Apptio BI, it'll default to the current calendar month, and it'll find the model error and ignore the object.

A couple of suggestions:

1. Change the update method to Ad-hoc updates
2. Promote to PRD
3. See if the object is available in Apptio BI
4. Configure the report as desired
5. Revert the change of the update method (not sure if this will work)

Alternative: avoid step 5.

Good luck!

Pls ignore that error, I was not in the right month which had the data. When I selected the right month having the data , I do not see any error in the model step. 

Hello,

Yes, we have created the model step. However, I checked TBM studio again now based on your question and I see some error/warning in our model step. Can you please review the attachment and let me know if this is what is causing the issue? If yes, how do we resolve this error/warning?

@Jenny Franklin beat me by a day or two 😎😎😎

The same way you need a model step to report inside TBM Studio, you'll need it for Apptio BI.

Does that table have a model step in TBM Studio?

Hello,

We have created a new custom table in TBM studio to capture some data that we wanted to report on in Apptio BI. However, even after checking in and promoting that table to production, we are not able to add that table into Apptio BI using Data Source Management. The table and it's fields do not show up at all in the Data Configuration screen. Can someone help?