Creating a calculated measure to display prev month value The 2019 Stack Overflow Developer Survey Results Are InMDX Measure for Whole Previous Month (or previous month average day value)SSAS CUBE Calculated member based on different members in dimension and different measuresTime Calculation + Measure Calculation combined giving incorrect answer (SSAS)Calculated member to get dimension value in previous yearMDX Last Month to date not showing value on Day level when month has different number of daysMDX calculation for 12 rolling monthsSSAS mdx query ParallelPeriodMDX - Calculated MTD measure returning null valueCalculated measure for multiple date hierarchiesSSAS calculated measure gives infinite/null values
Can a flute soloist sit?
How are circuits which use complex ICs normally simulated?
Time travel alters history but people keep saying nothing's changed
What are the motivations for publishing new editions of an existing textbook, beyond new discoveries in a field?
What tool would a Roman-age civilization have for the breaking of silver and other metals into dust?
How can I autofill dates in Excel excluding Sunday?
Is bread bad for ducks?
What is the accessibility of a package's `Private` context variables?
Is a "Democratic" Oligarchy-Style System Possible?
What do the Banks children have against barley water?
How to save as into a customized destination on macOS?
What could be the right powersource for 15 seconds lifespan disposable giant chainsaw?
Origin of "cooter" meaning "vagina"
Deal with toxic manager when you can't quit
How to support a colleague who finds meetings extremely tiring?
Return to UK after being refused entry years previously
Which Sci-Fi work first showed weapon of galactic-scale mass destruction?
A poker game description that does not feel gimmicky
If I score a critical hit on an 18 or higher, what are my chances of getting a critical hit if I roll 3d20?
Resizing object distorts it (Illustrator CC 2018)
Lightning Grid - Columns and Rows?
How come people say “Would of”?
Can you compress metal and what would be the consequences?
Have you ever entered Singapore using a different passport or name?
Creating a calculated measure to display prev month value
The 2019 Stack Overflow Developer Survey Results Are InMDX Measure for Whole Previous Month (or previous month average day value)SSAS CUBE Calculated member based on different members in dimension and different measuresTime Calculation + Measure Calculation combined giving incorrect answer (SSAS)Calculated member to get dimension value in previous yearMDX Last Month to date not showing value on Day level when month has different number of daysMDX calculation for 12 rolling monthsSSAS mdx query ParallelPeriodMDX - Calculated MTD measure returning null valueCalculated measure for multiple date hierarchiesSSAS calculated measure gives infinite/null values
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I have a cube(multidimensional) in SSAS which contains a dimension with a period hierarchy(year, month, periodcategory, periodcode) and a measure "Amount"
Now i try to make a calculated measure which returns the value Amount for the previous month - value Amount for the current month (this will then only be different from the current amount when drilled down to month in the period hierarchy).
I read a lot of posts already about ParallelPeriod function or lag(1) but i don't see how this could help me in this case.
Any advice would be really helpful.
ssas mdx multidimensional-cube
asked Mar 8 at 9:40
TimTim
112
add a comment |
I have a cube(multidimensional) in SSAS which contains a dimension with a period hierarchy(year, month, periodcategory, periodcode) and a measure "Amount"
Now i try to make a calculated measure which returns the value Amount for the previous month - value Amount for the current month (this will then only be different from the current amount when drilled down to month in the period hierarchy).
I read a lot of posts already about ParallelPeriod function or lag(1) but i don't see how this could help me in this case.
Any advice would be really helpful.
ssas mdx multidimensional-cube
asked Mar 8 at 9:40
TimTim
112
Why don't any of the posts you read help? What is different about your cube that prevents the solutions that work for others from working for you?
– Tab Alleman
Mar 8 at 16:18
I too thought ParallelPeriod would be perfect here. Maybe you could post a simple MDX query first: one that shows how you get values for the current month (or a hardcoded month). Then we can advise how to gradually develop that query.
– Magnus Smith
Mar 15 at 21:13
add a comment |
I have a cube(multidimensional) in SSAS which contains a dimension with a period hierarchy(year, month, periodcategory, periodcode) and a measure "Amount"
Now i try to make a calculated measure which returns the value Amount for the previous month - value Amount for the current month (this will then only be different from the current amount when drilled down to month in the period hierarchy).
I read a lot of posts already about ParallelPeriod function or lag(1) but i don't see how this could help me in this case.
Any advice would be really helpful.
ssas mdx multidimensional-cube
asked Mar 8 at 9:40
TimTim
112
I have a cube(multidimensional) in SSAS which contains a dimension with a period hierarchy(year, month, periodcategory, periodcode) and a measure "Amount"
Now i try to make a calculated measure which returns the value Amount for the previous month - value Amount for the current month (this will then only be different from the current amount when drilled down to month in the period hierarchy).
I read a lot of posts already about ParallelPeriod function or lag(1) but i don't see how this could help me in this case.
Any advice would be really helpful.
ssas mdx multidimensional-cube
ssas mdx multidimensional-cube
asked Mar 8 at 9:40
TimTim
112
asked Mar 8 at 9:40
TimTim
112
edited Mar 8 at 9:46
Tim
asked Mar 8 at 9:40
TimTim
112
asked Mar 8 at 9:40
TimTim
112
asked Mar 8 at 9:40
TimTim
112
112
Why don't any of the posts you read help? What is different about your cube that prevents the solutions that work for others from working for you?
– Tab Alleman
Mar 8 at 16:18
I too thought ParallelPeriod would be perfect here. Maybe you could post a simple MDX query first: one that shows how you get values for the current month (or a hardcoded month). Then we can advise how to gradually develop that query.
– Magnus Smith
Mar 15 at 21:13
add a comment |
Why don't any of the posts you read help? What is different about your cube that prevents the solutions that work for others from working for you?
– Tab Alleman
Mar 8 at 16:18
I too thought ParallelPeriod would be perfect here. Maybe you could post a simple MDX query first: one that shows how you get values for the current month (or a hardcoded month). Then we can advise how to gradually develop that query.
– Magnus Smith
Mar 15 at 21:13
Why don't any of the posts you read help? What is different about your cube that prevents the solutions that work for others from working for you?
– Tab Alleman
Mar 8 at 16:18
Why don't any of the posts you read help? What is different about your cube that prevents the solutions that work for others from working for you?
– Tab Alleman
Mar 8 at 16:18
I too thought ParallelPeriod would be perfect here. Maybe you could post a simple MDX query first: one that shows how you get values for the current month (or a hardcoded month). Then we can advise how to gradually develop that query.
– Magnus Smith
Mar 15 at 21:13
I too thought ParallelPeriod would be perfect here. Maybe you could post a simple MDX query first: one that shows how you get values for the current month (or a hardcoded month). Then we can advise how to gradually develop that query.
– Magnus Smith
Mar 15 at 21:13
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55060442%2fcreating-a-calculated-measure-to-display-prev-month-value%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55060442%2fcreating-a-calculated-measure-to-display-prev-month-value%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Why don't any of the posts you read help? What is different about your cube that prevents the solutions that work for others from working for you?
– Tab Alleman
Mar 8 at 16:18
I too thought ParallelPeriod would be perfect here. Maybe you could post a simple MDX query first: one that shows how you get values for the current month (or a hardcoded month). Then we can advise how to gradually develop that query.
– Magnus Smith
Mar 15 at 21:13