OneStream Platform Forums

Hi Team, I would like to fetch and update the Entity Relationship Properties for the Entity Dimension members via Business Rules.The below peace of code works fine for only when I pass the Actual and Budget but when i pass the other scenario Type like Scenariotype 1 to 8   I get the error Object is not set to an instance of an object.Dim Scenario As String = args.CustSubstVarsAlreadyResolved("Param_SecnarioType_EO_24")'The above value i get it from the combo box as delimited list Dim Scenarioid As Integer = BRApi.Finance.Members.GetMemberId(si,dimtype.Scenario.Id,Scenario)Dim MyScenarioTypeid As ScenarioType = BRApi.Finance.Scenario.GetScenarioType(si,Scenarioid)Dim Timefilter As String = args.CustSubstVarsAlreadyResolved("Param_Time_24")Dim Timeid As Integer = BRApi.Finance.Members.GetMemberId(si,dimtype.Time.Id,Timefilter)Can you please help me with the correct way to get the scenario Type.

Is it possible to create a Roadmap inside of OneStream? If so, I am looking for some guidance on how that can be accomplished and how difficult it would be to maintain and update the roadmap when needed. 

Hi, I'm trying to build a getdataset rule for the first time in ws assembly. I ran into this compile error while setting up service factory, any idea why? Thank you.  

Hi everyone, I am very much new to OneStream but i am not able to see any resources for learning about OneStream. Can someone guide my about finding the right sources for getting started and learn the basics of onestream

Hi, I am using an XFGetCell Formula which references the POV for Time. I would like to use a formula to pull in the period prior to the POV in the same worksheet and keep it dynamic based on the POV.  Any suggestions? If it's not possible to do in the formula, I will need to create a UD8 to return the prior period time.  Does anyone have a ready-made formula for this?  I would greatly appreciate it! Thanks!         Thanks!

Hello,Has anyone seen this before where the task scheduler looks as if it will skip a date? Under the grid view, the autoloads highlighted are skipping 10/1/24 even though they are all set to run the first and the second day of every month. Weirdly enough, under the calendar view, they are listed correctly under 10/1 date column and after a few switches back and forth it reset itself back to 10/1 without any other action. Any idea would be appreciated. 

Need assistance building this logic in for two conditional statements to return a value. The logic reads if one row is greater than 0.20 and another row is greater than 0.20, then 0 is the cell value. If not, then 1 is the cell value. Please let me know if I can provide any additional details. 

Dear all, Could you please advise how to show Text field of Entity member in cube view instead of Entity Name. For example, I have: Entity member with Name A, it has Text1 field Country 1, Entity member with Name B, it has Text1 field Country 2 Entity member with Name C, it has Text1 field Country 2 I would like to show in cube view in rows figures on Country 1 and Country 2 (so I need to aggregate figures of Entity B and C in this row). Could you please advise is it possible? If it isn't possible to aggregate figures, could you please advise if I can simply show three rows Country 1, Country 2, Country 2 in cube view instead of Names.

Hello, it's probably simple question to solve, but I wasn't able to find a solution.Is it possible to display the dimensions (master data) of the query in the cube views?e.g. columns, CV should generate a table with the following: Account | Amount | Cost Centre Number | Cost Centre Name | Profit Centre | Profit Centre Name |... and so on. I have tried it via UD (where the information is located), but I only get the amounts, but not the elements/master data/dimension or description. What am I doing wrong? Thank you!  

G'day, Pls share if there is an Excel template for Cubes like the Metadata Builder for Dims and Workflows.That will help us update OS Dimensions in many Data Cubes with various Scenario Types. TY.

Are there any out box reports available to show constraints by dimension?

I have created a literal value parameter  for entity that I want to refer in my finance rules for calculation.   Can someone share me a code where I can look up values from a parameter I set instead of running a  E#Root.base or something. Running a E#Root.base where txt1='value' is not an option .   Thanks

Has anyone had success taking a date, say 12/2/2024, and the cube name I assume, and converting it to a period like 2024M12?

Hi , i am trying to copy between scenario through hybrid copy scenario feature but i observer that wherever only USD value present for non USD entities , data copy not happening. could anyone please suggest if anybody come across this scenario. 

I have come across a validation error that is kind of vague. I created a new entity, confirmed it is setup the same way as its sibling, and added it to my transformation rules, but my validation step kicks out an error. Any ideas?  

Hi, We have installed NRR and are able to upload documents. However, adding a cube view using the syntax is not working. Despite searching related articles and trying different syntax variations, the cube still fails to render:Syntax 1:{DOCVARIABLE"{XF}{Application}{CubeViewReport}{Abseentism_Rep}""IncludeReportMargins=False" "IncludeReportHeader=False""IncludeReportFooter=False" "IncludePageHeader=True""IncludePageFooter=True""}Syntax 2:"{XF}{Application}{CubeViewReport}{Abseentism_Rep}"We are on V8.2.2, does anyone have any tips? 

Hi Everyone. I had a Business Rule that checked the Workflow table to see if a scenario was blocked, but it always showed WFProfiles as blocked. I don’t know where this information is coming from, as those WFProfiles were unblocked in the environment but appeared as blocked in the table. How can I verify this information?  

Hi,I have designed a dashboard using SQL adapter and have stitched multiple OS tables.Current ask is to integrate this dashboard data and sent it out to an external db.I can create a table in the external db reflecting the same column structure.What is an efficient way to integrate this data from OS dashboard to external db-FYI- I have SIC in place.Thanks for your time

Hi Everyone. What I want to do is change the value of: si.WorkflowClusterPk.ProfileKey What I want to change is the ProfileKey of a Profile that can obtain the value by name. I need to make this change to modify a process that relies solely on the information from this attribute. Therefore, I would be grateful for your assistance.

Dear all, Could you please advise is it possible to combine several cube views into single Excel file and download it from the application? If so, could you please advise how to do that.

Hello All,I want to use application reports Market place solution to get the journals for all workflow profiles. How to achieve this. Currently I get journals for only one workflow profile as per your select WF POV. Is there a way to get the journals for all workflow profiles as a report in one go.Thanks

Hi All I am upgrading the MarketPlace app Reporting Compliance (TCR) so that it has its own separate Workspace (V8.1). I have added the Business Rules as assembly files and they all work. The current environment (V6.8) has a Data Management job to run calculations so I am now adding a Data Management job to the WorkSpace Data Management Groups. The only problem is that when I add a step (type Execute Business Rule) to the Workspace Data Management Step, the drop down list only shows Business Rules in the general Business Rules area and not the file assembly area. How do I get the Workspace specific Business Rules in the Workspace specific Data Management Groups? Thanks

Hello,Does anyone know an effective way to alter the amount column of a table using a SQL script?Use case: the client is bringing in what they call "Production Downtime" to the system, which shows hours of downtime by plant based on a reason (attribute). Using a Dashboard Data Set rule, I created a SQL query to return specific results from the stage table based on Entity and Plant selections. This rule is linked to a data adapter and fed into the BI Viewer.In their BI Viewer report, it shows current Month vs PY Month. Since this data is coming in daily, when the user is looking at the current month, (today is Nov 21) the current month shows 21 days' worth of downtime data. They would like the PY Month to also represent 21 days of data.So, I would like to create a "ratio" variable that reads the current day of month and divides by the total days in month, and multiply the PY data by it. I created something similar in a UD8 calc:(SQL Is not my strong suit) how can I apply this "ratio" to

Im having an issue with a transformation rulewhere i have on stage :- Account 5115-0001-UD2 2350-UD4 2020That combination of dimensions is being assigned by the following TRA#[5015~5115-0406~0408]:UD4#[2001~2010]:UD2#[2002~2203]I believe the problem is in the Account range, but do not understand why. can someone explain the reason why?

We are trying to build a one side match rule for AR TXM. Within our DS1, we have transactions that combine and net to zero. We are finding that the one side rule is matching transactions by the amount instead of first summing the group of transactions to zero, which is resulting in incorrect matches. Is there a way to match negative amounts to positive amounts of the same balance (i.e. absolute value, but then we still need the net to be an accurate zero). Is there a way to leave the "amount" field off of the definition page. Also, whenever we try to enter in a tolerance, we get an error message to select the tolerance type, but there is no option to do so on a one-side rule.   We are having the same issue with the many to many rules where the rule is not summing up the transactions into one before executing match