OneStream Platform Forums

Is it possible to change the orientation of a report using a business rule?I can't see any options for it when creating a custom report task in a cube view.

Hi I have created a member list on Account dimension members to pull accounts with Account type "Balance Recurring". Now I need to use this member list in Finance BR  - Calculate Function Type to loop through this member list and copy data from December to Jan.I would like assistance on the syntax to filter by this member list on a data buffer function to pull the December data. Also I would like to know whether the member list will be executed one time and stored in the memory and used across all entities OR will it be executed for each entity when it runs through the consolidation process?I want to make sure using member list to achieve this data copy is performance efficient than directly filtering the members within the Finance Calculate BR using  api.Data.GetDataBufferUsingFormula("RemoveNoData(FilterMembers(A#Root.Base.Where(AccountType = 'BalanceRecurring')

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

I am building a Rolling Forecast scenario (eg. name is RFC 2+10) using the below formula snippet which takes the current month actuals, and adds the future Budget scenario. It works well so far, however when I use the scenario in a cube view, I'd like to use the headers based on the source data. So in RFC 2+10, columns 1 and 2 are actuals, and 3 to 12 are Budget. But for each column it just shows RFC 2+10 - is there a way I am able to write something or use some conditional formatting so that show Actuals/Budget based columns?Thanks   

Hi All, Can anyone suggest is it possible for Admin to enforce Workflow POV and Cube view POV for users, if so please guide where to do it on OneStream  Thanks in advance.

Hi All,   Currently I have weekly data, if i enter commentary in Week2 it should be in the same week later if I enter commentary in Week3 am getting w2 data in w3, can anyone suggest how to overcome this?     Thanks in advance.

OneStream 7.4.1 (On-Prem)Looking to upgrade to 7.4.2.Has anyone developed a strategy to upgrade OneStream with minimal downtime?  Uninstalling and reinstalling the application takes time, and I would like to avoid as much downtime as possible.I am using 1 server for everything.I was thinking I could install 7.4.2 in another folder, but I believe the install would attempt to create the same IIS app pools that already exist.Any suggestions would be appreciated.

Hi ! I want to confirm a data management behaviour... Right now I have data in a driver on Entity 9999, that I need in order to calculate data on entity 1032. The output should be on entity 1032. I am using a data management job where the DUCS are set for Entity 1032. However when I run the DM, my data buffer is not getting any data for Entity 9999. I think somewhere someone mentioned that using SetDataBufferVariable you can retain data in the whole Data Management sequence, so I tried to change the Data Management DUCS to "E#9999, E#1032". But the variable seem to be cleared when cycling to the second entity. Then my question is : How can I get my data buffer to "read" data from another entity (E#9999) when my data management job run on E#1032 ?   Here's my code which obviously doesn't work at the moment. The goal is simply to have databuffer1 get data from Entity 9999, and databuffer2 to get data from current entity 1032: Dim dbr1 As DataBuffer = NothingIf api.Pov.Enti

We have several parser rules that are running on our connector to d365. Is there a way to see what the affect on run time is from each of these rules?  Do these rules run on all data that is queried from our connection or just new data?

Hi all - I am trying to format a cubeview a specific way. Then the rows are like follows: Entity1 Title row Entity1 net sales Entity1 Profit Entity1 Margin % Blank row for spacing   Entity2 Title row Entity2 net sales Entity2 Profit Entity2 Margin % Blank row for spacing   This continues on for a bit in the exact layout. What I want to do is hide the entity name in all the rows except for the title row. Then in the blank rows I am currently seeing "none", I would like that to be gone as well.   What is the best way to stop the entity name from repeating and removing the word "none" from my blank spacing rows? TIA!

Hi all,I'm working on a Business rule that will be triggered as soon as a user clicks on a button within a dashboard.Is there a way to retrieve the Username of the user that clicks on the button? Thanks in ad

Hi, there is a way to get the sum of the values of all the members that I filter with the text3? for example text3='Austria'In this case in Row1, I have E#Entity.Base.Where(Text3 = 'Austria'), which identify two entities, and in Row2 GetDataCell(CVR(Row1)):Name(Total Austria), but it doesn't work.  

Creating a post for custom coloring in dashboards.   For example, Onestream's dashboard selections give the option for custom color, however, it does not let you select it in the formatting. It only shows the option for #FF00000 (at least from what I have seen).   The above format is HTML coloring codes that can be manually updated in the display format Typically when matching client colors I am given RGB color codes, So I use the below converter to get the HTML code and add #FF to the beginning of the provided hex code.   https://www.w3schools.com/colors/colors_converter.asp  

Originally posted by Andrea Tout 2/7/2020 Has anyone ever had to check what the user's response is to a certification question and not allow them to certify based on that?

  Scenarios always must utilize the FX rates on the Cube Question Credit: Parker Laabs Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in two weeks. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

HiIs it possible to show a message box in excel?I am currently writing a SpreadsheetFunctionType.SaveTableView rule and I would like to display a message box to the user with any data validation errors when trying to save.I have tried :Throw New XFUserMsgException(si, Nothing, Nothing, "My error message")However, this doesn't seem to work. Regards,Mark

One of the new features in the 6.6 release is the introduction of Hybrid Source Scenarios.  I've watched the 6.6 release and read through the abbreviated examples in the admin guide. Both have good high level content, but they seem to be missing details around the Options section within the Hybrid Source Data of Scenario properties.Does anyone have any additional details around what options are available and a description of each? Or more content around Hybrid Source scenarios in general?Thanks,Added screenshot to provide context. 

Hello - is there a way to make the below work inside GetDataBufferUsingFormula .Getting Error processing script 'V#Periodic:F#EndBal_Input:A#:U1#USF02'.Dim SrcDataBuffer As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(V#Periodic:F#EndBal_Input:S#Actual:T#" & sLastActMth & ":U1#" & mCostCenter.Member.name & ",[A#[PNL].Base.Where((Name StartsWith '4') or (Name StartsWith '5') or (Name StartsWith '7') or (Name StartsWith 'X'))], [U3#[TopUD3].Base],[U2#[TopUD2].Base])").Looks like not recognizing filter with 'or' inside where clause.  Below works fine without an 'or' condition.Dim SrcDataBuffer As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(V#Periodic:F#EndBal_Input:S#Actual:T#" & sLastActMth & ":U1#" & mCostCenter.Member.name & ",[A#[PNL].Base.Where(Name StartsWith '4')], [U3#[TopUD3].Base],[U2#[TopUD2].Base])").

Hi, we are currently in the process of Finalizing a Data integration process (via connector) between some temporary staging tables created in the Onestream application (on cloud), but when i try to perform the final step to load the data, the system always returns me the message that allof the rows i'm importing are NON-NUMERIC. Obviously that's not the case. the source table amount column is a numeric format and the amount field in the source field is being mapped to the Amount field in the data source.  Did Anyone experience this?Thanks

Hi all,I have an issue with table view number formatting. On my SQL query, I'm introducing the format: Select FORMAT (Sum(Year_01), 'N2', 'es-es') as Year_01 ")After that, I populate the table view applying the true option in "UseDataTypes"tv.PopulateFromDataTable(dt, True, True)My issue is the next one: the format seems correct but, after openning or refreshing the tableview, it introduces the value as Text. I must enter on a cell and click the enter button to be able to recognize it as number.  Does anyone have the same issue? Thanks,Albert  

We have a workflow that uses Data Management Export Sequence to load the data. Manually we are loading the data fine but I'm looking for any options to automate this process.I have an example if the workflow uses a connector business rule but not sure on the Data Management Export Sequence. If anyone can help, it would be great...!!!

Hey all, I'm struggling to figure out how to define a TableViewColumn to be of type Decimal instead of the default type being Text. I'm in the section where I create a TableViewRowHeader and adding TableViewColumns to it. I can create a new column: Dim myTableViewColumn As New TableViewColumn myTableViewColumn.Name = "Col1" But when I try to set the type to this column, I get an error " Input string was not in a correct format." when trying to retrieve the table: myTableViewColumn.DataType = XFDataType.Decimal Is this syntax correct? I'm assuming that it's in the column definition where I should be defining the datatype but now not so sure. Hopefully someone can point me in the right direction.   As a side note,  page 15 in the Table Views User Guide makes reference to a function called CreateTableViewColumn. Is this a custom function or part of the OS library. The compiler doesn't recognize this function.    

Hi I'm trying to link this form to an Headcount correction form but when I navigated to this linked form, It shows me in the Group adj column green cells. How can I make them imputable? 

Is there any way we can use the transformation profile one to one mappings in a data table. Preferable to use in a connecter Drill back code. Is there any Data base table for the same.If not, we have a create a custom XFC table in application DB to refer the same that replicates the transformation profile.

Hi,I have set one Time Profile in one cube from Oct 2018 to Sep 2019 (first fiscal year) and another Time Profile in different cube from Jan 2019 to Dec 2019 (second fiscal year). I need to present Consolidated Report of both periods from beginning of both fiscal years simultaneously in one dashboard. Can anyone help ?