Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Zoom in on "TB Last" on Essbase

Received Response
31
Views
2
Comments

Summary

Zoom in on "TB Last" on Essbase

Content

All my level zero balance sheet accounts should have a Time Balance Last (TB Last) tag. I have recently discovered some accounts are missing this tag. 

Is there a way i could zoom in on the my level zero balance sheet accounts with the TB Last tag, and compare them to those without the tag, via the spreadsheet ADD-in.

Alternatively, is it possible to write an export calc script for all accounts WITH or WITHOUT the TB Last tag? 

I know this would have been easily possible to do if "TB Last" was a UDA.

 

Version

TB Last

Tagged:

Answers

  • GlennS_3
    GlennS_3 Rank 4 - Community Specialist

    Is his is OAC or On-Prem?  On-Prem you could go into the EAS expand the entire Balance sheet, select all the members and tag them as TB Last at once.

  • JackM-88380
    JackM-88380 Rank 1 - Community Starter

    Good shout Glenn...it is on premise.