Recent Discussions
Including Journal Entries from Different Origin Member in Account Reconciliation Discovery
Hi Community, I’m working on an Account Reconciliation solution where I need to ensure posted journal entries balances are also included in the Account Reconciliation discovery process. Currently, by design the Discovery process only pulls trial balance information already imported and validated in the Stage. Therefore, I wanted to check if there’s a recommended, or best practice approach, to accomplish this requirement. Any guidance or examples would be greatly appreciated, thanks in advance for your help!
Delimited data source with skipped rows
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.
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!
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! Alex
Bulk 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.Composite Mapping
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?
