How can I create a BI Analysis that considers the credit limit of a customer at Party level
Summary: I need to create an analysis that considers the credit limit of a customer at Party level, all the subject areas that I found that have the credit limit are at account level which is not helpful because the setup is not at this level.
Content (required): I need to create an analysis that considers the credit limit of a customer at Party level, all the subject areas that I found that have the credit limit are at account level which is not helpful because the setup is not at this level.
I created a Data model pulling the information directly from the tables but it wasn't helpful since I need to add this information to a Dashboard, I also tried creating a custom Subject area but none of the current objects have the information that I need and creating a custom object wouldn't help since it wouldn't be linked to the Customer record.