Display Multiple Issuer Roles as Issuer Details Model Columns
Use System parameter #153, Minimize Rows in Issuer Report, in Issuer Role Type fields to display multiple issuer roles as columns in the Issuer Details model. Issuer Role Details fields are used to report the four types of issuer (Issuer, Parent, Domestic Ultimate Parent, and Global Ultimate Parent) supplied by the S&P Crosswalk issuer data service. Multiple Issuer Role Type fields in the Issuer Details model result in just a single table row per security when you set System Parameter 153 to minimize rows.
About Role Type Field Attributes
The Role Type field attribute can identify data for a direct issuer in any role. This is especially useful if you use S&P Crosswalk.
Role Type Field Attribute Example shows how to set up a Role Type field attribute for use in Data Mart Issuer Details or an OLAP report.
This example shows how the Role Type field simplifies issuer reporting when using the S&P Crosswalk data service. You can load CrossWalk data to Issuer Role Details, defining each of CrossWalk's four relationship levels as a role. This method creates a single row in an OLAP report or Data Mart Issuer Details for each security that CrossWalk covers. If you use this approach, you should not load CrossWalk data to the Issuer Relationship table, and you need not run the Issuer Relationship Builder Engine to produce the Issuer Relationship Summary table.
When using Bloomberg, putting a Role Type field attribute in an OLAP report or Data Mart Issuer Details returns the same data in that field's column for direct issuers of the security in all roles. For example, if a security has both an issuer and a guarantor, a Guarantor Name Role Type field would show that name on both the issuer row and the guarantor row. This facilitates reporting that selects just one row per security (for example, the issuer row) and needs all information to be on that row.
0 Comments