Forum Discussion

casperholtfarve's avatar
casperholtfarve
Icon for Helper III rankHelper III
3 years ago

Filtering entire report (all pages) from SSAS based on dynamic date

Hi community I need some help! At work we are using cubes from SQL Server Analysis Services as out data foundation/model. The issue here is, that some of the data fields do not get filled out unt...
"Need Help"
SSAS
d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
3 years ago

I would think it would be easier to just not load the incomplete periods into the cube at all. If you had a filter in your ETL process or in a view layer that was feeding the cube (if you are loading from a relational database) that would be the easiest way of achieving this.

casperholtfarve's avatar
casperholtfarve
Icon for Helper III rankHelper III
3 years ago

Hi d_gosbell 
I think you might be right. I was just wondering whether the possibility was actually there in PBI as well. 
But I also think the cleanest way to do it would be through the ETL/loading process. Thanks 🙂