No announcements
Found 2358598 threads
-
0 VotesParallelPeriod with unbalanced intermediate hierarchy level error, 53 week year issue
intermediate level in the hierarchy (quadweek) is unbalanced gives unwanted results. Why does this happen? I have looked at ...Answered | 2 Replies | 3090 Views | Created by David Clem - Wednesday, November 30, 2011 6:59 PM | Last reply by David Clem - Thursday, December 1, 2011 2:16 PM
-
0 Votes
Using ParallelPeriod with Year - Month - DayOfWeek hierarchy
I have defined a time hierarchy as follows: Year - Month - Day of Week. E.g. (2013 - March - Monday). I am trying to get average sales by item by day of week by ...Answered | 6 Replies | 1703 Views | Created by polthel - Tuesday, February 26, 2013 9:27 AM | Last reply by polthel - Wednesday, February 27, 2013 4:46 AM -
0 Votes
unbalanced hierarchy
!7B84B0F2C239489A!5319.entry Instead of leaving the intermediate levels NULL or copying the Parent Level downwards, copy the key upwards. And use ...Answered | 3 Replies | 4067 Views | Created by fleo - Wednesday, March 10, 2010 9:47 PM | Last reply by fleo - Friday, March 12, 2010 5:44 PM -
0 Votes
Get Previous Year Dates from Week Hierarchy
year, you must apply year level(instead of week level) as interval in ParallelPeriod function. The expression can be ...Answered | 6 Replies | 498 Views | Created by Jonimatix - Wednesday, March 16, 2016 9:27 AM | Last reply by Jonimatix - Thursday, March 17, 2016 8:19 AM -
1 Votes
Unbalanced hierarchy with ParentChild HideMemberIf
one i use to reprensente the parent-child) in a Hierarchy and after use the HidememberIf because when i try to add this member to a hierarchy it's tell me 'The source ...Answered | 2 Replies | 2957 Views | Created by vincent.diallonort - Friday, April 20, 2012 7:49 PM | Last reply by vincent.diallonort - Friday, April 20, 2012 8:34 PM -
0 Votes
"Unbalanced" hierarchy
;more additional information (e.g. inscomp), please modify the cube I created. If it doesn’t work, upload it and I will check what’s wrong with this ...Answered | 10 Replies | 5324 Views | Created by xxviktor - Monday, December 27, 2010 10:54 PM | Last reply by xxviktor - Friday, January 7, 2011 11:26 AM -
1 Votes
ParallelPeriod for week over week
In a Calendar dimension hierarchy, I am using ParallelPeriod for a week over week calculation. By returning the member from the prior period at the same relative ...Answered | 5 Replies | 5189 Views | Created by Javier Guillen - Tuesday, May 25, 2010 1:47 PM | Last reply by Javier Guillen - Wednesday, May 26, 2010 12:26 PM -
0 Votes
parallel period not working for week 53
Hi P, It really depends on which week you want. With ParallelPeriod going back one year, you will go to the same week number in the ...Answered | 3 Replies | 1354 Views | Created by Pravin.c - Monday, November 23, 2015 9:14 PM | Last reply by Simon_Hou - Tuesday, November 24, 2015 11:45 AM -
1 Votes
SSAS - Unbalanced Hierarchy
Dear friends, I'm having some problems creating an unbalanced hierarchy on a SSAS Dimension. I have some records without subcategory values... I ...Answered | 1 Replies | 4569 Views | Created by PCGD - Tuesday, October 19, 2010 5:25 PM | Last reply by PCGD - Tuesday, October 19, 2010 10:51 PM -
0 Votes
Remove Weeks 53 from ISO Year/Week structure in query
succeed in limiting the data that is fetched by the calculated members. They look outside of the standard slicer (so a subquery with -[Date].[Week].&[53] will not ...Answered | 2 Replies | 3916 Views | Created by tss68nl - Monday, January 11, 2010 9:34 PM | Last reply by tss68nl - Tuesday, January 12, 2010 10:21 AM -
11 Votes
Week 52 or Week 53
Hi Week numbers are difficult to resolve. If you look at the year 2018, then the year starts with Jan 1 as the first day of week 1, and ...Answered | 32 Replies | 1197 Views | Created by Gary Simpson - Wednesday, August 16, 2017 1:21 PM | Last reply by Zhanglong Wu - Friday, August 25, 2017 6:05 AM -
0 Votes
parallelperiod for week doesn't work somehow.
If "Calendar" is the hierarchy you have defined on Date dimension you are using CURRENTMEMBER on the level "Week". CURRENTMEMBER works only with ...Answered | 1 Replies | 2021 Views | Created by Gtrshredding - Tuesday, September 25, 2012 9:07 PM | Last reply by Karthik Rangaraj - Tuesday, September 25, 2012 11:22 PM -
0 Votes
Mdx - one Year Contains 53 Weeks
hierarchy? Then you can write something like: LYTD: SUM( YTD( ...Answered | 1 Replies | 5846 Views | Created by JuliaRev - Monday, February 2, 2009 5:12 AM | Last reply by Chu Xu - Monday, February 16, 2009 3:10 AM -
0 Votes
Calendar week - previous week , last year week
give 52 or 53 or 54 based on the previous month or year . So i'm stuck with the logic . Similar way I even need the week number of last ...Answered | 5 Replies | 3045 Views | Created by vamz9 - Wednesday, December 19, 2012 3:16 AM | Last reply by --CELKO-- - Thursday, December 20, 2012 3:08 AM -
4 Votes
SSAS 2008 Ragged /unbalanced hierarchy
Matt, I am afraid that you could not use the hieararchy at the rows level currently since it could not return the data at all levels. You can resolve this issue by not ...Answered | 14 Replies | 11607 Views | Created by MAQ1 - Thursday, March 11, 2010 3:50 PM | Last reply by xxviktor - Monday, February 7, 2011 4:54 PM -
0 Votes
ParallelPeriod
can check the level of the CurrentMember and handle appropriately. IIF( IsEmpty(ParallelPeriod([Date].[Fiscal ...Answered | 1 Replies | 1136 Views | Created by rookie_ssis - Tuesday, February 11, 2014 3:40 PM | Last reply by BillAnton - Tuesday, February 11, 2014 11:09 PM -
0 Votes
MDX: LASTPERIODS issue when using with PARALLELPERIOD (Previous Month) at week level
) week of current month, then in previous month parallel period (week) will be (NULL) , and if I apply LASTPERIODS function with PARALLELPERIODAnswered | 1 Replies | 6468 Views | Created by Bhudev - Tuesday, August 11, 2009 6:04 AM | Last reply by John Shiangoli - Tuesday, August 11, 2009 3:03 PM -
0 Votes
ParallelPeriod Error
Sorry, the above line {ParallelPeriod([Date].[Year - Quarter - Month - Date].[Date], 1, should be {ParallelPeriodAnswered | 4 Replies | 5802 Views | Created by mstasi - Monday, March 5, 2007 10:36 PM | Last reply by mstasi - Friday, March 9, 2007 4:42 PM -
2 Votes
53 weeks in a year
I'm second to Wisepin. Every year (regardless it is leap or not) has 52 complete week. With datepart function you will get 53 or ...Answered | 8 Replies | 9657 Views | Created by Milli_22 - Monday, March 30, 2009 2:17 PM | Last reply by RBarryYoung - Monday, March 30, 2009 11:46 PM -
0 Votes
MDX IsGeneration() results for unbalanced hierarchy
generation....Take the example of the Employee.Employees parent-child unbalanced hierarchy in Adventure Works - Ken J. Sánchez is at the 5th generation, but someAnswered | 2 Replies | 4197 Views | Created by headmann - Wednesday, April 14, 2010 8:54 PM | Last reply by headmann - Monday, April 19, 2010 6:52 PM - Items 1 to 20 of 2358598 Next ›
No announcements
