Oracle Communities

Oracle Analytics and AI

Child Item

Subject Area with Associated Asset Data

Hello!

There is no Subject Area that brings Associated Assets fields.

I tried creating a custom Subject Area to have these fields, but the only Subscription Product child objects available are Subscription Covered Level and Bill Line.

The suggestion is to have a Subject Area with data from the following objects (and equivalent SQL relationship):

Subscription Product Associated Asset: OSS_ASSOCIATED_ASSETS

Subscription Product: OSS_PRODUCTS (WHERE OSS_ASSOCIATED_ASSETS.SUBSCRIPTION_PRODUCT_ID = OSS_PRODUCTS.SUBSCRIPTION_PRODUCT_ID)

Subscription: OSS_SUBSCRIPTIONS (WHERE OSS_PRODUCTS.SUBSCRIPTION_ID = OSS_SUBSCRIPTIONS.SUBSCRIPTION_ID)

Account (Subscription): HZ_ORGANIZATION_PROFILES (WHERE OSS_SUBSCRIPTIONS.PRIMARY_PARTY_ID = HZ_ORGANIZATION_PROFILES.PARTY_ID)

Account (Associated Asset): HZ_ORGANIZATION_PROFILES (WHERE CSE_ASSETS_HIST.CUSTOMER_ID = HZ_ORGANIZATION_PROFILES.ACCOUNT_ID)

Asset (Installed Based Asset): CSE_ASSETS_HIST (WHERE OSS_ASSOCIATED_ASSETS.COVERED_ASSET_ID = CSE_ASSETS_HIST.ASSET_ID)

Sales Product: QSC_PRODUCTS_B (WHERE CSE_ASSETS_HIST.ITEM_ID = QSC_PRODUCTS_B.INVENTORY_ITEM_ID)

Current scenario

Custom Subject Area: Subscription Product Child Objects

Application Composer: Subscription Product Child Objects

PS: The object name is Associated Asset. It is written as Associated devices through translation.

Thanks!

Bruno

Find more posts tagged with

Delivered

Oracle Fusion Analytics

Analysis and Data Visualization

Analysis

Status: Delivered

Comments

Naren Chawla

Thanks, we will look into this.

Hitesh Patel-Oracle

Hello Bruno,

Subscription Associated Asset would be available as part of the 23C release.

There would be an OOTB subject area for the associated asset, and the associated asset would be also available as a child object while creating Custom Subject Area. (Indicative images below)