{ "projectModelView": { "model": { "projectModel": { "datasets": [ { "dataset": { "identifier": "dataset.bookingsactual", "title": "Bookings Actual", "anchor": { "attribute": { "identifier": "attr.bookingsactual.factsof", "title": "Records of Bookings Actual", "folder": "Bookings Actual" } }, "attributes": [ { "attribute": { "identifier": "attr.bookingsactual.localcurrency", "title": "Local Currency", "folder": "Bookings Actual", "labels": [ { "label": { "identifier": "label.bookingsactual.localcurrency", "title": "Local Currency", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.product.sku", "title": "Sku", "folder": "Bookings Actual", "labels": [ { "label": { "identifier": "label.product.sku", "title": "Sku", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.product.sku" } }, { "attribute": { "identifier": "attr.bookingsactual.datasource", "title": "Data Source", "folder": "Bookings Actual", "labels": [ { "label": { "identifier": "label.bookingsactual.datasource", "title": "Data Source", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.bookingsactual.bookingid", "title": "Booking Id", "folder": "Bookings Actual", "labels": [ { "label": { "identifier": "label.bookingsactual.bookingid", "title": "Booking Id", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.bookingsactual.version", "title": "BSA Version", "folder": "Bookings Actual", "labels": [ { "label": { "identifier": "label.bookingsactual.version", "title": "BSA Version", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.bookingsactual.version" } }, { "attribute": { "identifier": "attr.enduser.endusercustomercustomername", "title": "End User Customer Name", "folder": "Bookings Actual", "labels": [ { "label": { "identifier": "label.enduser.endusercustomercustomername", "title": "End User Customer Name", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.bookingsactual.ordertype", "title": "Order Type", "folder": "Bookings Actual", "labels": [ { "label": { "identifier": "label.bookingsactual.ordertype", "title": "Order Type", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.bookingsactual.customerponumber", "title": "Customer PO Number", "folder": "Bookings Actual", "labels": [ { "label": { "identifier": "label.bookingsactual.customerponumber", "title": "Customer PO Number", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.bookingsactual.newrenewalmaintenance", "title": "New Renewal Maintenance", "folder": "Bookings Actual", "labels": [ { "label": { "identifier": "label.bookingsactual.newrenewalmaintenance", "title": "New Renewal Maintenance", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.bookingsactual.maintenancerenewalstatus", "title": "Maintenance Renewal Status", "folder": "Bookings Actual", "labels": [ { "label": { "identifier": "label.bookingsactual.maintenancerenewalstatus", "title": "Maintenance Renewal Status", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.bookingsactual.meteredservicetype", "title": "Metered Service Type", "folder": "Bookings Actual", "labels": [ { "label": { "identifier": "label.bookingsactual.meteredservicetype", "title": "Metered Service Type", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.bookingsactual.enduserregion", "title": "End User Region", "folder": "Bookings Actual", "labels": [ { "label": { "identifier": "label.bookingsactual.enduserregion", "title": "End User Region", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.bookingsactual.skudescription", "title": "Sku Description", "folder": "Bookings Actual", "labels": [ { "label": { "identifier": "label.bookingsactual.skudescription", "title": "Sku Description", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.bookingsactual.endusercountry", "title": "End User Country", "folder": "Bookings Actual", "labels": [ { "label": { "identifier": "label.bookingsactual.endusercountry", "title": "End User Country", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.bookingsactual.glregioncode", "title": "GL Region Code", "folder": "Bookings Actual", "labels": [ { "label": { "identifier": "label.bookingsactual.glregioncode", "title": "GL Region Code", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } } ], "facts": [ { "fact": { "identifier": "fact.bookingsactual.bookingsamount", "title": "Bookings Amount Local", "folder": "Bookings Actual", "dataType": "DECIMAL(15,5)" } }, { "fact": { "identifier": "fact.bookingsactual.bookingsamountusd", "title": "Bookings Amount USD", "folder": "Bookings Actual", "dataType": "DECIMAL(15,5)" } }, { "fact": { "identifier": "fact.bookingsactual.bookingsunits", "title": "Bookings Units", "folder": "Bookings Actual", "dataType": "DECIMAL(12,2)" } } ], "references": [ "dataset.productfamily", "dataset.revenuetype", "dataset.shiptocustomerregion", "dataset.shiptocustomer", "dataset.billtocustomer", "dataset.hierarchy", "I_FDATE_DIM.fiscalOct1_dataset.dt", "dealtermactivation", "dealtermexpiration", "I_FISCAL_DATE_CSD.nuance", "I_FISCAL_DATE_SSD.nuance" ] } }, { "dataset": { "identifier": "dataset.bookingsforcact", "title": "Bookings Forecast", "anchor": { "attribute": { "identifier": "attr.bookingsforcact.factsof", "title": "Records of Bookings Forecast", "folder": "Bookings Forecast" } }, "attributes": [ { "attribute": { "identifier": "attr.bookingsforcact.comnpany", "title": "Company", "folder": "Bookings Forecast", "labels": [ { "label": { "identifier": "label.bookingsforcact.comnpany", "title": "Company", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.bookingsforcact.version", "title": "Version", "folder": "Bookings Forecast", "labels": [ { "label": { "identifier": "label.bookingsforcact.version", "title": "Version", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.bookingsforcact.department", "title": "Department", "folder": "Bookings Forecast", "labels": [ { "label": { "identifier": "label.bookingsforcact.department", "title": "Department", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.bookingsforcact.type", "title": "Type", "folder": "Bookings Forecast", "labels": [ { "label": { "identifier": "label.bookingsforcact.type", "title": "Type", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } } ], "facts": [ { "fact": { "identifier": "fact.bookingsforcact.bookingsforecastusd", "title": "Bookings Forecast USD", "folder": "Bookings Forecast", "dataType": "DECIMAL(12,2)" } } ], "references": [ "dataset.productfamily", "dataset.revenuetype", "dataset.shiptocustomerregion", "dataset.shiptocustomerregion1", "I_FDATE_DIM.fiscalOct1_dataset.dt" ] } }, { "dataset": { "identifier": "dataset.productfamily", "title": "Product Family", "anchor": { "attribute": { "identifier": "attr.productfamily.productfamilyname", "title": "Product Family #", "folder": "Product Family", "labels": [ { "label": { "identifier": "label.productfamily.productfamilyname", "title": "Product Family #", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, "attributes": [ { "attribute": { "identifier": "attr.product.prodgen2", "title": "LOB", "folder": "Product Family", "labels": [ { "label": { "identifier": "label.product.prodgen2", "title": "LOB", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.product.prodgen2" } }, { "attribute": { "identifier": "attr.product.prodgen5", "title": "Prod Gen5", "folder": "Product Family", "labels": [ { "label": { "identifier": "label.product.prodgen5", "title": "Prod Gen5", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.product.prodgen5" } }, { "attribute": { "identifier": "attr.product.prodgen6", "title": "Prod Gen6", "folder": "Product Family", "labels": [ { "label": { "identifier": "label.product.prodgen6", "title": "Prod Gen6", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.product.prodgen6" } }, { "attribute": { "identifier": "attr.product.prodgen7", "title": "Prod Gen7", "folder": "Product Family", "labels": [ { "label": { "identifier": "label.product.prodgen7", "title": "Prod Gen7", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.product.prodgen7" } }, { "attribute": { "identifier": "attr.product.prodgen8", "title": "Prod Gen8", "folder": "Product Family", "labels": [ { "label": { "identifier": "label.product.prodgen8", "title": "Prod Gen8", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.product.prodgen8" } }, { "attribute": { "identifier": "attr.product.businesssegments", "title": "Division", "folder": "Product Family", "labels": [ { "label": { "identifier": "label.product.businesssegments", "title": "Division", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } } ] } }, { "dataset": { "identifier": "dataset.revenuetype", "title": "Revenue Type", "anchor": { "attribute": { "identifier": "attr.revenuetype.revenueaccount", "title": "Revenue Account", "folder": "Revenue Type", "labels": [ { "label": { "identifier": "label.revenuetype.revenueaccount", "title": "Revenue Account", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, "attributes": [ { "attribute": { "identifier": "attr.revenuetype.revenueaccountname", "title": "Revenue Account Name", "folder": "Revenue Type", "labels": [ { "label": { "identifier": "label.revenuetype.revenueaccountname", "title": "Revenue Account Name", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.revenuetype.accountrollup1", "title": "Booking Type", "folder": "Revenue Type", "labels": [ { "label": { "identifier": "label.revenuetype.accountrollup1", "title": "Booking Type", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.revenuetype.accountrollup1" } }, { "attribute": { "identifier": "attr.revenuetype.accountrollup2", "title": "Booking Type Detail", "folder": "Revenue Type", "labels": [ { "label": { "identifier": "label.revenuetype.accountrollup2", "title": "Booking Type Detail", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.revenuetype.accountrollup2" } } ] } }, { "dataset": { "identifier": "dataset.shiptocustomerregion", "title": "Ship to Customer Region", "anchor": { "attribute": { "identifier": "attr.shiptocustomer.shiptocustomerregion", "title": "Ship To Customer Region", "folder": "Ship to Customer Region", "labels": [ { "label": { "identifier": "label.shiptocustomer.shiptocustomerregion", "title": "Ship To Customer Region", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } } } }, { "dataset": { "identifier": "dataset.shiptocustomerregion1", "title": "Bill to Customer Region", "anchor": { "attribute": { "identifier": "attr.shiptocustomer.shiptocustomerregion1", "title": "Bill To Customer Region", "folder": "Bill to Customer Region", "labels": [ { "label": { "identifier": "label.shiptocustomer.shiptocustomerregion1", "title": "Bill To Customer Region", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } } } }, { "dataset": { "identifier": "dataset.shiptocustomer", "title": "Ship to Customer", "anchor": { "attribute": { "identifier": "attr.shiptocustomer.shiptositeid", "title": "Ship To Site Id", "folder": "Ship to Customer", "labels": [ { "label": { "identifier": "label.shiptocustomer.shiptositeid", "title": "Ship To Site Id", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, "attributes": [ { "attribute": { "identifier": "attr.shiptocustomer.shiptoaddress1", "title": "Ship To Address1", "folder": "Ship to Customer", "labels": [ { "label": { "identifier": "label.shiptocustomer.shiptoaddress1", "title": "Ship To Address1", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.shiptocustomer.shiptoaddress2", "title": "Ship To Address2", "folder": "Ship to Customer", "labels": [ { "label": { "identifier": "label.shiptocustomer.shiptoaddress2", "title": "Ship To Address2", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.shiptocustomer.shiptoaddress3", "title": "Ship To Address3", "folder": "Ship to Customer", "labels": [ { "label": { "identifier": "label.shiptocustomer.shiptoaddress3", "title": "Ship To Address3", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.shiptocustomer.shiptocity", "title": "Ship To City", "folder": "Ship to Customer", "labels": [ { "label": { "identifier": "label.shiptocustomer.shiptocity", "title": "Ship To City", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.shiptocustomer.shiptostate", "title": "Ship To State", "folder": "Ship to Customer", "labels": [ { "label": { "identifier": "label.shiptocustomer.shiptostate", "title": "Ship To State", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.shiptocustomer.shiptocounty", "title": "Ship To County", "folder": "Ship to Customer", "labels": [ { "label": { "identifier": "label.shiptocustomer.shiptocounty", "title": "Ship To County", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.shiptocustomer.shiptocountry", "title": "Ship To Country", "folder": "Ship to Customer", "labels": [ { "label": { "identifier": "label.shiptocustomer.shiptocountry", "title": "Ship To Country", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.shiptocustomer.shiptoprovince", "title": "Ship To Province", "folder": "Ship to Customer", "labels": [ { "label": { "identifier": "label.shiptocustomer.shiptoprovince", "title": "Ship To Province", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.shiptocustomer.shiptopostalcode", "title": "Ship To Postal Code", "folder": "Ship to Customer", "labels": [ { "label": { "identifier": "label.shiptocustomer.shiptopostalcode", "title": "Ship To Postal Code", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.shiptocustomer.shiptocustomername", "title": "Ship To Customer Name", "folder": "Ship to Customer", "labels": [ { "label": { "identifier": "label.shiptocustomer.shiptocustomername", "title": "Ship To Customer Name", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.shiptocustomer.shiptocustomernumber", "title": "Ship To Customer Number", "folder": "Ship to Customer", "labels": [ { "label": { "identifier": "label.shiptocustomer.shiptocustomernumber", "title": "Ship To Customer Number", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.shiptocustomer.shiptoglobalcustomerid", "title": "Ship To Global Customer Id", "folder": "Ship to Customer", "labels": [ { "label": { "identifier": "label.shiptocustomer.shiptoglobalcustomerid", "title": "Ship To Global Customer Id", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.shiptocustomer.shiptoglobalcustomername", "title": "Ship To Global Customer Name", "folder": "Ship to Customer", "labels": [ { "label": { "identifier": "label.shiptocustomer.shiptoglobalcustomername", "title": "Ship To Global Customer Name", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.shiptocustomer.shiptohimssid", "title": "Ship To HIMSS Id", "folder": "Ship to Customer", "labels": [ { "label": { "identifier": "label.shiptocustomer.shiptohimssid", "title": "Ship To HIMSS Id", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.shiptocustomer.shiptohimssid" } }, { "attribute": { "identifier": "attr.shiptocustomer.shiptohimssname", "title": "Ship To HIMSS Name", "folder": "Ship to Customer", "labels": [ { "label": { "identifier": "label.shiptocustomer.shiptohimssname", "title": "Ship To HIMSS Name", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.shiptocustomer.shiptohimssname" } }, { "attribute": { "identifier": "attr.shiptocustomer.shiptohimssparentid", "title": "Ship To HIMSS Parent Id", "folder": "Ship to Customer", "labels": [ { "label": { "identifier": "label.shiptocustomer.shiptohimssparentid", "title": "Ship To HIMSS Parent Id", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.shiptocustomer.shiptohimssparentid" } }, { "attribute": { "identifier": "attr.shiptocustomer.shiptohimssparentname", "title": "Ship To HIMSS Parent Name", "folder": "Ship to Customer", "labels": [ { "label": { "identifier": "label.shiptocustomer.shiptohimssparentname", "title": "Ship To HIMSS Parent Name", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.shiptocustomer.shiptohimssparentname" } }, { "attribute": { "identifier": "attr.shiptocustomer.shiptoduns", "title": "Ship To DUNS Number", "folder": "Ship to Customer", "labels": [ { "label": { "identifier": "label.shiptocustomer.shiptoduns", "title": "Ship To DUNS Number", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.shiptocustomer.shiptocategorycode", "title": "Ship To Category Code", "folder": "Z - Under Development", "labels": [ { "label": { "identifier": "label.shiptocustomer.shiptocategorycode", "title": "Ship To Category Code", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.shiptocustomer.shiptocategorycode" } }, { "attribute": { "identifier": "attr.shiptocustomer.shiptofacilitytype", "title": "Ship To Facility Type", "folder": "Ship to Customer", "labels": [ { "label": { "identifier": "label.shiptocustomer.shiptofacilitytype", "title": "Ship To Facility Type", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.shiptocustomer.shiptoaccountid", "title": "Ship To Account Id", "folder": "Ship to Customer", "labels": [ { "label": { "identifier": "label.shiptocustomer.shiptoaccountid", "title": "Ship To Account Id", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.shiptocustomersubregion.subregionname", "title": "Ship To Customer Sub Region", "folder": "Ship to Customer", "labels": [ { "label": { "identifier": "label.shiptocustomersubregion.subregionname", "title": "Ship To Sub Region", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.shiptocustomer.shiptositenumber", "title": "Ship To Site Number", "folder": "Ship to Customer", "labels": [ { "label": { "identifier": "label.shiptocustomer.shiptositenumber", "title": "Ship To Site Number", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } } ], "references": [ "dataset.shiptopartnergrouping" ] } }, { "dataset": { "identifier": "dataset.billtocustomer", "title": "Bill To Customer", "anchor": { "attribute": { "identifier": "attr.billtocustomer.billtositeid", "title": "Bill To Site Id", "folder": "Bill to Customer", "labels": [ { "label": { "identifier": "label.billtocustomer.billtositeid", "title": "Bill To Site Id", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, "attributes": [ { "attribute": { "identifier": "attr.billtocustomer.billtoaddress1", "title": "Bill To Address1", "folder": "Bill to Customer", "labels": [ { "label": { "identifier": "label.billtocustomer.billtoaddress1", "title": "Bill To Address1", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.billtocustomer.billtoaddress2", "title": "Bill To Address2", "folder": "Bill to Customer", "labels": [ { "label": { "identifier": "label.billtocustomer.billtoaddress2", "title": "Bill To Address2", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.billtocustomer.billtoaddress3", "title": "Bill To Address3", "folder": "Bill to Customer", "labels": [ { "label": { "identifier": "label.billtocustomer.billtoaddress3", "title": "Bill To Address3", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.billtocustomer.billtocity", "title": "Bill To City", "folder": "Bill to Customer", "labels": [ { "label": { "identifier": "label.billtocustomer.billtocity", "title": "Bill To City", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.billtocustomer.billtostate", "title": "Bill To State", "folder": "Bill to Customer", "labels": [ { "label": { "identifier": "label.billtocustomer.billtostate", "title": "Bill To State", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.billtocustomer.billtocounty", "title": "Bill To County", "folder": "Bill to Customer", "labels": [ { "label": { "identifier": "label.billtocustomer.billtocounty", "title": "Bill To County", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.billtocustomer.billtocountry", "title": "Bill To Country", "folder": "Bill to Customer", "labels": [ { "label": { "identifier": "label.billtocustomer.billtocountry", "title": "Bill To Country", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.billtocustomer.billtoprovince", "title": "Bill To Province", "folder": "Bill to Customer", "labels": [ { "label": { "identifier": "label.billtocustomer.billtoprovince", "title": "Bill To Province", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.billtocustomer.billtopostalcode", "title": "Bill To Postal Code", "folder": "Bill to Customer", "labels": [ { "label": { "identifier": "label.billtocustomer.billtopostalcode", "title": "Bill To Postal Code", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.billtocustomer.billtopostalcode" } }, { "attribute": { "identifier": "attr.billtocustomer.billtocustomername", "title": "Bill To Customer Name", "folder": "Bill to Customer", "labels": [ { "label": { "identifier": "label.billtocustomer.billtocustomername", "title": "Bill To Customer Name", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.billtocustomer.billtocustomernumber", "title": "Bill To Customer Number", "folder": "Bill to Customer", "labels": [ { "label": { "identifier": "label.billtocustomer.billtocustomernumber", "title": "Bill To Customer Number", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.billtocustomer.billtoglobalcustomerid", "title": "Bill To Global Customer Id", "folder": "Bill to Customer", "labels": [ { "label": { "identifier": "label.billtocustomer.billtoglobalcustomerid", "title": "Bill To Global Customer Id", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.billtocustomer.billtoglobalcustomername", "title": "Bill To Global Customer Name", "folder": "Bill to Customer", "labels": [ { "label": { "identifier": "label.billtocustomer.billtoglobalcustomername", "title": "Bill To Global Customer Name", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.billtocustomer.billtohimssid", "title": "Bill To HIMSS Id", "folder": "Bill to Customer", "labels": [ { "label": { "identifier": "label.billtocustomer.billtohimssid", "title": "Bill To HIMSS Id", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.billtocustomer.billtohimssid" } }, { "attribute": { "identifier": "attr.billtocustomer.billtohimssname", "title": "Bill To HIMSS Name", "folder": "Bill to Customer", "labels": [ { "label": { "identifier": "label.billtocustomer.billtohimssname", "title": "Bill To HIMSS Name", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.billtocustomer.billtohimssname" } }, { "attribute": { "identifier": "attr.billtocustomer.billtohimssparentid", "title": "Bill To HIMSS Parent Id", "folder": "Bill to Customer", "labels": [ { "label": { "identifier": "label.billtocustomer.billtohimssparentid", "title": "Bill To HIMSS Parent Id", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.billtocustomer.billtohimssparentid" } }, { "attribute": { "identifier": "attr.billtocustomer.billtohimssparentname", "title": "Bill To HIMSS Parent Name", "folder": "Bill to Customer", "labels": [ { "label": { "identifier": "label.billtocustomer.billtohimssparentname", "title": "Bill To HIMSS Parent Name", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.billtocustomer.billtohimssparentname" } }, { "attribute": { "identifier": "attr.billtocustomer.shiptodunsnumber", "title": "Bill To DUNS Number", "folder": "Bill to Customer", "labels": [ { "label": { "identifier": "label.billtocustomer.shiptodunsnumber", "title": "Bill To DUNS Number", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.billtocustomer.shiptodunsnumber" } }, { "attribute": { "identifier": "attr.billtocustomer.billtocategorycode", "title": "Bill To Category Code", "folder": "Bill to Customer", "labels": [ { "label": { "identifier": "label.billtocustomer.billtocategorycode", "title": "Bill To Category Code", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.billtocustomer.billtofacilitytype", "title": "Bill To Facility Type", "folder": "Bill to Customer", "labels": [ { "label": { "identifier": "label.billtocustomer.billtofacilitytype", "title": "Bill To Facility Type", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.billtocustomer.shiptoaccountid", "title": "Bill to Account Id", "folder": "Bill to Customer", "labels": [ { "label": { "identifier": "label.billtocustomer.shiptoaccountid", "title": "Bill to Account Id", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.billtocustomersubregion.subregionname", "title": "Bill To Customer Sub Region", "folder": "Bill to Customer", "labels": [ { "label": { "identifier": "label.billtocustomersubregion.subregionname", "title": "Bill To Sub Region", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.billtocustomer.billtositenumber", "title": "Bill To Site Number", "folder": "Bill to Customer", "labels": [ { "label": { "identifier": "label.billtocustomer.billtositenumber", "title": "Bill To Site Number", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } } ], "references": [ "dataset.shiptocustomerregion1", "dataset.billtopartnergrouping" ] } }, { "dataset": { "identifier": "dataset.oracleebsreports", "title": "Oracle EBS Reports", "anchor": { "attribute": { "identifier": "attr.oracleebsreports.factsof", "title": "Records of Oracle EBS Reports" } }, "attributes": [ { "attribute": { "identifier": "attr.oracleebsreports.dataset", "title": "Dataset Name", "labels": [ { "label": { "identifier": "label.oracleebsreports.dataset", "title": "Dataset Name", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.oracleebsreports.reportname", "title": "Report Name", "labels": [ { "label": { "identifier": "label.oracleebsreports.reportname", "title": "Report Name", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.oracleebsreports.reportattribute", "title": "Report Attribute", "labels": [ { "label": { "identifier": "label.oracleebsreports.reportattribute", "title": "Report Attribute", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } } ], "facts": [ { "fact": { "identifier": "fact.oracleebsreports.reportvalue", "title": "Report Value", "dataType": "DECIMAL(15,2)" } } ], "references": [ "dataset.productfamily", "dataset.revenuetype", "dataset.shiptocustomerregion", "I_FDATE_DIM.fiscalOct1_dataset.dt" ] } }, { "dataset": { "identifier": "dataset.parentplanbookings", "title": "Parent Plan Bookings", "anchor": { "attribute": { "identifier": "attr.parentplanbookings.factsof", "title": "Records of Parent Plan Bookings", "folder": "Parent Plan Bookings" } }, "facts": [ { "fact": { "identifier": "fact.parentplanbookings.planbookingamount", "title": "Plan Booking Amount", "folder": "Parent Plan Bookings", "dataType": "DECIMAL(12,2)" } } ], "references": [ "dataset.productfamily", "dataset.shiptocustomerregion", "dataset.shiptocustomerregion1", "dataset.billtopartnergrouping", "dataset.shiptopartnergrouping", "I_FDATE_DIM.fiscalOct1_dataset.dt" ] } }, { "dataset": { "identifier": "dataset.billtopartnergrouping", "title": "Bill To Partner Grouping", "anchor": { "attribute": { "identifier": "attr.billtopartnergrouping.billtoaccountid", "title": "Bill To Account Id", "folder": "Bill To Partner Grouping", "labels": [ { "label": { "identifier": "label.billtopartnergrouping.billtoaccountid", "title": "Bill To Account Id", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, "attributes": [ { "attribute": { "identifier": "attr.billtopartnergrouping.billtopartnername", "title": "Bill To Partner Name", "folder": "Bill To Partner Grouping", "labels": [ { "label": { "identifier": "label.billtopartnergrouping.billtopartnername", "title": "Bill To Partner Name", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.billtopartnergrouping.billtopartnerrole", "title": "Bill To Partner Role", "folder": "Bill To Partner Grouping", "labels": [ { "label": { "identifier": "label.billtopartnergrouping.billtopartnerrole", "title": "Bill To Partner Role", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.billtopartnergrouping.billtopartnerroledescription", "title": "Bill To Partner Role Description", "folder": "Bill To Partner Grouping", "labels": [ { "label": { "identifier": "label.billtopartnergrouping.billtopartnerroledescription", "title": "Bill To Partner Role Description", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.billtopartnergrouping.billtopartnerfamily", "title": "Bill To Partner Family", "folder": "Bill To Partner Grouping", "labels": [ { "label": { "identifier": "label.billtopartnergrouping.billtopartnerfamily", "title": "Bill To Partner Family", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.billtopartnergrouping.billtopartnerfamilydescription", "title": "Bill To Partner Family Description", "folder": "Bill To Partner Grouping", "labels": [ { "label": { "identifier": "label.billtopartnergrouping.billtopartnerfamilydescription", "title": "Bill To Partner Family Description", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.billtopartnergrouping.billtopartnergroup", "title": "Bill To Parent Group", "folder": "Bill To Partner Grouping", "labels": [ { "label": { "identifier": "label.billtopartnergrouping.billtopartnergroup", "title": "Bill To Parent Group", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.billtopartnergrouping.billtopartnergroupdescription", "title": "Bill To Parent Group Description", "folder": "Bill To Partner Grouping", "labels": [ { "label": { "identifier": "label.billtopartnergrouping.billtopartnergroupdescription", "title": "Bill To Parent Group Description", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } } ] } }, { "dataset": { "identifier": "dataset.shiptopartnergrouping", "title": "Ship To Partner Grouping", "anchor": { "attribute": { "identifier": "attr.shiptopartnergrouping.shiptoaccountid", "title": "Ship To Account Id", "folder": "Ship To Partner Grouping", "labels": [ { "label": { "identifier": "label.shiptopartnergrouping.shiptoaccountid", "title": "Ship To Account Id", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, "attributes": [ { "attribute": { "identifier": "attr.shiptopartnergrouping.shiptopartnername", "title": "Ship To Partner Name", "folder": "Ship To Partner Grouping", "labels": [ { "label": { "identifier": "label.shiptopartnergrouping.shiptopartnername", "title": "Ship To Partner Name", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.shiptopartnergrouping.shiptopartnerrole", "title": "Ship To Partner Role", "folder": "Ship To Partner Grouping", "labels": [ { "label": { "identifier": "label.shiptopartnergrouping.shiptopartnerrole", "title": "Ship To Partner Role", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.shiptopartnergrouping.shiptopartnerroledescription", "title": "Ship To Partner Role Description", "folder": "Ship To Partner Grouping", "labels": [ { "label": { "identifier": "label.shiptopartnergrouping.shiptopartnerroledescription", "title": "Ship To Partner Role Description", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.shiptopartnergrouping.shiptopartnerfamily", "title": "Ship To Partner Family", "folder": "Ship To Partner Grouping", "labels": [ { "label": { "identifier": "label.shiptopartnergrouping.shiptopartnerfamily", "title": "Ship To Partner Family", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.shiptopartnergrouping.shiptopartnerfamilydescription", "title": "Ship To Partner Family Description", "folder": "Ship To Partner Grouping", "labels": [ { "label": { "identifier": "label.shiptopartnergrouping.shiptopartnerfamilydescription", "title": "Ship To Partner Family Description", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.shiptopartnergrouping.shiptopartnergroup", "title": "Ship To Parent Group", "folder": "Ship To Partner Grouping", "labels": [ { "label": { "identifier": "label.shiptopartnergrouping.shiptopartnergroup", "title": "Ship To Parent Group", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.shiptopartnergrouping.shiptopartnergroupdescription", "title": "Ship To Parent Group Description", "folder": "Ship To Partner Grouping", "labels": [ { "label": { "identifier": "label.shiptopartnergrouping.shiptopartnergroupdescription", "title": "Ship To Parent Group Description", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } } ] } }, { "dataset": { "identifier": "dataset.refreshdate", "title": "RefreshDate", "anchor": { "attribute": { "identifier": "attr.dummy.lastrefreshdate", "title": "Last Refresh Date", "folder": "Z - Under Development", "labels": [ { "label": { "identifier": "label.dummy.lastrefreshdate", "title": "Last Refresh Date", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } } } }, { "dataset": { "identifier": "dataset.hierarchy", "title": "Sales Hierarchy", "anchor": { "attribute": { "identifier": "attr.hierarchy.emailaddress", "title": "Sales Tier1 User Email Id", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.emailaddress", "title": "Sales Tier1 User Email Id", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.hierarchy.emailaddress" } }, "attributes": [ { "attribute": { "identifier": "attr.hierarchy.tier_1_user_id", "title": "Sales Tier1 User Id", "folder": "Z - Under Development", "labels": [ { "label": { "identifier": "label.hierarchy.tier_1_user_id", "title": "Sales Tier1 User Id", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.hierarchy.tier_1_user_id" } }, { "attribute": { "identifier": "attr.hierarchy.tier_1_user_name", "title": "Sales Tier1 User", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.tier_1_user_name", "title": "Sales Tier1 User", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.hierarchy.tier_1_user_name" } }, { "attribute": { "identifier": "attr.hierarchy.tier_1_role_user_concat", "title": "Sales Tier1 Role-User", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.tier_1_role_user_concat", "title": "Sales Tier1 Role-User", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.hierarchy.tier_1_role_user_concat" } }, { "attribute": { "identifier": "attr.hierarchy.tier_2_role_user_concat", "title": "Sales Tier2 Role-User", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.tier_2_role_user_concat", "title": "Sales Tier2 Role-User", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.hierarchy.tier_2_role_user_concat" } }, { "attribute": { "identifier": "attr.hierarchy.tier_3_role_user_concat", "title": "Sales Tier3 Role-User", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.tier_3_role_user_concat", "title": "Sales Tier3 Role-User", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.hierarchy.tier_3_role_user_concat" } }, { "attribute": { "identifier": "attr.hierarchy.tier_4_role_user_concat", "title": "Sales Tier4 Role-User", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.tier_4_role_user_concat", "title": "Sales Tier4 Role-User", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.hierarchy.tier_4_role_user_concat" } }, { "attribute": { "identifier": "attr.hierarchy.tier_5_role_user_concat", "title": "Sales Tier5 Role-User", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.tier_5_role_user_concat", "title": "Sales Tier5 Role-User", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.hierarchy.tier_5_role_user_concat" } }, { "attribute": { "identifier": "attr.hierarchy.tier_6_role_user_concat", "title": "Sales Tier6 Role-User", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.tier_6_role_user_concat", "title": "Sales Tier6 Role-User", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.hierarchy.tier_6_role_user_concat" } }, { "attribute": { "identifier": "attr.hierarchy.tier_7_role_user_concat", "title": "Sales Tier7 Role-User", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.tier_7_role_user_concat", "title": "Sales Tier7 Role-User", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.hierarchy.tier_7_role_user_concat" } }, { "attribute": { "identifier": "attr.hierarchy.tier_1_user_tier", "title": "Sales User Tier", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.tier_1_user_tier", "title": "Sales User Tier", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.hierarchy.tier_1_user_tier" } }, { "attribute": { "identifier": "attr.hierarchy.tier_1_role_name", "title": "Sales Tier2 Role", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.tier_1_role_name", "title": "Sales Tier2 Role", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.hierarchy.tier_1_role_name" } }, { "attribute": { "identifier": "attr.hierarchy.tier_1_role_name1", "title": "Sales Tier3 Role", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.tier_1_role_name1", "title": "Sales Tier3 Role", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.hierarchy.tier_1_role_name1" } }, { "attribute": { "identifier": "attr.hierarchy.tier_1_role_name2", "title": "Sales Tier4 Role", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.tier_1_role_name2", "title": "Sales Tier4 Role", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.hierarchy.tier_1_role_name2" } }, { "attribute": { "identifier": "attr.hierarchy.tier_1_role_name3", "title": "Sales Tier5 Role", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.tier_1_role_name3", "title": "Sales Tier5 Role", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.hierarchy.tier_1_role_name3" } }, { "attribute": { "identifier": "attr.hierarchy.tier_1_role_name4", "title": "Sales Tier6 Role", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.tier_1_role_name4", "title": "Sales Tier6 Role", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.hierarchy.tier_1_role_name4" } }, { "attribute": { "identifier": "attr.hierarchy.tier_1_role_name5", "title": "Sales Tier7 Role", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.tier_1_role_name5", "title": "Sales Tier7 Role", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.hierarchy.tier_1_role_name5" } }, { "attribute": { "identifier": "attr.hierarchy.tier_1_role_name6", "title": "Sales Tier1 Role", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.tier_1_role_name6", "title": "Sales Tier1 Role", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.hierarchy.tier_1_role_name6" } }, { "attribute": { "identifier": "attr.hierarchy.salestier8roleuser", "title": "Sales Tier8 Role-User", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.salestier8roleuser", "title": "Sales Tier8 Role-User", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.hierarchy.salestier8roleuser" } }, { "attribute": { "identifier": "attr.hierarchy.salestier9roleuser", "title": "Sales Tier9 Role-User", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.salestier9roleuser", "title": "Sales Tier9 Role-User", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.hierarchy.salestier9roleuser" } }, { "attribute": { "identifier": "attr.hierarchy.salestier10roleuser", "title": "Sales Tier10 Role-User", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.salestier10roleuser", "title": "Sales Tier10 Role-User", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.hierarchy.salestier10roleuser" } }, { "attribute": { "identifier": "attr.hierarchy.salestier11roleuser", "title": "Sales Tier11 Role-User", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.salestier11roleuser", "title": "Sales Tier11 Role-User", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.hierarchy.salestier11roleuser" } }, { "attribute": { "identifier": "attr.hierarchy.salestier12roleuser", "title": "Sales Tier12 Role-User", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.salestier12roleuser", "title": "Sales Tier12 Role-User", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.hierarchy.salestier12roleuser" } }, { "attribute": { "identifier": "attr.hierarchy.salestier8role", "title": "Sales Tier8 Role", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.salestier8role", "title": "Sales Tier8 Role", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.hierarchy.salestier8role" } }, { "attribute": { "identifier": "attr.hierarchy.salestier9role", "title": "Sales Tier9 Role", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.salestier9role", "title": "Sales Tier9 Role", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.hierarchy.salestier9role" } }, { "attribute": { "identifier": "attr.hierarchy.salestier10role", "title": "Sales Tier10 Role", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.salestier10role", "title": "Sales Tier10 Role", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.hierarchy.salestier10role" } }, { "attribute": { "identifier": "attr.hierarchy.salestier11role", "title": "Sales Tier11 Role", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.salestier11role", "title": "Sales Tier11 Role", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.hierarchy.salestier11role" } }, { "attribute": { "identifier": "attr.hierarchy.salestier12role", "title": "Sales Tier12 Role", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.salestier12role", "title": "Sales Tier12 Role", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.hierarchy.salestier12role" } }, { "attribute": { "identifier": "attr.hierarchy.salestier13role", "title": "Sales Tier13Role", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.salestier13role", "title": "Sales Tier13Role", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.hierarchy.salestier14role", "title": "Sales Tier14Role", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.salestier14role", "title": "Sales Tier14Role", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.hierarchy.salestier15role", "title": "Sales Tier15Role", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.salestier15role", "title": "Sales Tier15Role", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.hierarchy.salestier16role", "title": "Sales Tier16Role", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.salestier16role", "title": "Sales Tier16Role", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.hierarchy.salestier17role", "title": "Sales Tier17Role", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.salestier17role", "title": "Sales Tier17Role", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.hierarchy.salestier18role", "title": "Sales Tier18Role", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.salestier18role", "title": "Sales Tier18Role", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.hierarchy.salestier19role", "title": "Sales Tier19Role", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.salestier19role", "title": "Sales Tier19Role", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.hierarchy.salestier20role", "title": "Sales Tier20Role", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.salestier20role", "title": "Sales Tier20Role", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.hierarchy.salestier13roleuser", "title": "Sales Tier13 Role-User", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.salestier13roleuser", "title": "Sales Tier13 Role-User", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.hierarchy.salestier14roleuser", "title": "Sales Tier14 Role-User", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.salestier14roleuser", "title": "Sales Tier14 Role-User", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.hierarchy.salestier15roleuser", "title": "Sales Tier15 Role-User", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.salestier15roleuser", "title": "Sales Tier15 Role-User", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.hierarchy.salestier16roleuser", "title": "Sales Tier16 Role-User", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.salestier16roleuser", "title": "Sales Tier16 Role-User", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.hierarchy.salestier17roleuser", "title": "Sales Tier17 Role-User", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.salestier17roleuser", "title": "Sales Tier17 Role-User", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.hierarchy.salestier18roleuser", "title": "Sales Tier18 Role-User", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.salestier18roleuser", "title": "Sales Tier18 Role-User", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.hierarchy.salestier19roleuser", "title": "Sales Tier19 Role-User", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.salestier19roleuser", "title": "Sales Tier19 Role-User", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } }, { "attribute": { "identifier": "attr.hierarchy.salestier20roleuser", "title": "Sales Tier20 Role-User", "folder": "Sales Hierarchy", "labels": [ { "label": { "identifier": "label.hierarchy.salestier20roleuser", "title": "Sales Tier20 Role-User", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ] } } ] } }, { "dataset": { "identifier": "dataset.asreportedbookings", "title": "As Reported Bookings", "anchor": { "attribute": { "identifier": "attr.asreportedbookings.factsof", "title": "Records of As Reported Bookings" } }, "attributes": [ { "attribute": { "identifier": "attr.asreportedbookings.snapshotdate", "title": "Snapshot Date", "folder": "Z - Under Development", "labels": [ { "label": { "identifier": "label.asreportedbookings.snapshotdate", "title": "Snapshot Date", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.asreportedbookings.snapshotdate" } }, { "attribute": { "identifier": "attr.asreportedbookings.year", "title": "Year", "folder": "As Reported Bookings", "labels": [ { "label": { "identifier": "label.asreportedbookings.year", "title": "Year", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.asreportedbookings.year" } }, { "attribute": { "identifier": "attr.asreportedbookings.quarteryear", "title": "Quarter/Year", "folder": "As Reported Bookings", "labels": [ { "label": { "identifier": "label.asreportedbookings.quarteryear", "title": "Quarter/Year", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.asreportedbookings.quarteryear" } }, { "attribute": { "identifier": "attr.asreportedbookings.monthyear", "title": "Month/Year", "folder": "As Reported Bookings", "labels": [ { "label": { "identifier": "label.asreportedbookings.monthyear", "title": "Month/Year", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.asreportedbookings.monthyear" } }, { "attribute": { "identifier": "attr.asreportedbookings.billtocustomerregion", "title": "Bill To Customer Region", "folder": "As Reported Bookings", "labels": [ { "label": { "identifier": "label.asreportedbookings.billtocustomerregion", "title": "Bill To Customer Region", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.asreportedbookings.billtocustomerregion" } }, { "attribute": { "identifier": "attr.asreportedbookings.shiptocustomerregion", "title": "Ship To Customer Region", "folder": "As Reported Bookings", "labels": [ { "label": { "identifier": "label.asreportedbookings.shiptocustomerregion", "title": "Ship To Customer Region", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.asreportedbookings.shiptocustomerregion" } }, { "attribute": { "identifier": "attr.asreportedbookings.revenueaccount", "title": "Revenue Account", "folder": "As Reported Bookings", "labels": [ { "label": { "identifier": "label.asreportedbookings.revenueaccount", "title": "Revenue Account", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.asreportedbookings.revenueaccount" } }, { "attribute": { "identifier": "attr.asreportedbookings.bookingtype", "title": "Booking Type", "folder": "As Reported Bookings", "labels": [ { "label": { "identifier": "label.asreportedbookings.bookingtype", "title": "Booking Type", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.asreportedbookings.bookingtype" } }, { "attribute": { "identifier": "attr.asreportedbookings.bookingtypedetail", "title": "Booking Type Detail", "folder": "As Reported Bookings", "labels": [ { "label": { "identifier": "label.asreportedbookings.bookingtypedetail", "title": "Booking Type Detail", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.asreportedbookings.bookingtypedetail" } }, { "attribute": { "identifier": "attr.asreportedbookings.division", "title": "Division", "folder": "As Reported Bookings", "labels": [ { "label": { "identifier": "label.asreportedbookings.division", "title": "Division", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.asreportedbookings.division" } }, { "attribute": { "identifier": "attr.asreportedbookings.lob", "title": "LOB", "folder": "As Reported Bookings", "labels": [ { "label": { "identifier": "label.asreportedbookings.lob", "title": "LOB", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.asreportedbookings.lob" } }, { "attribute": { "identifier": "attr.asreportedbookings.prodgen5", "title": "Prod Gen5", "folder": "As Reported Bookings", "labels": [ { "label": { "identifier": "label.asreportedbookings.prodgen5", "title": "Prod Gen5", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.asreportedbookings.prodgen5" } }, { "attribute": { "identifier": "attr.asreportedbookings.prodgen6", "title": "Prod Gen6", "folder": "As Reported Bookings", "labels": [ { "label": { "identifier": "label.asreportedbookings.prodgen6", "title": "Prod Gen6", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.asreportedbookings.prodgen6" } }, { "attribute": { "identifier": "attr.asreportedbookings.productfamily", "title": "Product Family #", "folder": "As Reported Bookings", "labels": [ { "label": { "identifier": "label.asreportedbookings.productfamily", "title": "Product Family #", "type": "GDC.text", "dataType": "VARCHAR(128)" } } ], "defaultLabel": "label.asreportedbookings.productfamily" } } ], "facts": [ { "fact": { "identifier": "fact.asreportedbookings.bookingamountusd", "title": "As Reported Bookings Amount USD", "folder": "As Reported Bookings", "dataType": "DECIMAL(15,2)" } }, { "fact": { "identifier": "fact.asreportedbookings.bookingplanusd", "title": "As Reported Bookings Plan USD", "folder": "As Reported Bookings", "dataType": "DECIMAL(15,2)" } } ] } } ], "dateDimensions": [ { "dateDimension": { "name": "I_FDATE_DIM.fiscalOct1_dataset.dt", "title": "Bookings Fiscal" } }, { "dateDimension": { "name": "dealtermactivation", "title": "Deal Term Activation" } }, { "dateDimension": { "name": "dealtermexpiration", "title": "Deal Term Expiration" } }, { "dateDimension": { "name": "I_FISCAL_DATE_CSD.nuance", "title": "Customer Signature Date" } }, { "dateDimension": { "name": "I_FISCAL_DATE_SSD.nuance", "title": "Supplier Signature Date" } } ] } } } }