Link Rate Plan Charge Tier and Account tables

[CKHarwood]

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....

[chris]

Yes, this is in the works as part of an upcoming release. We'll be releasing a new set of reporting capabilities in limited availability, and this will be included as part of that. Please stay tuned for more details on that.

[AmyLy]

@chris, this is fantastic news! I can't express how I'm feeling with mere words, so I'll leave the following:

[MKent525]

which data sources will this impact?

[MKent525]

Which data sources will this impact?

[CKHarwood]

@MKent525If I understand your question correctly, this would impact the Rate Plan Charge Tier data source.

[christopherduke]

Hey @chris—Is this still in the works? As of today RPCTier only rolls up as far as Subscription in both Reporting and Data Sources:

[jtvega]

Any update on this? We really needed this today and ended up having to manually pull data for our accounts. We just need to be able to pull a report on all our accounts and their base and overate unit rates! 

[MK_STP]

Any news on this topic so far? In 2017 the status has been set to "coming soon".

We need this link in reports and data sources very urgent.

[AmyLy]

@christopherduke / @jtvega  / @MK_STP  --

We're working on another method that will allow you to tie these tables (as well as numerous others) together. Look for an update around our Subscribed event for more details! (Check the page out to register!)