Skip to main content
A
Avatar-Roku
Newcomer
April 11, 2022

Cubeview - Looping multiple entities into one Excel file?

  • April 11, 2022
  • 3 replies
  • 0 views

How do I generate reports in a loop for each member (branches) and send it to single excel file? I have a cube view report which I'm trying to run for multiple entities member (100+ locations). Any idea will be appreciated.

3 replies

C
OneStream Employee
ChristianWOneStream Employee
OneStream Employee
April 11, 2022

Hello Mustafa_A

The easiest way to achieve it is by creating a Book

ChristianW_0-1649690811245.png

 

regards

Christian

    C
    OneStream Employee
    ChristianWOneStream Employee
    OneStream Employee
    April 11, 2022

    You might also have a look at the Parcel Service solution in the Market Place:

    ChristianW_1-1649691063260.png

    Regards

    Christian

      N
      NidhiMangtani
      Veteran
      April 11, 2022

      Add entity filters in a row, E#Top.Base or Tree or any access specifier as per your requirements. This cube view can be opened up from a spreadsheet or Excel Add In. 

      A
      Avatar-RokuAuthor
      Newcomer
      April 11, 2022

      I looked in to this. It groups all the Account Dimension into groups, which messes up the CV formatting. 

       

       

       

       

       

      K
      Krishna
      Expert
      April 12, 2022

      You can create Book in that

      1. Create a Parameter and Assign a Variable1="Entity Name" and Make it Change Variable to True.

      2. Create an another Parameter and Change Pov = True and in Member Script Assign E#|Variable1|

      3. Keep changing the Variables in the Book and calling the E#|Variable1| in report and it will run for all the locations.

      Note : This method we used because of the formatting requirement and we require only 5 Entity in one page.

      If you don't have any formatting issues then you can loop through the variables in the parameters and generate the book.

       

      Terms & ConditionsAccessibility statement