Creating a calculated measure to display prev month valueMDX 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

Why "be dealt cards" rather than "be dealing cards"?

What's a natural way to say that someone works somewhere (for a job)?

Teaching indefinite integrals that require special-casing

At which point does a character regain all their Hit Dice?

How was Earth single-handedly capable of creating 3 of the 4 gods of chaos?

Why does John Bercow say “unlock” after reading out the results of a vote?

How could Frankenstein get the parts for his _second_ creature?

Applicability of Single Responsibility Principle

I'm in charge of equipment buying but no one's ever happy with what I choose. How to fix this?

Generic lambda vs generic function give different behaviour

Can I use my Chinese passport to enter China after I acquired another citizenship?

Ways to speed up user implemented RK4

Can criminal fraud exist without damages?

What will be the benefits of Brexit?

Hide Select Output from T-SQL

voltage of sounds of mp3files

How do I rename a LINUX host without needing to reboot for the rename to take effect?

Mapping a list into a phase plot

Valid Badminton Score?

If you attempt to grapple an opponent that you are hidden from, do they roll at disadvantage?

Is the destination of a commercial flight important for the pilot?

How can I get through very long and very dry, but also very useful technical documents when learning a new tool?

What are the ramifications of creating a homebrew world without an Astral Plane?

Curses work by shouting - How to avoid collateral damage?



Creating a calculated measure to display prev month value


MDX 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













0















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.










share|improve this question
























  • 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















0















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.










share|improve this question
























  • 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













0












0








0








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.










share|improve this question
















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






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Mar 8 at 9:46







Tim

















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

















  • 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












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
);



);













draft saved

draft discarded


















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















draft saved

draft discarded
















































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.




draft saved


draft discarded














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





















































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







Popular posts from this blog

Can't find variable: document ReactNative Js2019 Community Moderator ElectionReactNative: how to center text?Can't find variable: navigate - ReactNative navigationReact Native error: “Can't find variable: TouchableHighlight”How to use Expo.DocumentPicker.getDocumentAsync properly. [Expo] [ReactNative]Can't find variable: regeneratorRuntime (ReactNative)Reactnative Expo It is advisable for a StartUp?Can't find variable : Self / Can't install firebaseNPM Install Error in installing ReactNative CLIContacts Displaying in App using ReactnativeFacebook login error: can't find variable: Alert

Thal And Out Agency railway station See also References External links Navigation menuOfficial Web Site of Pakistan RailwaysArchivedOfficial Web Site of Pakistan Railwayseeexpanding ite

Posting a File and Associated Data to a RESTful WebService preferably as JSON2019 Community Moderator ElectionREST URI convention - Singular or plural name of resource while creating itUploading both data and files in one form using Ajax?How do I upload a file with metadata using a REST web service?REST API - file (ie images) processing - best practicesSpring: JSON data and file in the same requestREST API Put large dataPosting a file and JSON data to Spring rest serviceRESTful Web Service Upload/Download Large Data With JSONREST API Design sending JSON data and a file to the api in same requestPost JSONArray to REST servicePUT vs. POST in RESTParsing values from a JSON file?JavaScript/jQuery to download file via POST with JSON dataHow do I upload a file with metadata using a REST web service?How to POST JSON data with Curl from Terminal/Commandline to Test Spring REST?Separate REST JSON API server and client?what's the correct way to send a file from REST web service to client?How do I write JSON data to a file?What is “406-Not Acceptable Response” in HTTP?REST API - file (ie images) processing - best practices