The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
Quarterly / yearly values only show the amount of the last month/quarter
Hi everyone,
Good day. We are new to OneStream, and we are building a cube view wherein it outputs quarterly columns for a certain year. However, it only outputs the last period/month for the quart...
Hello,
Please include view dimension in your member filter and remove it from the POV pane as your report uses two different view members. For the first four columns, include V#QTD to get the quarterly data (sum of Jan + Feb + mar = Q1) and for the fourth column add V#YTD to get the YTD data (JAN to DEC). You can add the view member to the columns either Level1 or Level2. Hope this resolves your issue.
Thank you.
0
Hi,
I tried to use the Q1.Member, etc. because the base member in our time dimension pertains to weeks. I also used YTD. It doesn't output the sum for each quarter (it outputs the value of the last month for each quarter). And for the year, it just output the value of Q4 and not the sum of all quarters for that year
Hello,
Please include view dimension in your member filter and remove it from the POV pane as your report uses two different view members. For the first four columns, include V#QTD to get the quarterly data (sum of Jan + Feb + mar = Q1) and for the fourth column add V#YTD to get the YTD data (JAN to DEC). You can add the view member to the columns either Level1 or Level2. Hope this resolves your issue.
Thank you.
0
Thank you Sabaritha, this worked. I added it in the member filter, now I get the concept. Thank you so much