Forum Discussion

jacidoyo's avatar
jacidoyo
New Contributor II
28 days ago

How to find all cube views used in book definitions

Hi. I'm looking at a way to find all cube views used in book definitions. I was thinking of exporting all xlBook files all at a time via Load/Extract but I cannot find how to do it. Is it possibl...
Books
jacidoyo's avatar
jacidoyo
New Contributor II
27 days ago

Hello Marcus,

Thanks for the answer!

I did the GetFile step and got a list of my books but I cannot see the content to search through and look for cube views used in the definition of the book.

I used an SQL Data Adapter and just ran the SQL Query. Should I have done it differently?

Thanks

  • MarcusH's avatar
    MarcusH
    Valued Contributor
    27 days ago

    Post the Business Rule script that you are using.