Workflow and Data Integration

I am trying to load stage data via Excel and having an issue I am not sure how to fix.  I am loading data, including for attribute values 1 and 2 (AV1# and AV2#).  However, if there is a zero in either AV1 or AV2 the row is suppressed, even if there is a non-zero value in the other attribute dimension.  Is there a way around this behavior with a special token I can add or some other change?

Originally posted by Nick Tracyis there a way that a users can see when the last load for an entity is?  Is it possible to present that in a dashboard or a cube view (cubeview would be embedded in our various internal worksheets).   This is just so during our close process someone can know look at OneStream and know if they are using the most recent data.  Sometimes management updates the GL fast and furiously during the close and OneStream may not always reflect the GL.   I would like an easy way for a User to be able to easily view when the last load was.   An example was a User knows the GL had updates at 9:30 am, requests the system to be updated, at 10:00 they "think" it is and use old data while the Admin updates OneStream at 10:07 or something (some people are impatient).  I would like them to be able to see there hasn't been any new loads since their request and so they know they aren't using updated data.  

Hello all,I am looking to spread budget data across 12 months evenly, however my source is only designated one time.I am looking to split time into all twelve months of the year and divide the amounts accordingly. Is this possible? 

I am trying to query the data from the client source database through a Data Adapter, but it is returning this error:Is this an issue with our setup on the OneStream end or something with the database configuration on the client side?

Hello! I'm trying to import a SharePoint file into OneStream using a business rule. I've not found any documentation/comments which are helpful. Does anyone have any ideas on how this can be done?  Thanks! 

Hi, we have delimited data source implemented in application. In data source we have two additional rows on top and one empty row- file works fine but now we want to retrieve information("Chicago") from skipped row(number 2). It looks that OneStream read data starting from row number 5.  Could you please help me with understanding why these first rows were skipped? Thank you in advance.

Hello all, I need to verify and confirm the method of choice to set up an NS to OS 8.5 integration WITHOUT the SIC in play.Here is what I have uncovered thus far....A SuiteAnalytics Connect is being considered via ODBC so OS can pull data from NS.  I read a few things about this.  One is that a BR would be set up in OS to call on a SuiteScript in NS initiate the data pull.  Now, the missing piece is how to set up the connection in OS if there is no ODBC installed.  Another thing is that SIC would not be needed.I also perused a blog that stated that Support can set up s direct connection to NS from OS, provided they have the NS info.  Can anyone please confirm this approach?Rest API could be leveraged but looking for an alternative. Any input would be greatly appreciated.Thanks,Ed P 

Hello, I've successfully set up an automatic upload using the Harvest Folder. However, I want to use the Skipline functionality within the file to reduce the import size. This works perfectly when I manually import the file into the specific Import Step. But when using the automatic upload via the Harvest Folder, the Skipline functionality doesn't seem to be applied. Does anyone have an idea for a possible workaround?

When we created our application years ago for a particular source our account mapping only needed the Source Account to map.  Now I have a need to do the account mapping based on a Location Source field that denotes a location for just two records exceptions.  Can I make a Composite Rule mapping that somehow includes the location from the Source file to create a composite rule for this exception or is the only solution to now include the source location field on my data source, and modify all the current mappings to have a wildcard for that field except my exceptions that need to be mapped to a different account.

Hi, I notice that with dashboards, when allowed to prompt the user for values for their parameters, save the  user's last used value in said dashboard and populate that as the default value when prompted. By comparison, cube views don't store that information, and populate whatever is in the default value for the parameter when prompted. Is it possible to change what behaviour is used when parameters are requested from the user from a dashboard, and how would I do so? Thanks! Alex

Dear Community, Is there any way to delete the workflow channels in bulk? Currently we are in the process of deleting the unused UD7 members in the application and the workflow channels are setup based on the UD7 members. Since the UD7 members and the channels are in huge volume. Just wanted to understand if there is any rule or a marketplace solution which can be used to delete the WF channels in bulk? Any solution would help. Thank you so much.

Hello, I am trying to query a local app which have 200k rows on SQL server using SIC (Smart Integration Cloud). However, I get the message : "Received an unexpected EOF or 0 bytes from the transport stream." There is an online troubleshooting which I added below. It seems this is a memory issue. However, there's no mention on how to add memory (on the server ? on my local machine ? how to do it ?). --> could you please help me sorting this out ? Regards, EDIT : I get the same error message when querying a table of only 1 row, 1 column. Memory Issues If you receive any of the following errors, increase the memory in your Smart Integration Connector Local Gateway Server. For queries returning over 1 million records, 32 GB or more RAM is recommended. "Error while copying content to a stream. Received an unexpected EOF or 0 bytes from the transport stream." "An error occurred while sending the request. The response ended prematu

One user has to access one entity and all products which means they can view all the products belongs to the one entity. what type of security want to use. can someone guide me.

Can I use Attribute dimension to write composite mapping with other dimension?Context- I am reading extra column from a TB load to drive the mapping.I want store this additional information in Attribute dimension (and not using any free UD)  and use that to do composite mapping.Is it possible?

I am running some data loads using Batch Harvest. I want to be able to capture the Validate Transformation and Validate Intersections errors to include in an email.  I am able to get the Validate Intersections errors from the application table.  Does anyone know how I would get the Validate Transformation errors?   If I run the entire job within a BR then I can get the Transformation Errors, but I would rather run it through the Batch Harvest.  I appreciate any input.Thank you.Scott

HI Guys,  Is there anyway via a method query or rule in a data adaptor that I can specify parameters to give me all file names related to a workflow. I preferably want all file names in a specific workflow for all years in a data table of columns: (Workflow,Year,Filename). Presumably doable with a dashboard data set rule but Ive never played with the staging engine before!  Guessing also that its probably a case of looping years and appending tables.  Thanks,   Tom

Hello Integration Experts,I would like to know what are the alternatives we have to Integrate Netsuite with OneStream and which is best among RESTAPI and ODBC. Thanks

Is there a way to load to multiple scenarios from one Workflow? Example, from the below Workflow POV, I want to load to the Actual_PP scenario, but also to the Forecast_PP scenario. I don't want to create a new workflow for forecast because I want to use the values from People Planning that have been calculated for Actual_PP to populate both scenarios.  I don't what to load the People Planning register twice and calculate it twice.

Hi,I have an admin dashboard where I show all parameter values and information I need before I start my Data mgmt jobs. There is one value I dont figure out how to show in my dashboard. I have a Conditional input rule on the Cube. Can I create a parameter or Data Adapter or something to be able to pull the value and show in my dashboard? I only need to retrieve the Scenario value.  

Dear community,My company has just switched over to v8 and we are in the works of switching over from a current rest API to the Power BI connector.Is there any guide or thread that goes through how to set the prompts for the connector? I get a little bit confused as to what needs to be filled in. For example, the prompt asks me to fill in "Entity" and many other dimension parameters - however, our business consists of many, many entities and I would not like to create one data connection for each one of them. Same goes for "Account" and many other fields, none of which I am able to leave blank.Any advice? Rasmus 

Hi,I've got a business rule where I use BRApi.Workflow.Metadata.GetParent(si, si.WorkflowClusterPk) to look at the status of the parent workflow profile. However, if a user does not have access to the parent workflow profile, then they get an error "Security Access Error. User is not authorized to access workflow profile". So it seems that the function BRApi.Workflow.Metadata.GetParent(si, si.WorkflowClusterPk) is not very useful and it is a bit bizarre that it refers to user security. Is there a way to run this business rule as administrator perhaps or something else I can do?

I recently discovered that data from deleted Scenarios is not removed from many of the application data tables (XFW_PLP_Plan, XFW_PLP_Register, ...)   Does anyone know why it remains and is it safe to remove as the scenario no longer exists.   I would think removing the old data would improve performance and reduce db size.    Or am I unaware of the tools to perform such maintenance?

Any ideas what attributes this message might be referring to? There are no errors in the error log and the Task activity shows reconciliation discovery was completed, yet New = (0). Thank you for any leads in advance!  

I created a detail account dimension without creating a summary account dimension first.  When I attempt to create a summary account dimension now, I get an error message indicating the member already exists.  I tried to delete the detailed dimension and start over but there is already data saved.  How can I correct this?

Hello there,  can someone please share a sample transformation event handler code to map an unknown dimension member to a "placeholder" in the same dimension when validation step fails? Appreciate it!