Welcome Guest! To enable all features please Login or Register.
Go to last post Go to first unread
Milan Zivkovic  
#1 Posted : Tuesday, October 2, 2012 12:29:44 PM(UTC)
Milan Zivkovic
Rank: Advanced Member

Groups: extranet\Forum
Joined: 8/16/2012(UTC)
Posts: 11

Is there a possibility to make custom measures (or calculations) in Targit for YTD (Year-to-date) and Previous Year (or, why not, any previous period), as shown in the picture?


For example, user can choose from criteria box a month from Time hierarchy.
There are Product dimension and Amount measure from cube.
"Amount YTD" (sum of Amount from Jan 2012 to May 2012) and "Amount Previous Year" (Amount value from May 2011) are not calculated measures in cube, but I want to calculate them in Targit.

Can I also order (mix) calculated measures with cube measures?
For example, Amount YTD column at first place, then Amount column and at the end Amount PY.
#2 Posted : Tuesday, October 2, 2012 12:43:10 PM(UTC)
Rank: Administration

Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 514

You cannot do what you are asking for (making time dynamic calculations directly in the client), but you can get the same result in a different way by use of comparisons and dynamic criteria.

You will need three comparison elements: One with "This Month" dynamic criteria, another with "YTD" dynamic criteria and a third with "This Month, Last Year" dynamic criteria. These three comparison elements will work as column based criteria for the three columns you ask for.

In your Criteria Bar you will want to insert the "Dynamic Date Origin" selector - to give end users the ability to change current focus month.

For all of this to work, you will of course need to enable Dynamc Periods on your time dimension in your cube.

Edited by user Tuesday, October 2, 2012 12:44:23 PM(UTC)  | Reason: Not specified

Ole Dyring
Users browsing this topic
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.



We use cookies to improve your site experience, but they also provide us with information on your use of our website.
To find out more about the cookies we use and how to delete them, see our Privacy Policy. By continuing to browse the site, you are consenting to our use of cookies.