I am on this activity from Level 1 training at the moment, making a module as per below. And it says to addActive? List subset as well as E2 Employees# and Time to the dimensions.
I took it as doing this:
But I got the following error message instead:
I am not too certain what I should be doing from here to accomplish the task. Any pointer would be much appreciated!
Solved!去解决方案。
Thank you! I did not expect to hear from anyone so quickly! Likewise, I found the followingpostwhich backs your suggestion as well as you responded.
Now, I am wondering if you can give me a good pointer for adding Time in dimentions as it says I also need Time in my dimension. As the data structure is like this:
As per instruction below:
And to add Time dimension means this (by Day in below case):
I am feeling a little confused about why I need Time dimension here. When all this is describing is each active employee. The time dimension would be there to aggregate anyone who started on each day but the data structure is not for aggregation? Would you kindly tell me what I am misunderstanding here in introducing Time in dimentions?
Hi@anirudh
谢谢for the further response - much appreciated.
As per below, I can now see what this module will be used. Monthly reference to the expense allocations with some useful dates. Redundant alright, but it is used for a quick lookup presumably.
Ah, I get it now. Because you have SYS00 Time Settings in dimension Time by month:
I need to match the dimension by that to meet the grouping unit:
Then you get: