Report Book - Loop with a XFBR string
We are looking to turn some of our existing cube views into report books to loop through entities. Right now we use an XFBR string (referencing Brapi.Workflow.Metadata.GetParent) instead of a parameter to determine the entity. Is it possible to create a report that loops through the entities with the XFBR string or would we have to duplicate the cube views and use a parameter instead?
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 suppress blank pages in a PDF book
Originally posted by Mark Williams I have created a PDF book that loops over a large group of entities and has a page based on a cube view for each entity. Around 10%-15% of the pages are blank. Is there an easy way to have the book skip pages for entities with no data?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
Looking for a way to report Workflow Profile properties/attributes
Just wondering if anyone out there has figured out a way to report the attributes/properties of a Workflow profile. What I'm actually trying to do as part of a security overhaul is determine WHERE a particular security group is actually being used. I am using the XFGetMemberProperty() function to pull security for all of my dimension members but I need a solution to pull the security groups used in each of our FPA workflows. There is no built in security dashboard report to provide this and the best advice I've received so far is to download the application and search for the security groups there. That's one way, but we literally have dozens of security groups set up so it'll be a long and manual effort. Would love to hear from anyone who's found a better way to do this. Thanks
Data Dump - Too large for Cube View
Hi All, I was hoping to brainstorm a solution to a problem. Our auditors have requested a mapping of base-level data to the aggregated, financial statement line item data that appears in our financial statements. This is fairly easily done for the Balance Sheet, which only depends on the Account and Entity members to generate, but for the income statement we simply have too many data intersections (Account, Entity, Cost Center, Line of Business - generates about 15,000 rows of data) for a cube view to be able to process the request, even with suppression enabled. Currently, to work around the problem I've set up a book that loops through each entity (approx. 200) and exports an excel with each entity's income statement as a separate tab. I then have an excel macro that copies each tab into a single aggregated file that we can then send to the auditors. However, I was wondering if anyone has figured out a way to have OneStream do the work of aggregating all the tabs together so we don't have to use an excel macro at all, which sometimes has caused errors during the copy+paste process. Or, if there's another solution entirely to this problem-- I'm certain I'm not the only person with requests like this from their auditors!Parcel Service Bursting - FXGet based excel to static values for non-licensed users
Need to burst out a file (ie multiple tabs) in excel to non-licensed users (ie preview of dept expenses for Fcst to managers). I have done this with output being pdf (CV's and FXGets via Books), just not sure how to do with output being excel. Right now I have it all working (bursting, passing parameters,...) and delivering an excel doc, just can't figure out how to convert the FXGet formula's to values. File is getting delivered but still with the formula's. This is when I am just using a direct link to the excel file on my App Doc's folder. I have tried to insert the excel doc in a book but that just delivers an empty excel file. Not sure what I am missing there. Direct link to Excel allows the Supplied Parameters to be found and populated so I am thinking I am missing something on the Book setup. Anyway - Anybody been able to send excel FXGet report converted to static values via Parcel Service? Can you let me know what I have missed. Do to formatting, multiple tabs and complexity of parameters, CV is not on option at this time.
