you attached the workbook with the live connection.
Could you please attach the workbook with extract , because while opening its asking for DB Credentials.
Thanks a lot Naveen, I am verifying the results and will get back soon.
But I have noticed something strange! Can you please check the difference in number of records/values in the Project - Department dimension between the two scenarios below:
1. On a new sheet, drag [Project - Department] to Rows, see how many values are there.
2. Drag [Project - Department] to Filter and see how many values are there.
The Filter dialog has much less values than what the dimension actually contains! Why is that?
Can you elaborate on the difference between using [Project - Department] on filter or using a Group on that dimension as a filter? Why should it make a difference?
Now I am thinking THAT could be the reason behind my initial problem!
Ok, I found out the reason behind the difference.. it is because of the date filter [Project - End Date]!
So, I guess the Group approach is better that a filter on the data, because the Date filter rules our certain values from the database, and that is not a safe approach, is it! If a new row is inserted in the database for TODAY() that has a department that is not "ticked" in the [Project - Department] filter, that will not be taken into account, right?
I will change the entire thing to your Group approach and check the data.
Yes, it works real nice now.... Thanks very much