It's almost impossible for anyone else to debug why this MDX isn't correct as we don't have access to your source.
Are you sure the functions yo are calling like 'Today()' actually exist in the OLAP build you're using?
I am trying to learn the MDX Query. I am not sure the functions can be used in the OLAP or not. I am searching the forum if I could get anything that helps in creating this. Thanks
As per my reply on your other post, you might find you'll get more help on an MDX specific forum or a website like StackOverflow.