Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a problem. I want to see empty weeks.
Checked all dates,i see all weeks in selection:
For example: with selection in column Orderer = Orderer1, i need to see empty week 4:
How i have to show all weeks in selection MASTER CALENDAR (FROM - TO) with empty weeks (show '-')?
If you check your data model you will find that when Orderer=Orderer1, there is no date corresponding to week 4 that's why you can not see week 4. The dimension value for week 4 does not exist when Orderer=Orderer1.
2014.01.02 | Orderer1 | 1 | 526.61 | 1 |
2014.01.02 | Orderer1 | 2 | 1001 | 1 |
2014.01.03 | Orderer1 | 3 | 687.73 | 1 |
2014.01.04 | Orderer1 | 4 | 1271.9 | 1 |
2014.01.05 | Orderer1 | 5 | 1876.5 | 1 |
2014.01.06 | Orderer1 | 6 | 787.31 | 2 |
2014.01.07 | Orderer1 | 7 | 655.46 | 2 |
2014.01.08 | Orderer1 | 8 | 629.67 | 2 |
2014.01.09 | Orderer1 | 9 | 1641.4 | 2 |
2014.01.10 | Orderer1 | 10 | 1706.9 | 2 |
2014.01.11 | Orderer1 | 11 | 30.49 | 2 |
2014.01.12 | Orderer1 | 12 | 1561.9 | 2 |
2014.01.13 | Orderer1 | 13 | 781.65 | 3 |
2014.01.14 | when | 14 | 1335.2 | 3 |
2014.01.15 | Orderer1 | 15 | 219.35 | 3 |
2014.01.16 | Orderer1 | 16 | 1833.3 | 3 |
2014.01.17 | Orderer1 | 17 | 1125.2 | 3 |
2014.01.28 | Orderer1 | 28 | 1882.6 | 5 |
2014.01.29 | Orderer1 | 29 | 268.16 | 5 |
2014.01.30 | Orderer1 | 30 | 525.87 | 5 |
2014.01.31 | Orderer1 | 31 | 1405.8 | 5 |
2014.02.01 | Orderer1 | 32 | 1363 | 5 |
2014.02.02 | Orderer1 | 33 | 156.46 | 5 |
2014.02.03 | Orderer1 | 34 | 629.89 | 6 |
2014.02.04 | Orderer1 | 35 | 1103.9 | 6 |
2014.02.05 | Orderer1 | 36 | 1637.1 | 6 |
2014.02.06 | Orderer1 | 37 | 736 | 6 |
2014.02.07 | Orderer1 | 38 | 695.24 | 6 |
2014.02.08 | Orderer1 | 39 | 951.58 | 6 |