Zoom in on "TB Last" on Essbase

Question

Summary

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

JackM-88380 · Answer

Good shout Glenn...it is on premise.

GlennS_3 · Answer

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.