BusinessObjects Board

Universe Field Listing

I have searched, and lately getting a fatal error on line 621 when I do, for a way to use any of the Excel macro’s to get a listing of the fields in each universe. I have a need to produce these fields, and we have 115 Universes, so this wouild be way tedious and time consuming.


gsbatch1 (BOB member since 2014-02-18)

Bob’s Downloads has an excellent utility by Dwayne. Did you try using that ?


Shobhit_Acharya (BOB member since 2005-08-11)

Worked like a gem. That is perfect.

Thanks.


gsbatch1 (BOB member since 2014-02-18)

So, this working like a GEM isn’t actually true.
For some reason no matter which Universe I select in my BO, it comes back with the exact same number of Column Names in the Database Columns Tab.
I keep coming up with 1424 columns. Exactly the same each time I run this on ANY universe.


gsbatch1 (BOB member since 2014-02-18)

Did you clear the records from 1st fetch before attempting a new one ? From what i remember, it doesn’t clear the old records before a new fetch.
Posting feedback on the original post may help otherwise :


Shobhit_Acharya (BOB member since 2005-08-11)