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...
Hi All, I would like your help. I installed OneStream as a plug-in using MS Excel. When I try to create a pull or refresh a sheet this is what it shows: "Error processing dimension. The item was not found. Dim, OneStream.Shared.Common.DimPk, 0-1". An...
Hello, Is there a way to pull the account type in Excel add-in for OneStream? I tried using XFGetCell and XFGetMemberProperty and it didn't work. Thanks, Will
I have a requirement for a book to produce different views (i.e. Periodic, QTD, YTD) based on the WFTime. The periodic report should always appear no matter the WFTime, however the QTD Version will only appear in certain months. I cannot get the "if"...
Hi,I have a cue view report of below settings:Net Sales row: A#NSStd cost row: A#SCgross Margin row: GetDataCell(A#NS - A#SC):Name("GROSS MARGIN") Col1: S#BudgetCol2: S#RollingBud Col3: GetDataCell(CVC(Col1) - CVC(Col2)):Name("VARIANCES")Col4:GetData...
