How to create a Book with Single Loop containing multiple dimension combinations
Hello Team, Need solution on the Book Creation. I am trying to create only one Loop, with two combinations example (E#Abc:U2#Xyz) and the Loop Type I have used is Comma Separated List. In excel Export Item I have attached the CV also. Where it is not updated with my Entity and Customer, because I have passed them in the Loop Definition, together. While running the Book it is running at Top Level for both Entity and Customer. Instead of Abc & Xyz.
Create a report book for user data entry single user report
Has anyone tried or had experience creating a report book for application reports? basically what I am trying to do is to create a report book to run for the Data entry audit(single user) report, when running the report book, it will loop through specific Users for "Actual" Scenario, and for time period by quarter instead of month. right now with the default set up of application, if I want to run this report for multiple users and multiple period, it's a very manual process so trying to see if there is a better way of doing this. Thanks!
Hierarchy Comparison Reports or Dashboards
Has anyone built a cube view, or more likely a dashboard, that can automatically compare the base level members of 2 or more hierarchies in a dimension to identify exceptions? We do this manually now in Excel but was asked by the users to put this comparison in OneStream. I thought this might be an application report, but I don't see anything close. Also, we are currently on v7.4, so if there is a feature in the latest version please pass along. Thanks!Save Offline Copy
I'm getting the below error message regarding location when trying to save a file with multiple XFGetCell formulas offline. I've updated my preferences that an earlier question showed as a solution and refreshed the workbook (again) before attempting to save...but am unable to save the file without the formulas. I've tried directly to my desktop, various folders, where downloads go.... I can't find an acceptable location. Any help would be appreciated.
Version 8 formatting issue with Books/Cube Views produced in Excel?
Just checking to see if anyone else has been experiencing the following issue with Version 8. We are currently testing the upgrade from 7.x to version 8 and have run into a huge formatting issue with our books that are produced to Excel and sent out to management via postal service. The source cube views for a batch use the same column template. We have Excel column width formatting set up for each of the columns (but consistently on each column). When the cube views are run and exported to Excel, the column width is not being recognized in most of the columns. I have tried direct formatting, I have tried with a literal parameter and getting the same results no matter what. I don't see where I can attach the workbook itself but am attaching a screen capture sample . In this case text wrap is set to False and column widths are set to 100. Note the results. Oddly, in like the first book, some of the sheets ARE recognizing the column width. I'm just wondering if anyone has experienced this and has found a workaround or determined why this is happening.
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 possible? Or would there be another way of getting that information? Thanks!MergeAndCenterColumnHeaders in Cube Views
Hi, Anyone on Version 8 who's actually tried to use this 'enhancement' feature in Cube Views? We requested this on Ideastream a long time ago with a lot of support. I can see this command is now available in the header format dialog; however, it would appear that the only thing it does is change the header from left justified to center view. There does not seem to be a way to actually 'merge' column headers, despite the fact that it's called "MergeAndCenter". Even the system documentation appears to confirm this behavior. Someone please tell me I'm missing something here and it actually is possible to merge column headers, because we really really wanted this feature. Thanks
