Recent Discussions
Need help passing business rule into scenario member filter of Cube View.
I have a cube view with 12 columns (one for each month). It is used in a quarterly activity, and the columns need to reflect the appropriate forecast scenario depending on which workflow was opened. (e.g. in June 2026, the cube view would have the 6+6 Forecast for Jul thru Dec). I've created the below BR to determine each forecast should be used, but now I'm unsure what I need to enter into the cube view scenario member filter for the columns to use this BR: Public Function OCF_FcstScenarioSelect(ByVal si As SessionInfo, ByVal api As Object, ByVal args As FinanceRulesArgs) As Object Try ' Workflow POV time (from workflow context) Dim wfTime As String = api.Workflow.Time.Name Dim wfPos As Integer = wfTime.IndexOf("M"c) Dim wfYear As Integer = CInt(wfTime.Substring(0, wfPos)) Dim wfMonth As Integer = CInt(wfTime.Substring(wfPos + 1)) ' Column POV time (from cube view) Dim colTime As String = api.Pov.Time.Name Dim colPos As Integer = colTime.IndexOf("M"c) Dim colYear As Integer = CInt(colTime.Substring(0, colPos)) Dim colMonth As Integer = CInt(colTime.Substring(colPos + 1)) Dim scen As String ' Determine scenario per column If (colYear < wfYear) OrElse (colYear = wfYear AndAlso colMonth <= wfMonth) Then scen = "ActBud" Else Select Case wfMonth Case 3 : scen = "Forecast_3_9" Case 6 : scen = "Forecast_6_6" Case 9 : scen = "Forecast_9_3" Case Else : scen = "ActBud" End Select End If Return scen Catch ex As Exception Throw ErrorHandler.LogWrite(si, New Exception("Error in OCF_FcstScenarioSelect: " & ex.Message)) End Try End Function I would appreciate any help, as I'm new to using BR's for this purpose, and I have been unsuccessful in finding a solution to my specific issue via search engines. Thanks in advance!
Cube View formatting
Have a question regarding Cube view formatting. The client has a column for comments where large commentaries are written point wise which currently are seen as one line. They want to view the same like excel where comments are seen point wise one below another. How can the same be done. Also while exporting the report in excel the wrap text option in the Column cell format under excel only wraps the entire cell but it does not show the comment point wise one below another
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.
Task Manager Dashboard Configuration
I have to create a task manager build that does not include weekends in the duration. We have tried adding the weekends to holiday profiles and excluding them from the explicit day map, but the duration will always include the weekends. Right now, I have due dates on weekends an holidays even when calling them out in the Holiday Profile and setting each one with an offset of 1. Is there a work around for this or any other solution to have the durations skip weekends/ due dates not be due on weekends or holidays?XF Document is not working anymore
Hi All, good day; last week I created Book with a word document with XFCell function and working good showing the amounts, now the same document is just showing the XFCell funcion. I also started to use the alt text {XF}{Application}{CubeViewReport}{BS_Var} but nothing shows. Does anyone knows if I need to do something different? Thanks in advance and best Regards. Mario GVXFDoc Word text size changing upon processing
We have XFDocs set up to open in Word. The text is Times New Roman, size 12. Some, not all, of the text shrinks to size 10 when the document is processed. I noticed that the text that resizes has a "Normal" style. The text that doesn't resize doesn't seem to have a style at all. If I copy the format of the non-styled text and paste it over the Normal style text, it won't resize when processed. Does anyone know more about this? Is there a way to prevent the resizing or set what "Normal" should process as in OneStream? Thank you.
