my name is Michael I'm using BPC 7.0 for Microsoft and I'm feeling a little insecure concerning the use of time elements in BPC.
So far I have build up an environment for consolidation with YTD data. Everything was fine as I need only one time dimension and only month as periods.
In a new project we are trying to establish a reporting application. We want to report on sales and purchasing figures and we are going down to the single order.
That means that I have now invoice dates, shipping dates, order dates, purchasing dates and so on. I think it is easy to see, that the standard time dimension, even if I go down to days won't do the trick.
I have now considered to create dimensions for the different dates. The problem I see here, is that I can't set up filter in BPC for Excel to choose order with the order date from, lets say, April 1st to April 10th.
Has anybody here already build something similar and has made some useful experiences.
I appreciate all kind of help on that issue.
Thank you very much