Daily Time Dimension and Related Measure Member
One my prospect from retail wants to have a daily planning. So here, I have some questions about this:
1) I creat days under week in Time dimension, and found there are WTD in tblformula and tlbsformula. But from BPC for excel, I can see the memeber (by days) in time dimension, but can't see WTD in measure dimension Which only have "periodic/YTD/MTD". How to solve it?
2) Is there any suggestion for the dimension building? I think maybe I can build another dimension named "Dtime", to combine Dtime and Time dimension, I can simplfily the maintenance of Time dimension. But for the standard copy data package, I can't select Dtime, only can copy by Time. How to solve it?
3) the Capacity: Retail industry needs to plan via daily/stores/brand, each dimension has over thoudands members. Can BPC support such planning with good performance? is there any customer references to share?
Thanks in advance!