Reporting

Dear Community -  I'm building a dynamic prior year formula for my Variance Cube view. However I want to pull the MonthNo (e.g. M10) from the parameter I have |!SelectCol1Period!|  so that it can reference the accurate period based on selected by user period. Currently it pulls the PY from POV instead of what the user has selected as his time period.  Wondering if their is an API function to call a parameter?  Here is the code I'm working with: Dim SelectedTimeMonth As Integer = api.Time.GetPeriodNumFromId(api.pov.Time.MemberId)Dim SelectedTimeYear As Integer = api.Time.GetYearFromId(api.Pov.Time.memberid)Dim PYTime As String = (SelectedTimeYear - 1) & "M" & SelectedTimeMonth Dim Amount As Decimal = api.Data.GetDataCell("U8#None:T#" & PYTime).CellAmount Return Amount   Here is the front page of my cube view:  Let me if I can answer any questions.   Thanks for the help.  

Hello: Looking for guidance on how to implement an enhanced conditional formatting check.  It's quite simple, apply some formatting based on the account type. Consider the example of a single row CubeView with one account as the member filter: A#A87999.  Formatting should be applied if the account is a Liability type. I have a mostly working XFBR helper that can correctly apply formatting but only if I hardcode in the account reference.  Obviously that won't work for all but the simplest CV as reports are often dynamic with Member Expansions. The mainly working formatting syntax as currently written: If (XFBR(XFBR_FormattingHelper, AccountTypeIsLiability, Account=[A8799])=True) ThenTextColor = RedEnd If How do I make the parameter dynamic?  I've tried the following: ... Account=RowE1MemberName ... Account=|RowE1MemberName| ... Account=[RowE1MemberName] ... Account=[|RowE1MemberName|] None seem to work.  Is there a different way to reference the standard availab

Hello All, I have requirement to present a number from an external table in cubeview so that number and a cube datacell number displays side by side. It is like doing a recon between two systems. Has anyone ever done that? I know I can do it in a dashboard using dashboard extender BR and display in a pdf report but I need to capture some comments from the user and store it in the cube that’s why trying to see if a member formula can do it so that it can be used in a cube view report. Are there any example anywhere in golfstream app to reference? appreciate any help.

I know when you open a cube view report as PDF it puts logo automatically. Is there anyway it can be displayed in excel export? never seen or done it but wondering if someone did it or have a work around. I have a requirement where we are doing an export of a Book in excel workbook (multiple tabs based on a loop in the book) and want to have the logo in the output so users don’t have to add it manually.

Dear Community,I was wondering if there's a way to have a component "embedded dashboard" that would target a Dashboard from another Maintenance Unit ?The idea is to open a dashboard ( Predictive Analytics 123  dashboard) as an embedded dashboard in my global navigation dashboard which is in another maintenant unit. Regards,

Originally posted by Henning WindhagenHi All, did anyone here write a macro in Excel to kick off "Submit data"? A customer wants to enhance his data submission from Excel and was asking me about this.

CubeView - Calculate the Variance for multiple columns ( Column-by-Column) Hi there, I am trying to calculate variance Column-by-Column for all time members of Current Year Vs. Prior year and looking for good option for performance optimization. Please find below the details: I have CubeView with 3 columns.   Column 1: T#Year(|!SelectTimeYear!|).TreeDescendantsInclusiveR This gives 19 Columns of current year (year, half year, Quarter and Months) Column 2: T#YearPrior1(|!SelectTimeYear!|).TreeDescendantsInclusiveR This gives 19 Columns of Prior year (year, half year, Quarter and Months) Column 3: Need to generate 19 columns for variance between respective time members form previous members. 2020 vs 2019, 2020H1 vs 2019H1 etc. following are some options I have implemented or have thought of.  I am trying to work Option 3 but don't know how to do it. Option 1: I am able to generate the 19 variance columns using UD8 member but I believe this is impacting the performance o

For columns there is formatting for CVMathOnly, but there is not for rows. What methods are used to be able to use the row as a source value, but not display? Place at bottom and format? Using a live app where the hierarchies are set.

Hi. I have created a new Quick view report for the first time. I've set the POV parameters, the column dimension is Time and the row dimension is account. The report is not showing any values. I've drilled down to the base accounts. Still nil. Any idea why this might be? 

Source: OneStream Champions   Hi, is there a way to hide/format these repeated text in CV excel settings? I would like for e.g. “ProSolutions” to show once for every stats section.     image.png444×661 8.47 KB   Thank you!

Hello,  Is there a way to format a cube view column for variance explanation to be a certain color/have text in the cell based on the variance column? The attached/below is what we want it to look like. If this is a cube view extender, is there any sample code? The example in Golfstream didn't seem to relate to this.

Is there a way that you can exclude the value of a specific child in the account hierarchy without losing drill down functionality in cube views? For example to exclude bonuses from staff costs.

I'd like to be able to build a Pareto chart in BI Viewer. Is it possible?

Source:   Migrated from Champions Hi Team, Hope you are safe and doing well.I am attempting to display members using the if-else condition in cubeview.Does anyone know if it’s possible to use the if-else condition in Member Filter Builder Cube View? Thanks in advance

Source:   Migrated from Champions Does anyone know if it’s possible to use a hard enter (ctrl + enter or vbcrlf in vba code) in a label?

Source:   Migrated from Champions Hey Everyone, I am trying to create a report/cubeview for our regions. But how do I get the dynamic calculation inserted into my CV? (Highlighted Yellow) Do I need to approach it differently? Here is an example of what I am trying to create -   Thanks

Source:   Migrated from Champions Hi All,This is my first time posting and happy to do that!I’ve built a cubeview showing the clients in rows and Revenues in columns but struggling to sort my client based on the revenues (descendant).Is there any effective way to apply descendant / ascendant sorting ?Thanks

Source:   Migrated from Champions Hi! This is my first time posting but we’ve had multiple users trying to copy tabs that have quickviews to another file while keeping the connection instead of rebuilding. Is this possible? Thanks!

Source:   Migrated from Champions Hi, is there a way to create ranking within cube view? for e.g. Ranking Top 20 branches based on branch Profit. I think it would involve writing a BR but not sure. Any ideas will be greatly appreciated. Thanks

Source:   Migrated from Champions How can I create a cover page in an XLbook (first tab in the excel book)? I have tried uploading .xlsx and .xfdoc.xlsx single tab excel files into File Explorer under Application Database and System Database. The cover pages don’t appear when the XLbook renders. This does work for PDFbooks.

Jigsaw, one of the partners in South Africa needs to build an Onion Graph for one of our SA customers. Anyone have an idea how to do this?  

I have a report book I've built that loops thru a dimension and creates a tab for every member in a ud hierarchy. I've set book to label the tabs using the CVUD2 and CVUD2Description.  It works quite well except there are some descriptions that have hyphens in them which don't print out. Is there any way to print the hyphen included in some descriptions?

Hello! I'm looking for a solution to the new Quickview feature of splitting up Excel tables into pages, when the number of rows exceeds a certain number. I'd like to show all information in one page still, if possible.  

Hi all, We have dynamic number of columns in our cube views/reports and it changes the number of pages that the rows go over based on the number of columns and fitting the the width of the pages.  Is there a way to make sure that the rows are set to a set number of pages high? Thanks

Hi, When creating a simple cube view using both calculated rows and columns, the intersection of these two formulas doesn't display correctly. Is there a way around this? See attached photo where Variance and Variance % columns both show the value of the first cell instead of the difference and difference percentage as they do in the other rows.