SOURCE: ONESTREAM CHAMPIONS
Hi everyone,
Has anyone used the Dashboards for advanced line charts to show a few years of actuals and the current year of budget? I am trying to show actuals for 2019, 2020, and 2021 and 2021 budget by month and cannot figure out how to get this to come through. I set up a cube view with my account in the POV and the Time in the column and a combination of scenario and time in the rows since i don’t want to see budgets for every one of these years.
Thanks,
Cindy
Thanks Terry - what a brilliant way to solve this issue.
","body@stringLength":"76","rawBody":"Thanks Terry - what a brilliant way to solve this issue.
","kudosSumWeight":0,"repliesCount":1,"postTime":"2022-01-12T13:13:08.543-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:4145_1"},"latestVersion":null,"metrics":{"__typename":"MessageMetrics","views":4452},"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":[{"__typename":"MessageEdge","cursor":"MjUuM3wyLjF8b3wxMHwxNDowLDM5OjF8MQ","node":{"__ref":"ForumReplyMessage:message:4157"}}],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"CachedAsset:theme:customTheme1-1746000480921":{"__typename":"CachedAsset","id":"theme:customTheme1-1746000480921","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-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Loading/LoadingDot-1746664280661","value":{"title":"Loading..."},"localOverride":false},"CachedAsset:quilt:onestream.prod:pages/forums/ForumMessagePage:board:Reporting-1746000477832":{"__typename":"CachedAsset","id":"quilt:onestream.prod:pages/forums/ForumMessagePage:board:Reporting-1746000477832","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-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-components/common/EmailVerification-1746664280661","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-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-pages/forums/ForumMessagePage-1746664280661","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:quiltWrapper:onestream.prod:Common:1746664280679":{"__typename":"CachedAsset","id":"quiltWrapper:onestream.prod:Common:1746664280679","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:text:en_US-components/common/ActionFeedback-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-components/common/ActionFeedback-1746664280661","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:component:custom.widget.Footer-en-us-1746000490254":{"__typename":"CachedAsset","id":"component:custom.widget.Footer-en-us-1746000490254","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-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-components/community/Breadcrumb-1746664280661","value":{"navLabel":"Breadcrumbs","dropdown":"Additional parent page navigation"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBanner-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBanner-1746664280661","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-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewStandard-1746664280661","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-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageDeepLink-1746664280661","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-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyCallToAction-1746664280661","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-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-components/messages/RelatedContentWidget-1746664280661","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}}},"Forum:board:Rules":{"__typename":"Forum","id":"board:Rules","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"entityType":"FORUM","displayId":"Rules","nodeType":"board","depth":2,"conversationStyle":"FORUM","title":"Rules","shortTitle":"Rules","parent":{"__ref":"Category:category:your-community"},"userContext":{"__typename":"NodeUserContext","canAddAttachments":false,"canUpdateNode":false,"canPostMessages":false,"isSubscribed":false},"avatar":null,"description":"Discuss Formulas and Business rules for your application","eventPath":"category:your-community/community:otqon28567board:Rules/"},"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}},"entityType":"CATEGORY","displayId":"technicaldocuments","nodeType":"category","depth":2,"title":"Technical Documents","shortTitle":"Technical Documents"},"Rank:rank:19":{"__typename":"Rank","id":"rank:19","position":18,"name":"New Contributor II","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:9266":{"__typename":"User","id":"user:9266","uid":9266,"login":"LucaR","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2024-03-26T00:58:40.581-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-10.svg?time=0"},"rank":{"__ref":"Rank:rank:19"},"messagesCount":10,"kudosGivenCount":0,"kudosReceivedCount":0,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":1,"entityType":"USER","eventPath":"community:otqon28567/user:9266"},"ForumTopicMessage:message:36631":{"__typename":"ForumTopicMessage","uid":36631,"subject":"Show Report formatting","id":"message:36631","revisionNum":1,"repliesCount":5,"author":{"__ref":"User:user:9266"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:Reporting"},"conversation":{"__ref":"Conversation:conversation:36631"},"moderationData":{"__ref":"ModerationData:moderation_data:36631"},"postTime":"2024-07-18T08:24:14.122-07:00","lastPublishTime":"2024-07-18T08:24:14.122-07:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":1228},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:your-community/community:otqon28567board:Reporting/message:36631"},"Conversation:conversation:36631":{"__typename":"Conversation","id":"conversation:36631","solved":true,"topic":{"__ref":"ForumTopicMessage:message:36631"},"lastPostingActivityTime":"2024-07-22T00:23:27.023-07:00","lastPostTime":"2024-07-22T00:23:27.023-07:00"},"ModerationData:moderation_data:36631":{"__typename":"ModerationData","id":"moderation_data:36631","status":"UNMODERATED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:36631":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:36631","relatedMessage":{"__ref":"ForumTopicMessage:message:36631"}},"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":123,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":15,"entityType":"USER","eventPath":"community:otqon28567/user:5"},"Tkb:board:OH":{"__typename":"Tkb","id":"board:OH","entityType":"TKB","displayId":"OH","nodeType":"board","depth":3,"conversationStyle":"TKB","title":"Implementation Q&A Archive","shortTitle":"Implementation Q&A Archive","parent":{"__ref":"Category:category:technicaldocuments"},"userContext":{"__typename":"NodeUserContext","canAddAttachments":false,"canUpdateNode":false,"canPostMessages":false,"isSubscribed":false},"avatar":null,"description":"Questions and Answers from real consultants","eventPath":"category:technicaldocuments/category:Bulletins/community:otqon28567board:OH/"},"TkbTopicMessage:message:1551":{"__typename":"TkbTopicMessage","uid":1551,"subject":"Question: In Advanced Chart component of a Dashboard, can you show how to add a secondary axis?","id":"message:1551","revisionNum":5,"repliesCount":0,"author":{"__ref":"User:user:5"},"depth":0,"hasGivenKudo":false,"helpful":null,"board":{"__ref":"Tkb:board:OH"},"conversation":{"__ref":"Conversation:conversation:1551"},"contentWorkflow":{"__typename":"ContentWorkflow","state":"PUBLISH","scheduledPublishTime":null,"scheduledTimezone":null,"shortScheduledTimezone":null,"userContext":{"__typename":"MessageWorkflowContext","canSubmitForReview":null,"canEdit":false,"canRecall":null,"canSubmitForPublication":null,"canReturnToAuthor":null,"canPublish":null,"canReturnToReview":null,"canSchedule":false}},"moderationData":{"__ref":"ModerationData:moderation_data:1551"},"teaser":"","postTime":"2021-08-18T11:19:42.572-07:00","lastPublishTime":"2023-09-14T07:47:50.477-07:00","readOnly":false,"introduction":"","metrics":{"__typename":"MessageMetrics","views":839},"placeholder":false,"originalMessageForPlaceholder":null,"entityType":"TKB_ARTICLE","eventPath":"category:technicaldocuments/category:Bulletins/community:otqon28567board:OH/message:1551"},"Conversation:conversation:1551":{"__typename":"Conversation","id":"conversation:1551","solved":false,"topic":{"__ref":"TkbTopicMessage:message:1551"},"lastPostingActivityTime":"2023-09-14T07:47:50.477-07:00","lastPostTime":"2021-08-18T11:19:42.572-07:00"},"ModerationData:moderation_data:1551":{"__typename":"ModerationData","id":"moderation_data:1551","status":"APPROVED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:1551":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:1551","relatedMessage":{"__ref":"TkbTopicMessage:message:1551"}},"Rank:rank:17":{"__typename":"Rank","id":"rank:17","position":16,"name":"Contributor","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:1479":{"__typename":"User","id":"user:1479","uid":1479,"login":"FlorisvdPoel","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2022-02-01T03:29:19.867-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-2.svg?time=0"},"rank":{"__ref":"Rank:rank:17"},"messagesCount":45,"kudosGivenCount":26,"kudosReceivedCount":17,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":2,"entityType":"USER","eventPath":"community:otqon28567/user:1479"},"ForumTopicMessage:message:32946":{"__typename":"ForumTopicMessage","uid":32946,"subject":"Tree view showing full hierarchy","id":"message:32946","revisionNum":3,"repliesCount":4,"author":{"__ref":"User:user:1479"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:Rules"},"conversation":{"__ref":"Conversation:conversation:32946"},"moderationData":{"__ref":"ModerationData:moderation_data:32946"},"postTime":"2024-04-15T12:03:44.242-07:00","lastPublishTime":"2024-04-15T13:00:37.905-07:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":1963},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:your-community/community:otqon28567board:Rules/message:32946"},"Conversation:conversation:32946":{"__typename":"Conversation","id":"conversation:32946","solved":true,"topic":{"__ref":"ForumTopicMessage:message:32946"},"lastPostingActivityTime":"2024-04-16T08:21:53.037-07:00","lastPostTime":"2024-04-16T08:21:53.037-07:00"},"ModerationData:moderation_data:32946":{"__typename":"ModerationData","id":"moderation_data:32946","status":"UNMODERATED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:32946":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:32946","relatedMessage":{"__ref":"ForumTopicMessage:message:32946"}},"Rank:rank:18":{"__typename":"Rank","id":"rank:18","position":17,"name":"New Contributor III","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:9816":{"__typename":"User","id":"user:9816","uid":9816,"login":"Irina","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2024-05-08T01:44:28.951-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-9.svg?time=0"},"rank":{"__ref":"Rank:rank:18"},"messagesCount":41,"kudosGivenCount":9,"kudosReceivedCount":3,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:otqon28567/user:9816"},"ForumTopicMessage:message:41125":{"__typename":"ForumTopicMessage","uid":41125,"subject":"Combining of several Cube views into single Excel file","id":"message:41125","revisionNum":1,"repliesCount":2,"author":{"__ref":"User:user:9816"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:Reporting"},"conversation":{"__ref":"Conversation:conversation:41125"},"moderationData":{"__ref":"ModerationData:moderation_data:41125"},"postTime":"2024-11-27T10:27:57.163-08:00","lastPublishTime":"2024-11-27T10:27:57.163-08:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":100},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:your-community/community:otqon28567board:Reporting/message:41125"},"Conversation:conversation:41125":{"__typename":"Conversation","id":"conversation:41125","solved":true,"topic":{"__ref":"ForumTopicMessage:message:41125"},"lastPostingActivityTime":"2024-11-28T05:37:53.133-08:00","lastPostTime":"2024-11-28T05:37:53.133-08:00"},"ModerationData:moderation_data:41125":{"__typename":"ModerationData","id":"moderation_data:41125","status":"UNMODERATED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:41125":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:41125","relatedMessage":{"__ref":"ForumTopicMessage:message:41125"}},"User:user:3149":{"__typename":"User","id":"user:3149","uid":3149,"login":"WillVitale","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2022-08-11T08:54:53.812-07:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.onestreamsoftware.com/t5/s/otqon28567/images/dS0zMTQ5LUtwWEtqWg?image-coordinates=0%2C29%2C153%2C182"},"rank":{"__ref":"Rank:rank:17"},"messagesCount":89,"kudosGivenCount":14,"kudosReceivedCount":10,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":3,"entityType":"USER","eventPath":"community:otqon28567/user:3149"},"ForumTopicMessage:message:33350":{"__typename":"ForumTopicMessage","uid":33350,"subject":"Cell Value Showing \"OK\"","id":"message:33350","revisionNum":1,"repliesCount":11,"author":{"__ref":"User:user:3149"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:Reporting"},"conversation":{"__ref":"Conversation:conversation:33350"},"moderationData":{"__ref":"ModerationData:moderation_data:33350"},"postTime":"2024-04-23T16:50:02.020-07:00","lastPublishTime":"2024-04-23T16:50:02.020-07:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":1565},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:your-community/community:otqon28567board:Reporting/message:33350"},"Conversation:conversation:33350":{"__typename":"Conversation","id":"conversation:33350","solved":true,"topic":{"__ref":"ForumTopicMessage:message:33350"},"lastPostingActivityTime":"2025-02-09T04:21:55.647-08:00","lastPostTime":"2025-02-09T04:21:55.647-08:00"},"ModerationData:moderation_data:33350":{"__typename":"ModerationData","id":"moderation_data:33350","status":"UNMODERATED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:33350":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:33350","relatedMessage":{"__ref":"ForumTopicMessage:message:33350"}},"QueryVariables:MessageSolutions":{"__typename":"QueryVariables","id":"MessageSolutions","value":{"first":10,"constraints":{"topicId":{"eq":"message:4143"},"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-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-components/community/Navbar-1746664280661","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-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarHamburgerDropdown-1746664280661","value":{"hamburgerLabel":"Side Menu"},"localOverride":false},"CachedAsset:text:en_US-components/community/BrandLogo-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-components/community/BrandLogo-1746664280661","value":{"logoAlt":"Khoros","themeLogoAlt":"Brand Logo"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarTextLinks-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarTextLinks-1746664280661","value":{"more":"More"},"localOverride":false},"CachedAsset:text:en_US-components/search/SpotlightSearchIcon-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-components/search/SpotlightSearchIcon-1746664280661","value":{"search":"Search"},"localOverride":false},"CachedAsset:text:en_US-components/authentication/AuthenticationLink-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-components/authentication/AuthenticationLink-1746664280661","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-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-components/nodes/NodeLink-1746664280661","value":{"place":"Place {name}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/EscalatedMessageBanner-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-components/messages/EscalatedMessageBanner-1746664280661","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-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-components/users/UserLink-1746664280661","value":{"authorName":"View Profile: {author}","anonymous":"Anonymous"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/users/UserRank-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserRank-1746664280661","value":{"rankName":"{rankName}","userRank":"Author rank {rankName}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageTime-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageTime-1746664280661","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-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSolvedBadge-1746664280661","value":{"solved":"Solved"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSubject-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSubject-1746664280661","value":{"noSubject":"(no subject)"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBody-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBody-1746664280661","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-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageCustomFields-1746664280661","value":{"CustomField.default.label":"Value of {name}"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/QueryHandler-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/QueryHandler-1746664280661","value":{"title":"Query Handler"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageReplyButton-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyButton-1746664280661","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-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSolutionList-1746664280661","value":{"emptyDescription":"No has been message solutions yet"},"localOverride":false},"User:user:176":{"__typename":"User","id":"user:176","uid":176,"login":"TerryLedet","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2021-10-30T16:14:45.705-07:00","confirmEmailStatus":null},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.onestreamsoftware.com/t5/s/otqon28567/m_assets/avatars/default/avatar-6.svg?time=0"},"entityType":"USER","eventPath":"community:otqon28567/user:176","rank":{"__ref":"Rank:rank:18"},"messagesCount":22,"topicsCount":0,"kudosReceivedCount":10,"kudosGivenCount":3,"kudosWeight":1,"followersCount":null,"solutionsCount":3},"ModerationData:moderation_data:4144":{"__typename":"ModerationData","id":"moderation_data:4144","status":"UNMODERATED","rejectReason":null},"AcceptedSolutionMessage:message:4144":{"__typename":"AcceptedSolutionMessage","author":{"__ref":"User:user:176"},"id":"message:4144","revisionNum":1,"uid":4144,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:Reporting"},"parent":{"__ref":"ForumTopicMessage:message:4143"},"conversation":{"__ref":"Conversation:conversation:4143"},"subject":"Re: Advanced Charts - Line chart showing several years by month","moderationData":{"__ref":"ModerationData:moderation_data:4144"},"body":"Cindy
This may be suitable to your question. Advanced Chart Type is XY2D. Cube view has UD8 members on the row and Time by month on the column. The UD8 members are essentially: Actual Current Year, Actual Prior Year, Budget Current Year etc. The dynamic calc for each member leverages T#POV to return the appropriate fiscal year.
Terry
","body@stripHtml({\"removeProcessingText\":true,\"removeSpoilerMarkup\":true,\"removeTocMarkup\":true,\"truncateLength\":200})@stringLength":"203","postTime":"2022-01-12T13:12:28.806-08:00","lastPublishTime":"2022-01-12T13:12:28.806-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":4505},"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:Reporting/message:4143/message:4144","readOnly":false,"editFrozen":false,"body@stringLength":"354","rawBody":"Cindy
This may be suitable to your question. Advanced Chart Type is XY2D. Cube view has UD8 members on the row and Time by month on the column. The UD8 members are essentially: Actual Current Year, Actual Prior Year, Budget Current Year etc. The dynamic calc for each member leverages T#POV to return the appropriate fiscal year.
Terry
","customFields":[],"repliesCount":2},"ModerationData:moderation_data:4145":{"__typename":"ModerationData","id":"moderation_data:4145","status":"UNMODERATED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"Revision:revision:4145_1":{"__typename":"Revision","id":"revision:4145_1","lastEditTime":"2022-01-12T13:13:08.543-08:00"},"QueryVariables:ReplyList:message:4145:1":{"__typename":"QueryVariables","id":"ReplyList:message:4145:1","value":{"id":"message:4145","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-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarDropdownToggle-1746664280661","value":{"ariaLabelClosed":"Press the down arrow to open the menu"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/users/UserAvatar-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserAvatar-1746664280661","value":{"altText":"{login}'s avatar","altTextGeneric":"User's avatar"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/ranks/UserRankLabel-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/ranks/UserRankLabel-1746664280661","value":{"altTitle":"Icon for {rankName} rank"},"localOverride":false},"CachedAsset:text:en_US-components/tags/TagView/TagViewChip-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-components/tags/TagView/TagViewChip-1746664280661","value":{"tagLabelName":"Tag name {tagName}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/AcceptedSolutionButton-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-components/messages/AcceptedSolutionButton-1746664280661","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-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-components/messages/ThreadedReplyList-1746664280661","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-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewInline-1746664280661","value":{"bylineAuthor":"{bylineAuthor}","bylineBoard":"{bylineBoard}","anonymous":"Anonymous","place":"Place {bylineBoard}","gotoParent":"Go to parent {name}"},"localOverride":false},"CachedAsset:text:en_US-components/customComponent/CustomComponent-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-components/customComponent/CustomComponent-1746664280661","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},"Rank:rank:16":{"__typename":"Rank","id":"rank:16","position":15,"name":"Contributor II","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:560":{"__typename":"User","id":"user:560","uid":560,"login":"Sai_Maganti","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2021-11-24T01:44:10.186-08:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.onestreamsoftware.com/t5/s/otqon28567/m_assets/avatars/default/avatar-3.svg?time=0"},"rank":{"__ref":"Rank:rank:16"},"entityType":"USER","eventPath":"community:otqon28567/user:560"},"ModerationData:moderation_data:4157":{"__typename":"ModerationData","id":"moderation_data:4157","status":"UNMODERATED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:4157":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:560"},"id":"message:4157","revisionNum":1,"uid":4157,"depth":3,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:Reporting"},"parent":{"__ref":"ForumReplyMessage:message:4145"},"conversation":{"__ref":"Conversation:conversation:4143"},"subject":"Re: Advanced Charts - Line chart showing several years by month","moderationData":{"__ref":"ModerationData:moderation_data:4157"},"body":"Nice solution TerryLedet . Alternatively the same can be achieved using BI Viewer component.
I personally found the BI Viewer to be easier and more flexible than \"Chart components\" but it has its own drawbacks
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"208","kudosSumWeight":0,"repliesCount":0,"postTime":"2022-01-14T02:36:11.565-08:00","lastPublishTime":"2022-01-14T02:36:11.565-08:00","metrics":{"__typename":"MessageMetrics","views":4387},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:your-community/community:otqon28567board:Reporting/message:4143/message:4157","replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"CachedAsset:text:en_US-shared/client/components/nodes/NodeIcon-1746664280661":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/nodes/NodeIcon-1746664280661","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":"Reporting","messageSubject":"advanced-charts---line-chart-showing-several-years-by-month","messageId":"4143","replyId":"4145"},"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":[]}