Hello
I've tried to load my excel file through the data source fixed files with a complex expression on the time dimension, and i think it doesn't go through the complex expression at all so i'm wondering if i can use a complex expression in fixed file data source ?
\n
The check i'm trying to do is to verify the workflow period and the time that's in my load file. if it's the same it can continue loading but if it's different i'm asking OS to pop up a error message.
If anyone has an idea please share it with me
Thanks 🙂
You reference a BR from any particular dimension, in Logical Operator functional area.
","body@stringLength":"93","rawBody":"You reference a BR from any particular dimension, in Logical Operator functional area.
","kudosSumWeight":0,"repliesCount":0,"postTime":"2021-12-14T08:50:39.563-08:00","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"attachments":{"__typename":"AttachmentConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:3592_1"},"latestVersion":null,"metrics":{"__typename":"MessageMetrics","views":5688},"visibilityScope":"PUBLIC","isEscalated":null,"placeholder":false,"originalMessageForPlaceholder":null,"messagePolicies":{"__typename":"MessagePolicies","canModerateSpamMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","args":[]}}},"customFields":[],"replies":{"__typename":"MessageConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"CachedAsset:theme:customTheme1-1746700259777":{"__typename":"CachedAsset","id":"theme:customTheme1-1746700259777","value":{"id":"customTheme1","animation":{"fast":"150ms","normal":"250ms","slow":"500ms","slowest":"750ms","function":"cubic-bezier(0.07, 0.91, 0.51, 1)","__typename":"AnimationThemeSettings"},"avatar":{"borderRadius":"50%","collections":["default"],"__typename":"AvatarThemeSettings"},"basics":{"browserIcon":{"imageAssetName":"OneStream_Symbol_Black-1728623750904.png","imageLastModified":"1728623754994","__typename":"ThemeAsset"},"customerLogo":{"imageAssetName":"Community_Logo_V2-1728623741343.png","imageLastModified":"1728623745056","__typename":"ThemeAsset"},"maximumWidthOfPageContent":"1500px","oneColumnNarrowWidth":"800px","gridGutterWidthMd":"30px","gridGutterWidthXs":"10px","pageWidthStyle":"WIDTH_OF_BROWSER","__typename":"BasicsThemeSettings"},"buttons":{"borderRadiusSm":"0","borderRadius":"0","borderRadiusLg":"0","paddingY":"5px","paddingYLg":"7px","paddingYHero":"var(--lia-bs-btn-padding-y-lg)","paddingX":"12px","paddingXLg":"16px","paddingXHero":"60px","fontStyle":"NORMAL","fontWeight":"400","textTransform":"NONE","disabledOpacity":0.5,"primaryTextColor":"var(--lia-bs-white)","primaryTextHoverColor":"var(--lia-bs-white)","primaryTextActiveColor":"var(--lia-bs-white)","primaryBgColor":"var(--lia-bs-body-color)","primaryBgHoverColor":"hsl(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), calc(var(--lia-bs-body-color-l) * 0.85))","primaryBgActiveColor":"hsl(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), calc(var(--lia-bs-body-color-l) * 0.7))","primaryBorder":"1px solid transparent","primaryBorderHover":"1px solid transparent","primaryBorderActive":"1px solid transparent","primaryBorderFocus":"1px solid var(--lia-bs-white)","primaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-body-color), 0 0 0 4px hsla(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), var(--lia-bs-body-color-l), 0.2)","secondaryTextColor":"var(--lia-bs-white)","secondaryTextHoverColor":"var(--lia-bs-white)","secondaryTextActiveColor":"var(--lia-bs-white)","secondaryBgColor":"var(--lia-bs-body-color)","secondaryBgHoverColor":"hsl(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), calc(var(--lia-bs-body-color-l) * 0.85))","secondaryBgActiveColor":"hsl(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), calc(var(--lia-bs-body-color-l) * 0.7))","secondaryBorder":"1px solid transparent","secondaryBorderHover":"1px solid transparent","secondaryBorderActive":"1px solid transparent","secondaryBorderFocus":"1px solid transparent","secondaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-body-color), 0 0 0 4px hsla(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), var(--lia-bs-body-color-l), 0.2)","tertiaryTextColor":"var(--lia-bs-body-color)","tertiaryTextHoverColor":"hsl(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), calc(var(--lia-bs-body-color-l) * 0.95))","tertiaryTextActiveColor":"hsl(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), calc(var(--lia-bs-body-color-l) * 0.9))","tertiaryBgColor":"transparent","tertiaryBgHoverColor":"transparent","tertiaryBgActiveColor":"hsla(var(--lia-bs-gray-400-h), var(--lia-bs-gray-400-s), var(--lia-bs-gray-400-l), 0.04)","tertiaryBorder":"1px solid transparent","tertiaryBorderHover":"1px solid hsla(var(--lia-bs-gray-400-h), var(--lia-bs-gray-400-s), var(--lia-bs-gray-400-l), 0.08)","tertiaryBorderActive":"1px solid transparent","tertiaryBorderFocus":"1px solid transparent","tertiaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-body-color), 0 0 0 4px hsla(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), var(--lia-bs-body-color-l), 0.2)","destructiveTextColor":"var(--lia-bs-danger)","destructiveTextHoverColor":"hsl(var(--lia-bs-danger-h), var(--lia-bs-danger-s), calc(var(--lia-bs-danger-l) * 0.95))","destructiveTextActiveColor":"hsl(var(--lia-bs-danger-h), var(--lia-bs-danger-s), calc(var(--lia-bs-danger-l) * 0.9))","destructiveBgColor":"var(--lia-bs-gray-200)","destructiveBgHoverColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.96))","destructiveBgActiveColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.92))","destructiveBorder":"1px solid transparent","destructiveBorderHover":"1px solid transparent","destructiveBorderActive":"1px solid transparent","destructiveBorderFocus":"1px solid transparent","destructiveBoxShadowFocus":"0 0 0 1px var(--lia-bs-body-color), 0 0 0 4px hsla(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), var(--lia-bs-body-color-l), 0.2)","__typename":"ButtonsThemeSettings"},"border":{"color":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","mainContent":"LIGHT","sideContent":"LIGHT","radiusSm":"3px","radius":"5px","radiusLg":"9px","radius50":"100vw","__typename":"BorderThemeSettings"},"boxShadow":{"xs":"0 0 0 1px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.08), 0 3px 0 -1px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.08)","sm":"0 2px 4px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.06)","md":"0 5px 15px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.15)","lg":"0 10px 30px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.15)","__typename":"BoxShadowThemeSettings"},"cards":{"bgColor":"var(--lia-panel-bg-color)","borderRadius":"var(--lia-panel-border-radius)","boxShadow":"var(--lia-box-shadow-xs)","__typename":"CardsThemeSettings"},"chip":{"maxWidth":"300px","height":"30px","__typename":"ChipThemeSettings"},"coreTypes":{"defaultMessageLinkColor":"#5564FF","defaultMessageLinkDecoration":"none","defaultMessageLinkFontStyle":"NORMAL","defaultMessageLinkFontWeight":"400","defaultMessageFontStyle":"NORMAL","defaultMessageFontWeight":"400","defaultMessageFontFamily":"var(--lia-bs-font-family-base)","forumColor":"#5564FF","forumFontFamily":"var(--lia-bs-font-family-base)","forumFontWeight":"var(--lia-default-message-font-weight)","forumLineHeight":"var(--lia-bs-line-height-base)","forumFontStyle":"var(--lia-default-message-font-style)","forumMessageLinkColor":"var(--lia-default-message-link-color)","forumMessageLinkDecoration":"var(--lia-default-message-link-decoration)","forumMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","forumMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","forumSolvedColor":"#00985B","blogColor":"#6E26C1","blogFontFamily":"var(--lia-bs-font-family-base)","blogFontWeight":"var(--lia-default-message-font-weight)","blogLineHeight":"1.75","blogFontStyle":"var(--lia-default-message-font-style)","blogMessageLinkColor":"var(--lia-default-message-link-color)","blogMessageLinkDecoration":"var(--lia-default-message-link-decoration)","blogMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","blogMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","tkbColor":"#FF8FB4","tkbFontFamily":"var(--lia-bs-font-family-base)","tkbFontWeight":"var(--lia-default-message-font-weight)","tkbLineHeight":"1.75","tkbFontStyle":"var(--lia-default-message-font-style)","tkbMessageLinkColor":"var(--lia-default-message-link-color)","tkbMessageLinkDecoration":"var(--lia-default-message-link-decoration)","tkbMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","tkbMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","qandaColor":"#4099E2","qandaFontFamily":"var(--lia-bs-font-family-base)","qandaFontWeight":"var(--lia-default-message-font-weight)","qandaLineHeight":"var(--lia-bs-line-height-base)","qandaFontStyle":"var(--lia-default-message-link-font-style)","qandaMessageLinkColor":"var(--lia-default-message-link-color)","qandaMessageLinkDecoration":"var(--lia-default-message-link-decoration)","qandaMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","qandaMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","qandaSolvedColor":"#3FA023","ideaColor":"#FFCB11","ideaFontFamily":"var(--lia-bs-font-family-base)","ideaFontWeight":"var(--lia-default-message-font-weight)","ideaLineHeight":"var(--lia-bs-line-height-base)","ideaFontStyle":"var(--lia-default-message-font-style)","ideaMessageLinkColor":"var(--lia-default-message-link-color)","ideaMessageLinkDecoration":"var(--lia-default-message-link-decoration)","ideaMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","ideaMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","contestColor":"#FCC845","contestFontFamily":"var(--lia-bs-font-family-base)","contestFontWeight":"var(--lia-default-message-font-weight)","contestLineHeight":"var(--lia-bs-line-height-base)","contestFontStyle":"var(--lia-default-message-link-font-style)","contestMessageLinkColor":"var(--lia-default-message-link-color)","contestMessageLinkDecoration":"var(--lia-default-message-link-decoration)","contestMessageLinkFontStyle":"ITALIC","contestMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","occasionColor":"#B6BDFF","occasionFontFamily":"var(--lia-bs-font-family-base)","occasionFontWeight":"var(--lia-default-message-font-weight)","occasionLineHeight":"var(--lia-bs-line-height-base)","occasionFontStyle":"var(--lia-default-message-font-style)","occasionMessageLinkColor":"var(--lia-default-message-link-color)","occasionMessageLinkDecoration":"var(--lia-default-message-link-decoration)","occasionMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","occasionMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","grouphubColor":"#333333","categoryColor":"#949494","communityColor":"#FFFFFF","productColor":"#949494","__typename":"CoreTypesThemeSettings"},"colors":{"black":"#000000","white":"#FFFFFF","gray100":"#F7F7F7","gray200":"#F7F7F7","gray300":"#E8E8E8","gray400":"#D9D9D9","gray500":"#CCCCCC","gray600":"#949494","gray700":"#707070","gray800":"#545454","gray900":"#333333","dark":"#545454","light":"#F7F7F7","primary":"#373737","secondary":"#333333","bodyText":"#000000","bodyBg":"#F7F7F7","info":"#409AE2","success":"#41C5AE","warning":"#FCC844","danger":"#D13A1F","alertSystem":"#FF6600","textMuted":"#707070","highlight":"#FFFCAD","outline":"var(--lia-bs-primary)","custom":["#5564FF","#FF0000","#0099AA","#3D65C9","#0033FF","#660099"],"__typename":"ColorsThemeSettings"},"divider":{"size":"3px","marginLeft":"4px","marginRight":"4px","borderRadius":"50%","bgColor":"var(--lia-bs-gray-600)","bgColorActive":"var(--lia-bs-gray-600)","__typename":"DividerThemeSettings"},"dropdown":{"fontSize":"var(--lia-bs-font-size-sm)","borderColor":"var(--lia-bs-border-color)","borderRadius":"var(--lia-bs-border-radius-sm)","dividerBg":"var(--lia-bs-gray-300)","itemPaddingY":"5px","itemPaddingX":"20px","headerColor":"var(--lia-bs-gray-700)","__typename":"DropdownThemeSettings"},"email":null,"emoji":{"skinToneDefault":"#ffcd43","skinToneLight":"#fae3c5","skinToneMediumLight":"#e2cfa5","skinToneMedium":"#daa478","skinToneMediumDark":"#a78058","skinToneDark":"#5e4d43","__typename":"EmojiThemeSettings"},"heading":{"color":"var(--lia-bs-body-color)","fontFamily":"OneStream Sans","fontStyle":"NORMAL","fontWeight":"400","h1FontSize":"34px","h2FontSize":"32px","h3FontSize":"28px","h4FontSize":"24px","h5FontSize":"20px","h6FontSize":"16px","lineHeight":"1.3","subHeaderFontSize":"11px","subHeaderFontWeight":"500","h1LetterSpacing":"normal","h2LetterSpacing":"normal","h3LetterSpacing":"normal","h4LetterSpacing":"normal","h5LetterSpacing":"normal","h6LetterSpacing":"normal","subHeaderLetterSpacing":"2px","h1FontWeight":"var(--lia-bs-headings-font-weight)","h2FontWeight":"var(--lia-bs-headings-font-weight)","h3FontWeight":"var(--lia-bs-headings-font-weight)","h4FontWeight":"var(--lia-bs-headings-font-weight)","h5FontWeight":"var(--lia-bs-headings-font-weight)","h6FontWeight":"var(--lia-bs-headings-font-weight)","__typename":"HeadingThemeSettings"},"icons":{"size10":"10px","size12":"12px","size14":"14px","size16":"16px","size20":"20px","size24":"24px","size30":"30px","size40":"40px","size50":"50px","size60":"60px","size80":"80px","size120":"120px","size160":"160px","__typename":"IconsThemeSettings"},"imagePreview":{"bgColor":"var(--lia-bs-gray-900)","titleColor":"var(--lia-bs-white)","controlColor":"var(--lia-bs-white)","controlBgColor":"var(--lia-bs-gray-800)","__typename":"ImagePreviewThemeSettings"},"input":{"borderColor":"var(--lia-bs-gray-600)","disabledColor":"var(--lia-bs-gray-600)","focusBorderColor":"var(--lia-bs-primary)","labelMarginBottom":"10px","btnFontSize":"var(--lia-bs-font-size-sm)","focusBoxShadow":"0 0 0 3px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","checkLabelMarginBottom":"2px","checkboxBorderRadius":"3px","borderRadiusSm":"var(--lia-bs-border-radius-sm)","borderRadius":"var(--lia-bs-border-radius)","borderRadiusLg":"var(--lia-bs-border-radius-lg)","formTextMarginTop":"4px","textAreaBorderRadius":"var(--lia-bs-border-radius)","activeFillColor":"var(--lia-bs-primary)","__typename":"InputThemeSettings"},"loading":{"dotDarkColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.2)","dotLightColor":"hsla(var(--lia-bs-white-h), var(--lia-bs-white-s), var(--lia-bs-white-l), 0.5)","barDarkColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.06)","barLightColor":"hsla(var(--lia-bs-white-h), var(--lia-bs-white-s), var(--lia-bs-white-l), 0.4)","__typename":"LoadingThemeSettings"},"link":{"color":"#5564FF","hoverColor":"#5564FF","decoration":"none","hoverDecoration":"underline","__typename":"LinkThemeSettings"},"listGroup":{"itemPaddingY":"15px","itemPaddingX":"15px","borderColor":"var(--lia-bs-gray-300)","__typename":"ListGroupThemeSettings"},"modal":{"contentTextColor":"var(--lia-bs-body-color)","contentBg":"var(--lia-bs-white)","backgroundBg":"var(--lia-bs-black)","smSize":"440px","mdSize":"760px","lgSize":"1080px","backdropOpacity":0.3,"contentBoxShadowXs":"var(--lia-bs-box-shadow-sm)","contentBoxShadow":"var(--lia-bs-box-shadow)","headerFontWeight":"700","__typename":"ModalThemeSettings"},"navbar":{"position":"FIXED","background":{"attachment":null,"clip":null,"color":"var(--lia-bs-white)","imageAssetName":"","imageLastModified":"0","origin":null,"position":"CENTER_CENTER","repeat":"NO_REPEAT","size":"COVER","__typename":"BackgroundProps"},"backgroundOpacity":0.8,"paddingTop":"15px","paddingBottom":"15px","borderBottom":"1px solid var(--lia-bs-border-color)","boxShadow":"var(--lia-bs-box-shadow-sm)","brandMarginRight":"30px","brandMarginRightSm":"10px","brandLogoHeight":"30px","linkGap":"10px","linkJustifyContent":"flex-start","linkPaddingY":"5px","linkPaddingX":"10px","linkDropdownPaddingY":"9px","linkDropdownPaddingX":"var(--lia-nav-link-px)","linkColor":"var(--lia-bs-body-color)","linkHoverColor":"var(--lia-bs-primary)","linkFontSize":"var(--lia-bs-font-size-sm)","linkFontStyle":"NORMAL","linkFontWeight":"400","linkTextTransform":"NONE","linkLetterSpacing":"normal","linkBorderRadius":"var(--lia-bs-border-radius-sm)","linkBgColor":"transparent","linkBgHoverColor":"transparent","linkBorder":"none","linkBorderHover":"none","linkBoxShadow":"none","linkBoxShadowHover":"none","linkTextBorderBottom":"none","linkTextBorderBottomHover":"none","dropdownPaddingTop":"10px","dropdownPaddingBottom":"15px","dropdownPaddingX":"10px","dropdownMenuOffset":"2px","dropdownDividerMarginTop":"10px","dropdownDividerMarginBottom":"10px","dropdownBorderColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","controllerBgHoverColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.1)","controllerIconColor":"var(--lia-bs-body-color)","controllerIconHoverColor":"var(--lia-bs-body-color)","controllerTextColor":"var(--lia-nav-controller-icon-color)","controllerTextHoverColor":"var(--lia-nav-controller-icon-hover-color)","controllerHighlightColor":"hsla(30, 100%, 50%)","controllerHighlightTextColor":"var(--lia-yiq-light)","controllerBorderRadius":"var(--lia-border-radius-50)","hamburgerColor":"var(--lia-nav-controller-icon-color)","hamburgerHoverColor":"var(--lia-nav-controller-icon-color)","hamburgerBgColor":"transparent","hamburgerBgHoverColor":"transparent","hamburgerBorder":"none","hamburgerBorderHover":"none","collapseMenuMarginLeft":"20px","collapseMenuDividerBg":"var(--lia-nav-link-color)","collapseMenuDividerOpacity":0.16,"__typename":"NavbarThemeSettings"},"pager":{"textColor":"var(--lia-bs-link-color)","textFontWeight":"var(--lia-font-weight-md)","textFontSize":"var(--lia-bs-font-size-sm)","__typename":"PagerThemeSettings"},"panel":{"bgColor":"var(--lia-bs-white)","borderRadius":"var(--lia-bs-border-radius)","borderColor":"var(--lia-bs-border-color)","boxShadow":"none","__typename":"PanelThemeSettings"},"popover":{"arrowHeight":"8px","arrowWidth":"16px","maxWidth":"300px","minWidth":"100px","headerBg":"var(--lia-bs-white)","borderColor":"var(--lia-bs-border-color)","borderRadius":"var(--lia-bs-border-radius)","boxShadow":"0 0.5rem 1rem hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.15)","__typename":"PopoverThemeSettings"},"prism":{"color":"#000000","bgColor":"#f5f2f0","fontFamily":"var(--font-family-monospace)","fontSize":"var(--lia-bs-font-size-base)","fontWeightBold":"var(--lia-bs-font-weight-bold)","fontStyleItalic":"italic","tabSize":2,"highlightColor":"#b3d4fc","commentColor":"#62707e","punctuationColor":"#6f6f6f","namespaceOpacity":"0.7","propColor":"#990055","selectorColor":"#517a00","operatorColor":"#906736","operatorBgColor":"hsla(0, 0%, 100%, 0.5)","keywordColor":"#0076a9","functionColor":"#d3284b","variableColor":"#c14700","__typename":"PrismThemeSettings"},"rte":{"bgColor":"var(--lia-bs-white)","borderRadius":"var(--lia-panel-border-radius)","boxShadow":" var(--lia-panel-box-shadow)","customColor1":"#bfedd2","customColor2":"#fbeeb8","customColor3":"#f8cac6","customColor4":"#eccafa","customColor5":"#c2e0f4","customColor6":"#2dc26b","customColor7":"#f1c40f","customColor8":"#e03e2d","customColor9":"#b96ad9","customColor10":"#3598db","customColor11":"#169179","customColor12":"#e67e23","customColor13":"#ba372a","customColor14":"#843fa1","customColor15":"#236fa1","customColor16":"#ecf0f1","customColor17":"#ced4d9","customColor18":"#95a5a6","customColor19":"#7e8c8d","customColor20":"#34495e","customColor21":"#000000","customColor22":"#ffffff","defaultMessageHeaderMarginTop":"40px","defaultMessageHeaderMarginBottom":"20px","defaultMessageItemMarginTop":"0","defaultMessageItemMarginBottom":"30px","diffAddedColor":"hsla(170, 53%, 51%, 0.4)","diffChangedColor":"hsla(43, 97%, 63%, 0.4)","diffNoneColor":"hsla(0, 0%, 80%, 0.4)","diffRemovedColor":"hsla(9, 74%, 47%, 0.4)","specialMessageHeaderMarginTop":"40px","specialMessageHeaderMarginBottom":"20px","specialMessageItemMarginTop":"0","specialMessageItemMarginBottom":"30px","__typename":"RteThemeSettings"},"tags":{"bgColor":"var(--lia-bs-gray-200)","bgHoverColor":"var(--lia-bs-gray-400)","borderRadius":"var(--lia-bs-border-radius-sm)","color":"var(--lia-bs-body-color)","hoverColor":"var(--lia-bs-body-color)","fontWeight":"var(--lia-font-weight-md)","fontSize":"var(--lia-font-size-xxs)","textTransform":"UPPERCASE","letterSpacing":"0.5px","__typename":"TagsThemeSettings"},"toasts":{"borderRadius":"var(--lia-bs-border-radius)","paddingX":"12px","__typename":"ToastsThemeSettings"},"typography":{"fontFamilyBase":"OneStream Sans","fontStyleBase":"NORMAL","fontWeightBase":"400","fontWeightLight":"300","fontWeightNormal":"400","fontWeightMd":"500","fontWeightBold":"700","letterSpacingSm":"normal","letterSpacingXs":"normal","lineHeightBase":"1.5","fontSizeBase":"16px","fontSizeXxs":"11px","fontSizeXs":"12px","fontSizeSm":"14px","fontSizeLg":"20px","fontSizeXl":"24px","smallFontSize":"14px","customFonts":[{"source":"SERVER","name":"OneStream Sans","styles":[{"style":"NORMAL","weight":"400","__typename":"FontStyleData"},{"style":"NORMAL","weight":"500","__typename":"FontStyleData"}],"assetNames":["OneStreamSans-normal-400.woff2","OneStreamSans-normal-500.woff2"],"__typename":"CustomFont"}],"__typename":"TypographyThemeSettings"},"unstyledListItem":{"marginBottomSm":"5px","marginBottomMd":"10px","marginBottomLg":"15px","marginBottomXl":"20px","marginBottomXxl":"25px","__typename":"UnstyledListItemThemeSettings"},"yiq":{"light":"#ffffff","dark":"#000000","__typename":"YiqThemeSettings"},"colorLightness":{"primaryDark":0.36,"primaryLight":0.74,"primaryLighter":0.89,"primaryLightest":0.95,"infoDark":0.39,"infoLight":0.72,"infoLighter":0.85,"infoLightest":0.93,"successDark":0.24,"successLight":0.62,"successLighter":0.8,"successLightest":0.91,"warningDark":0.39,"warningLight":0.68,"warningLighter":0.84,"warningLightest":0.93,"dangerDark":0.41,"dangerLight":0.72,"dangerLighter":0.89,"dangerLightest":0.95,"__typename":"ColorLightnessThemeSettings"},"localOverride":false,"__typename":"Theme"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/Loading/LoadingDot-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Loading/LoadingDot-1746664278000","value":{"title":"Loading..."},"localOverride":false},"CachedAsset:quilt:onestream.prod:pages/forums/ForumMessagePage:board:Rules-1746725503391":{"__typename":"CachedAsset","id":"quilt:onestream.prod:pages/forums/ForumMessagePage:board:Rules-1746725503391","value":{"id":"ForumMessagePage","container":{"id":"Common","headerProps":{"backgroundImageProps":null,"backgroundColor":null,"addComponents":null,"removeComponents":["community.widget.bannerWidget"],"componentOrder":null,"__typename":"QuiltContainerSectionProps"},"headerComponentProps":{"community.widget.breadcrumbWidget":{"disableLastCrumbForDesktop":false}},"footerProps":null,"footerComponentProps":null,"items":[{"id":"message-list","layout":"MAIN_SIDE","bgColor":null,"showTitle":null,"showDescription":null,"textPosition":null,"textColor":null,"sectionEditLevel":null,"bgImage":null,"disableSpacing":null,"edgeToEdgeDisplay":null,"fullHeight":null,"showBorder":null,"__typename":"MainSideQuiltSection","columnMap":{"main":[{"id":"messages.widget.topicWithThreadedReplyListWidget","className":"lia-topic-with-replies","props":{"editLevel":"CONFIGURE"},"__typename":"QuiltComponent"}],"side":[{"id":"messages.widget.relatedContentWidget","className":null,"props":null,"__typename":"QuiltComponent"}],"__typename":"MainSideSectionColumns"}}],"__typename":"QuiltContainer"},"__typename":"Quilt","localOverride":false},"localOverride":false},"CachedAsset:text:en_US-components/common/EmailVerification-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/common/EmailVerification-1746664278000","value":{"email.verification.title":"Email Verification Required","email.verification.message.update.email":"To participate in the community, you must first verify your email address. The verification email was sent to {email}. To change your email, visit My Settings.","email.verification.message.resend.email":"To participate in the community, you must first verify your email address. The verification email was sent to {email}. Resend email."},"localOverride":false},"CachedAsset:text:en_US-pages/forums/ForumMessagePage-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-pages/forums/ForumMessagePage-1746664278000","value":{"title":"{contextMessageSubject} | {communityTitle}","errorMissing":"This message cannot be found","name":"Forum Message Page","section.message-list.title":"Forum Discussion","archivedMessageTitle":"This Content Has Been Archived"},"localOverride":false},"CachedAsset:text:en_US-components/common/ActionFeedback-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/common/ActionFeedback-1746664278000","value":{"joinedGroupHub.title":"Welcome","joinedGroupHub.message":"You are now a member of this group and are subscribed to updates.","groupHubInviteNotFound.title":"Invitation Not Found","groupHubInviteNotFound.message":"Sorry, we could not find your invitation to the group. The owner may have canceled the invite.","groupHubNotFound.title":"Group Not Found","groupHubNotFound.message":"The grouphub you tried to join does not exist. It may have been deleted.","existingGroupHubMember.title":"Already Joined","existingGroupHubMember.message":"You are already a member of this group.","accountLocked.title":"Account Locked","accountLocked.message":"Your account has been locked due to multiple failed attempts. Try again in {lockoutTime} minutes.","editedGroupHub.title":"Changes Saved","editedGroupHub.message":"Your group has been updated.","leftGroupHub.title":"Goodbye","leftGroupHub.message":"You are no longer a member of this group and will not receive future updates.","deletedGroupHub.title":"Deleted","deletedGroupHub.message":"The group has been deleted.","groupHubCreated.title":"Group Created","groupHubCreated.message":"{groupHubName} is ready to use","accountClosed.title":"Account Closed","accountClosed.message":"The account has been closed and you will now be redirected to the homepage","resetTokenExpired.title":"Reset Password Link has Expired","resetTokenExpired.message":"Try resetting your password again","invalidUrl.title":"Invalid URL","invalidUrl.message":"The URL you're using is not recognized. Verify your URL and try again.","accountClosedForUser.title":"Account Closed","accountClosedForUser.message":"{userName}'s account is closed","inviteTokenInvalid.title":"Invitation Invalid","inviteTokenInvalid.message":"Your invitation to the community has been canceled or expired.","inviteTokenError.title":"Invitation Verification Failed","inviteTokenError.message":"The url you are utilizing is not recognized. Verify your URL and try again","pageNotFound.title":"Access Denied","pageNotFound.message":"You do not have access to this area of the community or it doesn't exist","eventAttending.title":"Responded as Attending","eventAttending.message":"You'll be notified when there's new activity and reminded as the event approaches","eventInterested.title":"Responded as Interested","eventInterested.message":"You'll be notified when there's new activity and reminded as the event approaches","eventNotFound.title":"Event Not Found","eventNotFound.message":"The event you tried to respond to does not exist.","redirectToRelatedPage.title":"Showing Related Content","redirectToRelatedPageForBaseUsers.title":"Showing Related Content","redirectToRelatedPageForBaseUsers.message":"The content you are trying to access is archived","redirectToRelatedPage.message":"The content you are trying to access is archived","relatedUrl.archivalLink.flyoutMessage":"The content you are trying to access is archived View Archived Content"},"localOverride":false},"CachedAsset:quiltWrapper:onestream.prod:Common:1746700200455":{"__typename":"CachedAsset","id":"quiltWrapper:onestream.prod:Common:1746700200455","value":{"id":"Common","header":{"backgroundImageProps":{"assetName":null,"backgroundSize":"COVER","backgroundRepeat":"NO_REPEAT","backgroundPosition":"CENTER_CENTER","lastModified":null,"__typename":"BackgroundImageProps"},"backgroundColor":"transparent","items":[{"id":"community.widget.navbarWidget","props":{"showUserName":true,"showRegisterLink":true,"useIconLanguagePicker":true,"useLabelLanguagePicker":true,"links":{"sideLinks":[],"mainLinks":[{"children":[{"linkType":"INTERNAL","id":"app-build","params":{"boardId":"AppBuild","categoryId":"your-community"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"workflow-d-i","params":{"boardId":"WorkflowDI","categoryId":"your-community"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"rules","params":{"boardId":"Rules","categoryId":"your-community"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"reporting","params":{"boardId":"Reporting","categoryId":"your-community"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"solution-exchange","params":{"categoryId":"SolutionExchange"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"french-language-forum","params":{"boardId":"FrenchLanguageForum","categoryId":"your-community"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"academicalliances","params":{"boardId":"academicalliances","categoryId":"your-community"},"routeName":"ForumBoardPage"}],"linkType":"INTERNAL","id":"your-community","params":{"categoryId":"your-community"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"welcome","params":{"boardId":"welcome","categoryId":"resources"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"blog","params":{"boardId":"blog","categoryId":"resources"},"routeName":"BlogBoardPage"},{"linkType":"INTERNAL","id":"bulletins-1","params":{"categoryId":"technicaldocuments"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"tech-talks","params":{"boardId":"TechTalks","categoryId":"NewsAndViews"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"podcast","params":{"boardId":"Podcast","categoryId":"NewsAndViews"},"routeName":"ForumBoardPage"}],"linkType":"INTERNAL","id":"bulletins","params":{"categoryId":"Bulletins"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"financial-close-compliance-ideas","params":{"boardId":"FinancialCloseComplianceIdeas","categoryId":"Ideas"},"routeName":"IdeaBoardPage"},{"linkType":"INTERNAL","id":"planning-analysis-ideas","params":{"boardId":"PlanningAnalysisIdeas","categoryId":"Ideas"},"routeName":"IdeaBoardPage"},{"linkType":"INTERNAL","id":"advanced-analytics-ideas","params":{"boardId":"AdvancedAnalyticsIdeas","categoryId":"Ideas"},"routeName":"IdeaBoardPage"},{"linkType":"INTERNAL","id":"productivity-ideas","params":{"boardId":"ProductivityIdeas","categoryId":"Ideas"},"routeName":"IdeaBoardPage"},{"linkType":"INTERNAL","id":"market-place-core-ideas","params":{"boardId":"MarketPlaceCoreIdeas","categoryId":"Ideas"},"routeName":"IdeaBoardPage"},{"linkType":"INTERNAL","id":"platform-core","params":{"boardId":"PlatformCore","categoryId":"Ideas"},"routeName":"IdeaBoardPage"}],"linkType":"INTERNAL","id":"ideas","params":{"categoryId":"Ideas"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"platformupgrades","params":{"groupHubId":"platformupgrades"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"taxprovision","params":{"groupHubId":"taxprovision"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"p-a-b","params":{"groupHubId":"PAB"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"customer-advisory-board","params":{"groupHubId":"CustomerAdvisoryBoard"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"sensibleml","params":{"groupHubId":"sensibleml"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"e-s-g-focus-group","params":{"groupHubId":"ESGFocusGroup"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"partner-a-i-services","params":{"groupHubId":"PartnerAIServices"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"projectlongship","params":{"groupHubId":"projectlongship"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"boatlaunchdevelopers","params":{"groupHubId":"boatlaunchdevelopers"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"cpmexpress","params":{"groupHubId":"cpmexpress"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"privatepreview-journalentrymanager-link","params":{"groupHubId":"privatepreview-journalentrymanager"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"n-a-c-a-b-link","params":{"groupHubId":"NACAB"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"e-m-e-a-c-a-b-link","params":{"groupHubId":"EMEACAB"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"Common-south-africa-user-group-link","params":{"groupHubId":"south-africa-user-group"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"Common-esg-private-preview-link","params":{"groupHubId":"esg-private-preview"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"Common-north-america-user-group-leaders-link","params":{"groupHubId":"north-america-user-group-leaders"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"Common-atlanta-user-group-link","params":{"groupHubId":"atlanta-user-group"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"Common-dfw-user-group-link","params":{"groupHubId":"dfw-user-group"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"Common-florida-user-group-link","params":{"groupHubId":"florida-user-group"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"Common-michigan-user-group-link","params":{"groupHubId":"michigan-user-group"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"Common-minnesota-user-group-link","params":{"groupHubId":"minnesota-user-group"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"Common-philadelphia-user-group-link","params":{"groupHubId":"philadelphia-user-group"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"Common-socal-user-group-link","params":{"groupHubId":"socal-user-group"},"routeName":"GroupHubPage"}],"linkType":"INTERNAL","id":"advanced","params":{"categoryId":"Advanced"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"partner-1","params":{"boardId":"Partner","categoryId":"Partner"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"summit-webinar-materials","params":{"boardId":"SummitWebinarMaterials","categoryId":"Partner"},"routeName":"TkbBoardPage"},{"linkType":"INTERNAL","id":"onestreamtaxprovisionpartners","params":{"boardId":"onestreamtaxprovisionpartners","categoryId":"Partner"},"routeName":"TkbBoardPage"}],"linkType":"INTERNAL","id":"partner","params":{"categoryId":"Partner"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"wave","params":{"boardId":"Wave","categoryId":"internal"},"routeName":"TkbBoardPage"},{"linkType":"INTERNAL","id":"internalforum","params":{"boardId":"internalforum","categoryId":"internal"},"routeName":"ForumBoardPage"}],"linkType":"INTERNAL","id":"internal","params":{"categoryId":"Internal"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"abuse-reports","params":{"boardId":"abuse-reports","categoryId":"community-management"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"filter-notifications","params":{"boardId":"filter-notifications","categoryId":"community-management"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"moderation-archive","params":{"boardId":"moderation-archive","categoryId":"community-management"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"moderation-k-b","params":{"boardId":"ModerationKB","categoryId":"community-management"},"routeName":"TkbBoardPage"},{"linkType":"INTERNAL","id":"Common-ideastream-archive-link","params":{"boardId":"ideastream-archive","categoryId":"community-management"},"routeName":"IdeaBoardPage"},{"linkType":"INTERNAL","id":"introduce","params":{"boardId":"Introduce","categoryId":"community-management"},"routeName":"ForumBoardPage"}],"linkType":"INTERNAL","id":"community-management","params":{"categoryId":"community-management"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"Common-wave-link","params":{"boardId":"Wave","categoryId":"internal"},"routeName":"TkbBoardPage"},{"linkType":"INTERNAL","id":"Common-internalforum-link","params":{"boardId":"internalforum","categoryId":"internal"},"routeName":"ForumBoardPage"}],"linkType":"INTERNAL","id":"internal-link","params":{"categoryId":"internal"},"routeName":"CategoryPage"}]},"className":"QuiltComponent_lia-component-edit-mode__0nCcm","style":{"boxShadow":"var(--lia-bs-box-shadow-sm)","linkFontWeight":"400","controllerHighlightColor":"hsla(30, 100%, 50%)","dropdownDividerMarginBottom":"10px","hamburgerBorderHover":"none","linkFontSize":"15px","linkBoxShadowHover":"none","backgroundOpacity":0.8,"controllerBorderRadius":"var(--lia-border-radius-50)","hamburgerBgColor":"transparent","linkTextBorderBottom":"none","hamburgerColor":"var(--lia-nav-controller-icon-color)","brandLogoHeight":"80px","linkLetterSpacing":"normal","linkBgHoverColor":"transparent","collapseMenuDividerOpacity":0.16,"paddingBottom":"10px","dropdownPaddingBottom":"15px","dropdownMenuOffset":"2px","hamburgerBgHoverColor":"transparent","borderBottom":"1px solid var(--lia-bs-border-color)","hamburgerBorder":"none","dropdownPaddingX":"10px","brandMarginRightSm":"10px","linkBoxShadow":"none","linkJustifyContent":"center","linkColor":"var(--lia-bs-body-color)","collapseMenuDividerBg":"var(--lia-nav-link-color)","dropdownPaddingTop":"10px","controllerHighlightTextColor":"var(--lia-yiq-dark)","controllerTextColor":"var(--lia-nav-controller-icon-color)","background":{"imageAssetName":"","color":"var(--lia-bs-white)","size":"COVER","repeat":"NO_REPEAT","position":"CENTER_CENTER","imageLastModified":""},"linkBorderRadius":"var(--lia-bs-border-radius-sm)","linkHoverColor":"var(--lia-bs-body-color)","position":"FIXED","linkBorder":"none","linkTextBorderBottomHover":"2px solid var(--lia-bs-gray-800)","brandMarginRight":"30px","hamburgerHoverColor":"var(--lia-nav-controller-icon-color)","linkBorderHover":"none","collapseMenuMarginLeft":"20px","linkFontStyle":"NORMAL","linkPaddingX":"10px","controllerTextHoverColor":"var(--lia-nav-controller-icon-hover-color)","paddingTop":"0px","linkPaddingY":"5px","linkTextTransform":"NONE","dropdownBorderColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","controllerBgHoverColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.1)","linkDropdownPaddingX":"var(--lia-nav-link-px)","linkBgColor":"transparent","linkDropdownPaddingY":"9px","controllerIconColor":"var(--lia-bs-body-color)","dropdownDividerMarginTop":"10px","linkGap":"10px","controllerIconHoverColor":"var(--lia-bs-body-color)"},"showSearchIcon":true,"languagePickerStyle":"iconAndLabel"},"__typename":"QuiltComponent"},{"id":"community.widget.breadcrumbWidget","props":null,"__typename":"QuiltComponent"},{"id":"community.widget.bannerWidget","props":{"backgroundColor":"transparent","visualEffects":{"showBottomBorder":true},"backgroundOpacity":100,"backgroundImageProps":{"assetName":"community-widget-bannerWidget-1730266943818.jpg","backgroundSize":"COVER","lastModified":"1730266947000","backgroundPosition":"CENTER_CENTER","backgroundRepeat":"NO_REPEAT"},"fontColor":"var(--lia-bs-body-color)"},"__typename":"QuiltComponent"}],"__typename":"QuiltWrapperSection"},"footer":{"backgroundImageProps":{"assetName":null,"backgroundSize":"COVER","backgroundRepeat":"NO_REPEAT","backgroundPosition":"CENTER_CENTER","lastModified":null,"__typename":"BackgroundImageProps"},"backgroundColor":"var(--lia-bs-body-color)","items":[{"id":"custom.widget.Footer","props":{"widgetVisibility":"signedInOrAnonymous","useTitle":true,"useBackground":false,"title":"","lazyLoad":false},"__typename":"QuiltComponent"}],"__typename":"QuiltWrapperSection"},"__typename":"QuiltWrapper","localOverride":false},"localOverride":false},"CachedAsset:component:custom.widget.Footer-en-us-1746700267415":{"__typename":"CachedAsset","id":"component:custom.widget.Footer-en-us-1746700267415","value":{"component":{"id":"custom.widget.Footer","template":{"id":"Footer","markupLanguage":"HTML","style":null,"texts":{},"defaults":{"config":{"applicablePages":[],"description":"","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"components":[{"id":"custom.widget.Footer","form":null,"config":null,"props":[],"__typename":"Component"}],"grouping":"TEXTHTML","__typename":"ComponentTemplate"},"properties":{"config":{"applicablePages":[],"description":"","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"form":null,"__typename":"Component","localOverride":false},"globalCss":null,"form":null},"localOverride":false},"CachedAsset:text:en_US-components/community/Breadcrumb-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/community/Breadcrumb-1746664278000","value":{"navLabel":"Breadcrumbs","dropdown":"Additional parent page navigation"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBanner-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBanner-1746664278000","value":{"messageMarkedAsSpam":"This post has been marked as spam","messageMarkedAsSpam@board:TKB":"This article has been marked as spam","messageMarkedAsSpam@board:BLOG":"This post has been marked as spam","messageMarkedAsSpam@board:FORUM":"This discussion has been marked as spam","messageMarkedAsSpam@board:OCCASION":"This event has been marked as spam","messageMarkedAsSpam@board:IDEA":"This idea has been marked as spam","manageSpam":"Manage Spam","messageMarkedAsAbuse":"This post has been marked as abuse","messageMarkedAsAbuse@board:TKB":"This article has been marked as abuse","messageMarkedAsAbuse@board:BLOG":"This post has been marked as abuse","messageMarkedAsAbuse@board:FORUM":"This discussion has been marked as abuse","messageMarkedAsAbuse@board:OCCASION":"This event has been marked as abuse","messageMarkedAsAbuse@board:IDEA":"This idea has been marked as abuse","preModCommentAuthorText":"This comment will be published as soon as it is approved","preModCommentModeratorText":"This comment is awaiting moderation","messageMarkedAsOther":"This post has been rejected due to other reasons","messageMarkedAsOther@board:TKB":"This article has been rejected due to other reasons","messageMarkedAsOther@board:BLOG":"This post has been rejected due to other reasons","messageMarkedAsOther@board:FORUM":"This discussion has been rejected due to other reasons","messageMarkedAsOther@board:OCCASION":"This event has been rejected due to other reasons","messageMarkedAsOther@board:IDEA":"This idea has been rejected due to other reasons","messageArchived":"This post was archived on {date}","relatedUrl":"View Related Content","relatedContentText":"Showing related content","archivedContentLink":"View Archived Content"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageView/MessageViewStandard-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewStandard-1746664278000","value":{"anonymous":"Anonymous","author":"{messageAuthorLogin}","authorBy":"{messageAuthorLogin}","board":"{messageBoardTitle}","replyToUser":" to {parentAuthor}","showMoreReplies":"Show More","replyText":"Reply","repliesText":"Replies","markedAsSolved":"Marked as Solution","movedMessagePlaceholder.BLOG":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholder.TKB":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholder.FORUM":"{count, plural, =0 {This reply has been} other {These replies have been} }","movedMessagePlaceholder.IDEA":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholder.OCCASION":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholderUrlText":"moved.","messageStatus":"Status: ","statusChanged":"Status changed: {previousStatus} to {currentStatus}","statusAdded":"Status added: {status}","statusRemoved":"Status removed: {status}","labelExpand":"expand replies","labelCollapse":"collapse replies","unhelpfulReason.reason1":"Content is outdated","unhelpfulReason.reason2":"Article is missing information","unhelpfulReason.reason3":"Content is for a different Product","unhelpfulReason.reason4":"Doesn't match what I was searching for"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageDeepLink-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageDeepLink-1746664278000","value":{"viewFullDiscussion@board:FORUM":"View Full Discussion ({repliesCount} Replies)","viewFullDiscussion@board:BLOG":"View Full Discussion ({repliesCount} Comments)","viewFullDiscussion@board:TKB":"View Full Discussion ({repliesCount} Comments)","viewFullDiscussion@board:IDEA":"View Full Discussion ({repliesCount} Comments)","viewFullDiscussion@board:OCCASION":"View Full Discussion ({repliesCount} Comments)","showParents@board:FORUM":"Show Parent Replies","showParents@board:BLOG":"Show Parent Comments","showParents@board:TKB":"Show Parent Comments","showParents@board:IDEA":"Show Parent Comments","showParents@board:OCCASION":"Show Parent Comments"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageReplyCallToAction-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyCallToAction-1746664278000","value":{"leaveReply":"Leave a reply...","leaveReply@board:BLOG@message:root":"Leave a comment...","leaveReply@board:TKB@message:root":"Leave a comment...","leaveReply@board:IDEA@message:root":"Leave a comment...","leaveReply@board:OCCASION@message:root":"Leave a comment...","repliesTurnedOff.FORUM":"Replies are turned off for this topic","repliesTurnedOff.BLOG":"Comments are turned off for this topic","repliesTurnedOff.TKB":"Comments are turned off for this topic","repliesTurnedOff.IDEA":"Comments are turned off for this topic","repliesTurnedOff.OCCASION":"Comments are turned off for this topic","infoText":"Stop poking me!"},"localOverride":false},"CachedAsset:text:en_US-components/messages/RelatedContentWidget-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/RelatedContentWidget-1746664278000","value":{"title":"Related Content","emptyDescription":"No content to show"},"localOverride":false},"Forum:board:welcome":{"__typename":"Forum","id":"board:welcome","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Blog:board:blog":{"__typename":"Blog","id":"board:blog","blogPolicies":{"__typename":"BlogPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:AppBuild":{"__typename":"Forum","id":"board:AppBuild","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:WorkflowDI":{"__typename":"Forum","id":"board:WorkflowDI","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"entityType":"FORUM","displayId":"WorkflowDI","nodeType":"board","depth":2,"conversationStyle":"FORUM","title":"Workflow and Data Integration","shortTitle":"Workflow and Data Integration","parent":{"__ref":"Category:category:your-community"},"userContext":{"__typename":"NodeUserContext","canAddAttachments":false,"canUpdateNode":false,"canPostMessages":false,"isSubscribed":false},"avatar":null,"description":"Discuss data loading and processing into the application","eventPath":"category:your-community/community:otqon28567board:WorkflowDI/"},"Forum:board:Reporting":{"__typename":"Forum","id":"board:Reporting","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:Advanced":{"__typename":"Category","id":"category:Advanced","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:Bulletins":{"__typename":"Category","id":"category:Bulletins","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"GroupHub:grouphub:taxprovision":{"__typename":"GroupHub","id":"grouphub:taxprovision","grouphubPolicies":{"__typename":"GroupHubPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:FrenchLanguageForum":{"__typename":"Forum","id":"board:FrenchLanguageForum","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:TechTalks":{"__typename":"Forum","id":"board:TechTalks","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:Podcast":{"__typename":"Forum","id":"board:Podcast","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"GroupHub:grouphub:platformupgrades":{"__typename":"GroupHub","id":"grouphub:platformupgrades","grouphubPolicies":{"__typename":"GroupHubPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:technicaldocuments":{"__typename":"Category","id":"category:technicaldocuments","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Rank:rank:19":{"__typename":"Rank","id":"rank:19","position":18,"name":"New Contributor II","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:534":{"__typename":"User","id":"user:534","uid":534,"login":"ScottCharles","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2021-11-22T16:37:07.961-08:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.onestreamsoftware.com/t5/s/otqon28567/m_assets/avatars/default/avatar-7.svg?time=0"},"rank":{"__ref":"Rank:rank:19"},"messagesCount":10,"kudosGivenCount":3,"kudosReceivedCount":0,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":1,"entityType":"USER","eventPath":"community:otqon28567/user:534"},"ForumTopicMessage:message:40534":{"__typename":"ForumTopicMessage","uid":40534,"subject":"Data sources zero suppression with complex expression","id":"message:40534","revisionNum":1,"repliesCount":2,"author":{"__ref":"User:user:534"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:WorkflowDI"},"conversation":{"__ref":"Conversation:conversation:40534"},"moderationData":{"__ref":"ModerationData:moderation_data:40534"},"postTime":"2024-11-01T14:20:04.360-07:00","lastPublishTime":"2024-11-01T14:20:04.360-07:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":237},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:your-community/community:otqon28567board:WorkflowDI/message:40534"},"Conversation:conversation:40534":{"__typename":"Conversation","id":"conversation:40534","solved":true,"topic":{"__ref":"ForumTopicMessage:message:40534"},"lastPostingActivityTime":"2024-11-04T12:04:03.463-08:00","lastPostTime":"2024-11-04T12:04:03.463-08:00"},"ModerationData:moderation_data:40534":{"__typename":"ModerationData","id":"moderation_data:40534","status":"UNMODERATED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:40534":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:40534","relatedMessage":{"__ref":"ForumTopicMessage:message:40534"}},"User:user:1003":{"__typename":"User","id":"user:1003","uid":1003,"login":"AlvaroSR","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2021-12-30T03:21:22.870-08:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.onestreamsoftware.com/t5/s/otqon28567/m_assets/avatars/default/avatar-11.svg?time=0"},"rank":{"__ref":"Rank:rank:19"},"messagesCount":10,"kudosGivenCount":2,"kudosReceivedCount":3,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":1,"entityType":"USER","eventPath":"community:otqon28567/user:1003"},"ForumTopicMessage:message:34800":{"__typename":"ForumTopicMessage","uid":34800,"subject":"Get WFScenario in Complex Expression Time Data Source","id":"message:34800","revisionNum":1,"repliesCount":1,"author":{"__ref":"User:user:1003"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:Rules"},"conversation":{"__ref":"Conversation:conversation:34800"},"moderationData":{"__ref":"ModerationData:moderation_data:34800"},"postTime":"2024-05-31T03:38:05.745-07:00","lastPublishTime":"2024-05-31T03:38:05.745-07:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":778},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:your-community/community:otqon28567board:Rules/message:34800"},"Conversation:conversation:34800":{"__typename":"Conversation","id":"conversation:34800","solved":true,"topic":{"__ref":"ForumTopicMessage:message:34800"},"lastPostingActivityTime":"2024-05-31T04:09:10.576-07:00","lastPostTime":"2024-05-31T04:09:10.576-07:00"},"ModerationData:moderation_data:34800":{"__typename":"ModerationData","id":"moderation_data:34800","status":"UNMODERATED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:34800":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:34800","relatedMessage":{"__ref":"ForumTopicMessage:message:34800"}},"Rank:rank:20":{"__typename":"Rank","id":"rank:20","position":19,"name":"New Contributor","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:3324":{"__typename":"User","id":"user:3324","uid":3324,"login":"ZAH","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2022-09-01T05:31:45.162-07:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.onestreamsoftware.com/t5/s/otqon28567/m_assets/avatars/default/avatar-6.svg?time=0"},"rank":{"__ref":"Rank:rank:20"},"messagesCount":12,"kudosGivenCount":0,"kudosReceivedCount":0,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:otqon28567/user:3324"},"ForumTopicMessage:message:18377":{"__typename":"ForumTopicMessage","uid":18377,"subject":"Complex Complex Expresion in Transformation Rules","id":"message:18377","revisionNum":2,"repliesCount":4,"author":{"__ref":"User:user:3324"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:WorkflowDI"},"conversation":{"__ref":"Conversation:conversation:18377"},"moderationData":{"__ref":"ModerationData:moderation_data:18377"},"postTime":"2023-04-11T02:33:47.870-07:00","lastPublishTime":"2023-07-31T05:31:00.897-07:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":3079},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:your-community/community:otqon28567board:WorkflowDI/message:18377"},"Conversation:conversation:18377":{"__typename":"Conversation","id":"conversation:18377","solved":true,"topic":{"__ref":"ForumTopicMessage:message:18377"},"lastPostingActivityTime":"2023-07-31T05:31:00.897-07:00","lastPostTime":"2023-04-12T04:32:45.908-07:00"},"ModerationData:moderation_data:18377":{"__typename":"ModerationData","id":"moderation_data:18377","status":"UNMODERATED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:18377":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:18377","relatedMessage":{"__ref":"ForumTopicMessage:message:18377"}},"Rank:rank:13":{"__typename":"Rank","id":"rank:13","position":12,"name":"Valued Contributor II","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:5":{"__typename":"User","id":"user:5","uid":5,"login":"OSAdmin","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2021-07-16T07:44:17.712-07:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.onestreamsoftware.com/t5/s/otqon28567/images/dS01LTExMmk1NkQwQkNDQTk1RTAyNDBF"},"rank":{"__ref":"Rank:rank:13"},"messagesCount":1059,"kudosGivenCount":0,"kudosReceivedCount":125,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":15,"entityType":"USER","eventPath":"community:otqon28567/user:5"},"ForumTopicMessage:message:875":{"__typename":"ForumTopicMessage","uid":875,"subject":"Sign Flip for Account in Transformation Rule (Complex Expression)","id":"message:875","revisionNum":2,"repliesCount":1,"author":{"__ref":"User:user:5"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:WorkflowDI"},"conversation":{"__ref":"Conversation:conversation:875"},"moderationData":{"__ref":"ModerationData:moderation_data:875"},"postTime":"2021-06-29T05:42:09.000-07:00","lastPublishTime":"2022-10-14T01:38:36.442-07:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":3398},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:your-community/community:otqon28567board:WorkflowDI/message:875"},"Conversation:conversation:875":{"__typename":"Conversation","id":"conversation:875","solved":true,"topic":{"__ref":"ForumTopicMessage:message:875"},"lastPostingActivityTime":"2022-10-14T01:38:36.442-07:00","lastPostTime":"2021-08-13T09:43:54.728-07:00"},"ModerationData:moderation_data:875":{"__typename":"ModerationData","id":"moderation_data:875","status":"APPROVED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:875":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:875","relatedMessage":{"__ref":"ForumTopicMessage:message:875"}},"User:user:1105":{"__typename":"User","id":"user:1105","uid":1105,"login":"ecarney","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2022-01-06T12:00:15.762-08:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.onestreamsoftware.com/t5/s/otqon28567/m_assets/avatars/default/avatar-9.svg?time=0"},"rank":{"__ref":"Rank:rank:20"},"messagesCount":2,"kudosGivenCount":0,"kudosReceivedCount":0,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:otqon28567/user:1105"},"ForumTopicMessage:message:31248":{"__typename":"ForumTopicMessage","uid":31248,"subject":"Data source Complex Expression in Logical Operator","id":"message:31248","revisionNum":2,"repliesCount":4,"author":{"__ref":"User:user:1105"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:WorkflowDI"},"conversation":{"__ref":"Conversation:conversation:31248"},"moderationData":{"__ref":"ModerationData:moderation_data:31248"},"postTime":"2024-03-08T07:23:21.068-08:00","lastPublishTime":"2024-03-08T09:40:36.967-08:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":1524},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:your-community/community:otqon28567board:WorkflowDI/message:31248"},"Conversation:conversation:31248":{"__typename":"Conversation","id":"conversation:31248","solved":false,"topic":{"__ref":"ForumTopicMessage:message:31248"},"lastPostingActivityTime":"2024-03-09T02:34:42.207-08:00","lastPostTime":"2024-03-09T02:34:42.207-08:00"},"ModerationData:moderation_data:31248":{"__typename":"ModerationData","id":"moderation_data:31248","status":"UNMODERATED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:31248":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:31248","relatedMessage":{"__ref":"ForumTopicMessage:message:31248"}},"QueryVariables:MessageSolutions":{"__typename":"QueryVariables","id":"MessageSolutions","value":{"first":10,"constraints":{"topicId":{"eq":"message:3448"},"solution":{"eq":true}},"sorts":{"postTime":{"direction":"ASC"}},"useAvatar":true,"useAuthorLogin":true,"useAuthorRank":false,"useBody":true,"useKudosCount":false,"useTimeToRead":false,"useMedia":true,"useRepliesCount":false,"useSearchSnippet":false,"useAcceptedSolutionButton":true,"useSolvedBadge":false,"useAttachments":true,"useTags":false,"useUserHoverCard":false,"useNodeHoverCard":false,"usePreviewSubjectModal":false,"useMessageStatus":false}},"ROOT_MUTATION":{"__typename":"Mutation"},"CachedAsset:text:en_US-components/community/Navbar-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/community/Navbar-1746664278000","value":{"community":"Community Home","inbox":"Inbox","manageContent":"Manage Content","tos":"Terms of Service","forgotPassword":"Forgot Password","themeEditor":"Theme Editor","edit":"Edit Navigation Bar","skipContent":"Skip to content","migrated-link-9":"Support ","reports":"Application Build","migrated-link-7":"News","accepted-code-sample":"Accepted Code Samples","migrated-link-8":"Groups","advanced":"Groups","Common-internalforum-link":"Internal Consultants (PIE)","migrated-link-1":"Internal","Common-wave-link":"WAVE Content","migrated-link-2":"Partners","rules":"Rules","migrated-link-0":"Hubs","o-h":"Implementation Q&A Archive","migrated-link-5":"Resources","blog":"Community Blog","migrated-link-6":"IdeaStream","pie":"PIE","migrated-link-3":"Developer Network","wave-presentations":"WAVE Presentations","migrated-link-4":"Forums","partner-1":"Partner Forum","your-community":"Forums","internal-link":"Internal","Common-philadelphia-user-group-link":"Philadelphia User Group","privatepreview-journalentrymanager-link":"Private Preview: Journey Entry Manager","planning-analysis-ideas":"Planning & Analysis","welcome":"Community Announcements","Common-ideastream-archive-link":"IdeaStream Archive","filter-notifications":"Filter Notifications","Common-north-america-user-group-leaders-link":"North America User Group Leaders","partner-a-i-services":"Partner AI Services","foundational-design-guides":"Foundational Design Guides","platformupgrades":"Platform v8+ Upgrades","sensibleml":"Sensible ML","ideas":"IdeaStream","academicalliances":"Academic Alliances","market-place-core-ideas":"OneStream Solutions","news-and-views":"Internal","e-s-g-focus-group":"ESG Focus Group","Common-michigan-user-group-link-1":"Michigan User Group","foundationaldesign":"Foundational Design Guides","community-management":"Moderate","Common-south-africa-user-group-link":"South Africa User Group","Common-florida-user-group-link":"Florida User Group","community-announcements":"Community Announcements","internal":"Internal","workflow-d-i":"Workflow and Data Integration","abuse-reports":"Abuse Reports","internalforum":"Internal Consultants (PIE)","productivity-":"Productivity","Common-esg-private-preview-link":"ESG Private Preview","Common-socal-user-group-link":"SoCal User Group","customer-advisory-board":"Customer Advisory Board- CAB","platform":"Platform","wave":"WAVE Content","planning-":"Planning & Analysis","Common-minnesota-user-group-link":"Minnesota User Group","Common-dfw-user-group-link":"DFW User Group","reports-1":"Application Build","app-build":"Application Build","financial-close-compliance-ideas":"Financial Close & Consolidations","Common-michigan-user-group-link":"Michigan User Group","podcast":"The OneStream Podcast: Continue the Conversation","moderation-archive":"Moderation Forum Archive","technical-documents":"Technical Documents","p-a-b":"Partner Advisory Board","data-workflow--integration-":"Data Workflow & Integration","moderation-k-b":"Moderation KB Archive","reporting":"Reporting","bulletins":"Resources","cpmexpress":"CPM Express","summit-":"Summit + Webinar Materials","introduce":"Introduce Yourself","community-blog":"Community Blog","solution-exchange":"Solutions","productivity-ideas":"Productivity","partner-discussions":"Partner Forum","tech-talks":"OneStream Tech Talks: Continue the Conversation","bulletins-1":"Technical Documents","advanced-analytics-ideas":"Advanced Analytics & AI","boatlaunchdevelopers":"Boat Launch","Common-atlanta-user-group-link":"Atlanta User Group","platform-core":"Platform","summit-webinar-materials":"Summit and Webinar Materials","onestream-community-resources":"OneStream Community Resources","partner":"Partners","e-m-e-a-c-a-b-link":"EMEA Customer Advisory Board","french-language-forum":"French Language Forum","projectlongship":"Project Longship","taxprovision":"Tax Provision","n-a-c-a-b-link":"NA Customer Advisory Board","onestreamtaxprovisionpartners":"OneStream Tax Provision"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarHamburgerDropdown-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarHamburgerDropdown-1746664278000","value":{"hamburgerLabel":"Side Menu"},"localOverride":false},"CachedAsset:text:en_US-components/community/BrandLogo-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/community/BrandLogo-1746664278000","value":{"logoAlt":"Khoros","themeLogoAlt":"Brand Logo"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarTextLinks-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarTextLinks-1746664278000","value":{"more":"More"},"localOverride":false},"CachedAsset:text:en_US-components/search/SpotlightSearchIcon-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/search/SpotlightSearchIcon-1746664278000","value":{"search":"Search"},"localOverride":false},"CachedAsset:text:en_US-components/authentication/AuthenticationLink-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/authentication/AuthenticationLink-1746664278000","value":{"title.login":"Sign In","title.registration":"Register","title.forgotPassword":"Forgot Password","title.multiAuthLogin":"Sign In"},"localOverride":false},"CachedAsset:text:en_US-components/nodes/NodeLink-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/nodes/NodeLink-1746664278000","value":{"place":"Place {name}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/EscalatedMessageBanner-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/EscalatedMessageBanner-1746664278000","value":{"escalationMessage":"Escalated to Salesforce by {username} on {date}","viewDetails":"View Details","modalTitle":"Case Details","escalatedBy":"Escalated by: ","escalatedOn":"Escalated on: ","caseNumber":"Case Number: ","status":"Status: ","lastUpdateDate":"Last Update: ","automaticEscalation":"automatic escalation","anonymous":"Anonymous"},"localOverride":false},"CachedAsset:text:en_US-components/users/UserLink-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/users/UserLink-1746664278000","value":{"authorName":"View Profile: {author}","anonymous":"Anonymous"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/users/UserRank-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserRank-1746664278000","value":{"rankName":"{rankName}","userRank":"Author rank {rankName}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageTime-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageTime-1746664278000","value":{"postTime":"Published: {time}","lastPublishTime":"Last Update: {time}","conversation.lastPostingActivityTime":"Last posting activity time: {time}","conversation.lastPostTime":"Last post time: {time}","moderationData.rejectTime":"Rejected time: {time}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSolvedBadge-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSolvedBadge-1746664278000","value":{"solved":"Solved"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSubject-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSubject-1746664278000","value":{"noSubject":"(no subject)"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBody-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBody-1746664278000","value":{"showMessageBody":"Show More","mentionsErrorTitle":"{mentionsType, select, board {Board} user {User} message {Message} other {}} No Longer Available","mentionsErrorMessage":"The {mentionsType} you are trying to view has been removed from the community.","videoProcessing":"Video is being processed. Please try again in a few minutes.","bannerTitle":"Video provider requires cookies to play the video. Accept to continue or {url} it directly on the provider's site.","buttonTitle":"Accept","urlText":"watch"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageCustomFields-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageCustomFields-1746664278000","value":{"CustomField.default.label":"Value of {name}"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/QueryHandler-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/QueryHandler-1746664278000","value":{"title":"Query Handler"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageReplyButton-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyButton-1746664278000","value":{"repliesCount":"{count}","title":"Reply","title@board:BLOG@message:root":"Comment","title@board:TKB@message:root":"Comment","title@board:IDEA@message:root":"Comment","title@board:OCCASION@message:root":"Comment"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSolutionList-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSolutionList-1746664278000","value":{"emptyDescription":"No has been message solutions yet"},"localOverride":false},"User:user:171":{"__typename":"User","id":"user:171","uid":171,"login":"ckattookaran","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2021-10-29T15:34:08.485-07:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.onestreamsoftware.com/t5/s/otqon28567/m_assets/avatars/default/avatar-11.svg?time=0"},"entityType":"USER","eventPath":"community:otqon28567/user:171"},"ForumReplyMessage:message:3591":{"__typename":"ForumReplyMessage","uid":3591,"id":"message:3591","revisionNum":1,"author":{"__ref":"User:user:615"},"readOnly":false,"depth":2,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:Rules"},"conversation":{"__ref":"Conversation:conversation:3448"},"subject":"Re: Excel Load Data source (fixed files data source) does complex expressions works ?","editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_data:3591"},"body":"Could you please let me know how can i use a business rule for an excel load, where do you put the BR, in the excel template? because in the data source it doesn\"t work 😕 what's the syntax please ?
Other question, what type of BR do you create ? a Parser one or an XFBR String ?
Thanks a lot for your help 🙂
Could you please let me know how can i use a business rule for an excel load, where do you put the BR, in the excel template? because in the data source it doesn\"t work 😕 what's the syntax please ?
Other question, what type of BR do you create ? a Parser one or an XFBR String ?
Thanks a lot for your help 🙂
You can do the following, create a parser rule and then use it like the following.
\nSI#::[GetUserName]
","body@stripHtml({\"removeProcessingText\":true,\"removeSpoilerMarkup\":true,\"removeTocMarkup\":true,\"truncateLength\":200})@stringLength":"105","postTime":"2021-12-14T08:58:05.583-08:00","lastPublishTime":"2021-12-14T08:58:05.583-08:00","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"attachments":{"__typename":"AttachmentConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"solution":true,"metrics":{"__typename":"MessageMetrics","views":5715},"placeholder":false,"originalMessageForPlaceholder":null,"videos":{"__typename":"VideoConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"isEscalated":null,"entityType":"FORUM_REPLY","eventPath":"category:your-community/community:otqon28567board:Rules/message:3448/message:3594","customFields":[]},"Rank:rank:17":{"__typename":"Rank","id":"rank:17","position":16,"name":"Contributor","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:600":{"__typename":"User","id":"user:600","uid":600,"login":"Koemets","deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://community.onestreamsoftware.com/t5/s/otqon28567/m_assets/avatars/default/avatar-12.svg?time=0"},"rank":{"__ref":"Rank:rank:17"},"email":"","messagesCount":56,"biography":null,"topicsCount":2,"kudosReceivedCount":27,"kudosGivenCount":4,"kudosWeight":1,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2021-12-06T13:26:24.687-08:00","confirmEmailStatus":null},"followersCount":null,"solutionsCount":5},"ModerationData:moderation_data:3592":{"__typename":"ModerationData","id":"moderation_data:3592","status":"UNMODERATED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ModerationData:moderation_data:3591":{"__typename":"ModerationData","id":"moderation_data:3591","status":"UNMODERATED","rejectReason":null},"Revision:revision:3592_1":{"__typename":"Revision","id":"revision:3592_1","lastEditTime":"2021-12-14T08:50:39.563-08:00"},"QueryVariables:ReplyList:message:3592:1":{"__typename":"QueryVariables","id":"ReplyList:message:3592:1","value":{"id":"message:3592","first":10,"sorts":{"kudosSumWeight":{"direction":"DESC","order":0},"postTime":{"direction":"ASC","order":1}},"repliesFirst":3,"repliesFirstDepthThree":1,"repliesSorts":{"kudosSumWeight":{"direction":"DESC","order":0},"postTime":{"direction":"ASC","order":1}},"useAvatar":true,"useAuthorLogin":true,"useAuthorRank":true,"useBody":true,"useKudosCount":true,"useTimeToRead":false,"useMedia":false,"useReadOnlyIcon":false,"useRepliesCount":true,"useSearchSnippet":false,"useAcceptedSolutionButton":true,"useSolvedBadge":false,"useAttachments":false,"attachmentsFirst":5,"useTags":false,"useNodeAncestors":false,"useUserHoverCard":false,"useNodeHoverCard":false,"useModerationStatus":true,"usePreviewSubjectModal":false,"useMessageStatus":true}},"CachedAsset:text:en_US-components/community/NavbarDropdownToggle-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarDropdownToggle-1746664278000","value":{"ariaLabelClosed":"Press the down arrow to open the menu"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/users/UserAvatar-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserAvatar-1746664278000","value":{"altText":"{login}'s avatar","altTextGeneric":"User's avatar"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/ranks/UserRankLabel-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/ranks/UserRankLabel-1746664278000","value":{"altTitle":"Icon for {rankName} rank"},"localOverride":false},"CachedAsset:text:en_US-components/tags/TagView/TagViewChip-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/tags/TagView/TagViewChip-1746664278000","value":{"tagLabelName":"Tag name {tagName}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/AcceptedSolutionButton-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/AcceptedSolutionButton-1746664278000","value":{"accept":"Mark as Solution","accepted":"Marked as Solution","errorHeader":"Error!","errorAdd":"There was an error marking as solution.","errorRemove":"There was an error unmarking as solution.","solved":"Solved","topicAlreadySolvedErrorTitle":"Solution Already Exists","topicAlreadySolvedErrorDesc":"Refresh the browser to view the existing solution"},"localOverride":false},"CachedAsset:text:en_US-components/messages/ThreadedReplyList-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/ThreadedReplyList-1746664278000","value":{"title":"{count, plural, one{# Reply} other{# Replies}}","title@board:BLOG":"{count, plural, one{# Comment} other{# Comments}}","title@board:TKB":"{count, plural, one{# Comment} other{# Comments}}","title@board:IDEA":"{count, plural, one{# Comment} other{# Comments}}","title@board:OCCASION":"{count, plural, one{# Comment} other{# Comments}}","noRepliesTitle":"No Replies","noRepliesTitle@board:BLOG":"No Comments","noRepliesTitle@board:TKB":"No Comments","noRepliesTitle@board:IDEA":"No Comments","noRepliesTitle@board:OCCASION":"No Comments","noRepliesDescription":"Be the first to reply","noRepliesDescription@board:BLOG":"Be the first to comment","noRepliesDescription@board:TKB":"Be the first to comment","noRepliesDescription@board:IDEA":"Be the first to comment","noRepliesDescription@board:OCCASION":"Be the first to comment","messageReadOnlyAlert:BLOG":"Comments have been turned off for this post","messageReadOnlyAlert:TKB":"Comments have been turned off for this article","messageReadOnlyAlert:IDEA":"Comments have been turned off for this idea","messageReadOnlyAlert:FORUM":"Replies have been turned off for this discussion","messageReadOnlyAlert:OCCASION":"Comments have been turned off for this event"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageView/MessageViewInline-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewInline-1746664278000","value":{"bylineAuthor":"{bylineAuthor}","bylineBoard":"{bylineBoard}","anonymous":"Anonymous","place":"Place {bylineBoard}","gotoParent":"Go to parent {name}"},"localOverride":false},"CachedAsset:text:en_US-components/customComponent/CustomComponent-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-components/customComponent/CustomComponent-1746664278000","value":{"errorMessage":"Error rendering component id: {customComponentId}","bannerTitle":"Video provider requires cookies to play the video. Accept to continue or {url} it directly on the provider's site.","buttonTitle":"Accept","urlText":"watch"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/nodes/NodeIcon-1746664278000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/nodes/NodeIcon-1746664278000","value":{"contentType":"Content Type {style, select, FORUM {Forum} BLOG {Blog} TKB {Knowledge Base} IDEA {Ideas} OCCASION {Events} other {}} icon"},"localOverride":false}}}},"page":"/forums/ForumMessagePage/ForumMessagePage","query":{"boardId":"Rules","messageSubject":"excel-load-data-source-fixed-files-data-source-does-complex-expressions-works-","messageId":"3448","replyId":"3592"},"buildId":"-gVUpXaWnPcjlrLJZ92B7","runtimeConfig":{"buildInformationVisible":false,"logLevelApp":"info","logLevelMetrics":"info","openTelemetryClientEnabled":false,"openTelemetryConfigName":"onestream","openTelemetryServiceVersion":"25.3.0","openTelemetryUniverse":"prod","openTelemetryCollector":"http://localhost:4318","openTelemetryRouteChangeAllowedTime":"5000","apolloDevToolsEnabled":false,"inboxMuteWipFeatureEnabled":false},"isFallback":false,"isExperimentalCompile":false,"dynamicIds":["./components/seo/QAPageSchema/QAPageSchema.tsx","./components/community/Navbar/NavbarWidget.tsx","./components/community/Breadcrumb/BreadcrumbWidget.tsx","./components/messages/TopicWithThreadedReplyListWidget/TopicWithThreadedReplyListWidget.tsx","./components/messages/MessageView/MessageViewStandard/MessageViewStandard.tsx","./components/messages/RelatedContentWidget/RelatedContentWidget.tsx","./components/customComponent/CustomComponent/CustomComponent.tsx","../shared/client/components/common/List/UnwrappedList/UnwrappedList.tsx","./components/tags/TagView/TagView.tsx","./components/tags/TagView/TagViewChip/TagViewChip.tsx","../shared/client/components/common/List/UnstyledList/UnstyledList.tsx","./components/messages/MessageView/MessageView.tsx","./components/messages/MessageView/MessageViewInline/MessageViewInline.tsx","./components/customComponent/CustomComponentContent/HtmlContent.tsx","./components/customComponent/CustomComponentContent/CustomComponentScripts.tsx"],"appGip":true,"scriptLoader":[]}