I have 2 date fields - AuditStartDate & AuditEndDate in Dimension DimCustomer.
This has foreign key relationship to DateKey in the DimDate dimension table
In DimDate Dimension table you have the dimension key. Datekey is derived based on date (YYYYMMDD) as integer.
I want to filter out records in where AuditStartDate <= Current Date(Converted to (YYYYMMDD) integer) and AuditEndDate >= Current Date(Converted to (YYYYMMDD) integer)
How do I do this in MDX? Please help
View Complete Post