Reporting - Books - File (xfDoc)
Hello, I would like to create a report book that includes several cube views and an xfdoc (ppt cover page). I added the xfdoc as an application database file and pointed it to the working URL. However, when I run the report book I get a blank page. I can't figure out how to get it to render the File (xfDoc). It does render all the cube views as expected. And I confirmed that my standalone xfdoc is working as well. Thanks, SeanShowing a pop-up message from Business Rule?
Hello community, When creating a dashboard that requires user interaction, usually it is necessary to receive confirmation from the user to proceed or we just want to inform the user that something has happened in the background. In order to do so, one of the most efficient ways to do it is by displaying a dialog box from the code with the information that we want to share with the user and, if necessary, some buttons to catch the user response. However, I still haven't found this way to do it while programming a Business Rule in OneStream. Since it uses VB seems that using the "MsgBox(<message>)" function should work, but the following error occurs: Summary: Showing a modal dialog box or form when the application is not running in UserInteractive mode is not a valid operation. Specify the ServiceNotification or DefaultDesktopOnly style to display a notification from a service application. When using MessageBox.Show() with the "ServiceNotification" option, then it doesn't trigger an error but it doesn't display the message box either. Therefore, the most easy-to-go option seems to be throwing an error with the message that you want to display, but when the purpose of the message is just to inform the user it doesn't seem the correct approach. Another approach would be creating display a dashboard component as a dialog box, but it is not a very practical solution. What is the best approach you have used to serve the purpose of displaying a message box to the user? Thanks! Bests, Oriol
SQL query to retrieve base members of a hierarchy
Hi, All Just wanted to share a SQL query I wrote to retrieve base members and parent of a given hierarchy from within a dashboard grid. (Note that the parameter supplies the member ID of the top member in the chosen hierarchy.) Any thoughts on how to improve are welcome! With TEST AS (SELECT childid, parentID, dimtypeid, 0 AS level FROM relationship WHERE parentid = |!SelectDimension!| UNION ALL SELECT ft.childid, ft.parentID, ft.dimtypeID, level + 1 FROM relationship ft JOIN TEST d ON ft.parentid = d.childid ) SELECT m.name As Child_Name, m.description as Child_Description, P.name AS Parent_Name, Description as Parent_Description FROM TEST d JOIN relationship a ON d.parentid = a.parentid JOIN member AS M ON a.childID = m.memberid JOIN member as P on d.parentid = p.memberid where NOT EXISTS ( SELECT NULL FROM TEST d WHERE d.parentID = m.memberID ) group by m.name, m.description, P.name, p.description
How can we show commas as the thousand separator in a numeric Table View column
We are trying to format numeric columns in a Table View but haven't been successful. The numeric columns are currently appearing as 999999.99 instead of the desired 99,999.99. Are Table View currently looks like this: The Spreadsheet Table View rule is defining the numeric columns here: sql.AppendLine( ",FORMAT(SUM(ISNULL([V4],'0')),'N2','en-us') As [Gross Revenue]") Thanks
Primary and secondary axis align 0 point
Hi everybody, Below you can see a graph created for a client. A question coming from them is that they want to align the 0 points (highlighted) of both the primary (left) axis and the secondary (right) axis. I've tried (amongst others) to change the visual and whole range, scaling options but it doesn't seem to change anything. Does anybody know if it is possible to align the 0 points? Thanks! FlorisHow to get description of entity to appear when using a loop in a report book
I have a member filter loop set up to cycle through the children members of a parent entity in a report book using |Loop1Variable|. I also have |Loop1Variable| in the Page Caption of the cube view for the report book. Currently, the report book shows the name of each entity in the loop. What do I do to get the description of each entity in the loop to appear on the report?What's the best way to pull 16M+ rows of data
Hello! I have a user group who needs a specific set of data pulled just after close every month in order to populate other reporting tools they use. Here's the formatting they require: I'm struggling on my options because this results in about 16M+ rows of data. I get an error when trying to export the CV and a QV won't show all rows even with the max # of seconds set to the largest number (which I believe is 600). A DM extract will not show the right format but I don't think a QV can be auto run and sent via Parcel Service. What are my other options? Thanks for helping me brainstorm!
Cube View formatting mixed dimensions
I have a Cube View that is displaying a single dimension in the first column (Departments), and a second dimension (Accounts) in the second column. In order to match the formatting of the report that is currently in use I’d like it to display in the first column Departments up to the bolded Total row, then accounts from there on out. In essence it would be mix of two different dimensions displayed in the first column. I would also like for the second column to be hidden. I have made some attempts to match the formatting as I described, but without success. Do you have any ideas on how to achieve this? Thank you for your time in advance.
