Hi,

I was looking for a way to get the row count for each dataset and design it into a report. Below table with an example of what we need. Any thoughts are much appreciated. Thanks!

I think that I have a good way for you to be able to take care of this request.  What you are going to want to do is make a "Row Count" model and metric that you can report off of.  Below is going to be the steps that you want to follow:

1. You are going to have to add a "Row Count" column to each one of the data sets that you want in your report.  This count column is going to be a 'Numeric' and the formula will be just "=1".  This will allow the system to have a way to return the count you are looking for.  NOTE:  If you want to display a different number the just each possible row is a single count, then we would have to get a more advanced formula.  If that is the case, reply to the message and we will work on that as well.
2. You want to create a new Model and call it "Row Count".
3. Create a new Object for each of the Data set names that you want to report on.
4. Edit the driver on those Objects to be backed by "Row Count", which is the number that you created in set 1.
5. Once this is complete, you are going to want to create 1 additional Object and call it "Reported Row Count", which will sit above all of the rest of the created objects.
6. You are going to want to allocate all of the Objects created in step 3 to the "Reported Row Count" Object created in step 5.  NOTE: At this point, using the above example as a reference you should have a total of 4 Objects and the number at the Reported Row Count Object should be 16,611 for the month of January.
7. Create a new report with a blank table.
8. Set the Ad Hoc Config window to be backed by Reported Row Count.
9. Set the Value to be the "Drivers" into the Reported Row Count object.

This should get you on the right track to be able to create the requested report.

Thank you,

Doug Mahan

(top) Ribbon > Insert > Table > Freshness Table
Right-click new table > Edit Data Path

Change this:
customerName.com:Cost Transparency/
Reports/
.DateGoesHere/
CostModels/
Default/
.Datasets:/
.Summary

…to this:
customerName.com:Cost Transparency/

Reports/
.DateGoesHere/
CostModels/
Default/
.View:tab:Service Costing/
.Datasets:/
.Summary/
!NEWCOLUMN[{Count}=Row Count]/
!TREND[36,36,Name,Count]

Right-click Name column header in new table > Show/Hide columns > Select: All

Result:

@Jenny Goodwin - Hello...I am working in R12 and unable to figure out the "Insert" option on the top ribbon. May you please advise. Thank you.

This solution is for R11. There is not an "Insert" in R12 which is why you cannot find it.  Data Freshness options are located on the Upload step of the Transform Pipeline (see screen shot) but let me read through this post to see if there is actually an R12 equivalent. 

Thank you @Jenny Goodwin

Hi Jenny,

Is there a way to get timestamp of when data was last uploaded into a table?

Thanks

@Chris Davidson can you answer Zakria's question, "Is there a way to get timestamp of when data was last uploaded into a table?"  Or tag someone on your team who could answer for us if you don't have the time.  Thx!

Options to consider:

https://tbmcouncil.jiveon.com/thread/3001#comment-8358

https://tbmcouncil.jiveon.com/message/14824?commentID=14824#comment-14824