Recent Discussions
Workflow Lock / Unlock Dashboard
Was asked to create a dashboard that gives the HQ admin the ability to lock and unlock Workflow profiles. Found bits and parts to use the user POV and descendants. Unlock descendants isn't working but.. Was looking at member tree and some of the other tree functionality, but couldn't get it to work for profiles. My thought is the profile hierarchy then they would select what to lock or unlock. Was curious if anyone had any recommendations or solutions they could share? Appreciate it in advance!
No valid DataKeys (Scenario / Time) found in data source.
Hello everyone, I'm trying to create my first import from scratch. Unfortunately, it always gives me the same error : No valid DataKeys (Scenario / Time) found in data source. Review the source data load processing log and check one-to-one transformation rules to ensure that you have created proper Scenario and Time dimension rules for this data source. And no line is imported or displayed in the logs. However, I've gone down each parameter and everything seems correct and consistent with what I have on other import files. Could you help me investigate? My settings : All the UD1 to UD8 are on None. And the log :
Ability to refer to a source field in a composite transformation rule
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.
Import parser on a Batch File
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?
Modifying default value parameter behaviour in dashboards
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! AlexBulk deletion of Workflow Channels
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.Unable to load Data into OneStream
Hi, We are currently attempting to load data into the OneStream Workflow Profile using a CSV file. However, we are encountering the following error during the process: We checked many videos and the training courses but couldn't identify where the issues is, Could you please assist us in identifying and resolving the issue? RegardsSmart Integration Cloud (SIC) error
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 prematurely."
