Happy Business Starts Here

Link Rate Plan Charge Tier and Account tables

Link Rate Plan Charge Tier and Account tables

It is not currently possible to join data from the Rate Plan Charge Tier table (where unit prices live) with date from the Account table (where human-readable account data lives) in the reporting tool. The closest approximation I can find is between Subscription.CreatorInvoiceOwnerID and Account.ID.

 

Are there plans to add the relationship between Rate Plan Charge Tier and Account in the reporting tool? This was discussed in the Reporting User Group at https://community.zuora.com/t5/Reporting-User-Group/Linking-the-Rate-Plan-Charge-to-the-Rate-Plan-Ch....

20 Comments
MK_STP
Tutor

@Thoeff have a look at the comment from @AmyLy 

We're staying very excited what changes are coming there.

jtvega
Tutor

@AmyLy Yessssss!!!!!

MK_STP
Tutor

@AmyLy can you tell us more about the future changes and possible data reportings?

AmyLy
Zuora Support Moderator

@MK_STP  - since things are in development right now, there is functionality that is still changing. That being said, we may be opening up for beta testing in the near future. If you're interested in potentially being one of these early testers, send me a message and we'll put you on an interest list. 

christopherduke
Savvy Scholar

bump

ll
Tutor
Tutor

Hi. Any news on when will this feature be available?

CKHarwood
Savvy Scholar

@AmyLy still up for beta testing when Zuora is ready.

AmyLy
Zuora Support Moderator

@CKHarwood Hello! Glad to hear from you.

 

We actually have rolled out Data Query (https://knowledgecenter.zuora.com/Central_Platform/Query/Data_Query) which uses SQL joins to bring in all those orphaned tables from before.

 

I would check out the Knowledge Center link above to get a general read-out on the feature and also this great Zuora University module (free once you sign up): https://university.zuora.com/zuora-platform-data-query?next=%2Fzuora-platform-data-query%2F496078

 

Happy testing!

 

ll
Tutor
Tutor

@AmyLy 

That's great and all and we are actually using that as a workaround.

But our general users are not savvy with technical lingo and would prefer to use the Reporting UI.

CKHarwood
Savvy Scholar

@AmyLy, Data Query looks fantastic!

 

Something I appreciate about your team's approach to making data available is that you tend to keep the reporting tools with lower learning curves in place whenever you release a more powerful reporting tool with a higher learning curve. I still recommend Data Sources to new coworkers as a way to learn Zuora's data model and build rough prototypes quickly before moving on to use Reporting. With my background in those tools, I knew exactly what I was looking at in Data Query even though I have not worked directly in Zuora for some time. I'll share this with the Zuora users on my team.