asset category column for OTBI report — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

asset category column for OTBI report

in Assets 9 comments

Summary:

I am trying to create an OTBI report with Asset Category as one of the columns. I am facing issues with assets that have been transferred multiple times from one category to another. For these assets, Category column is showing all the categories the asset had been assigned to (multiple rows for Category).

I want to report on the latest Category the asset is assigned to. I have tried all the Assets subject areas and Category columns within these subject areas but unable to find a column that can give single row for asset category.

The seeded Asset Register report also shows only the latest asset category.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!