tag:blogger.com,1999:blog-4527276399966185267.post5568790104636511205..comments2024-03-06T20:16:30.599-08:00Comments on Diethard Steiner on Business Intelligence: Current date function on MondrianAnonymoushttp://www.blogger.com/profile/05683544764949933581noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-4527276399966185267.post-68365789910413537212013-02-08T06:27:11.421-08:002013-02-08T06:27:11.421-08:00In order to compare [CAF] every year in a same mon...In order to compare [CAF] every year in a same month and day i do this :<br /><br />with<br />member Measures.[test] as<br />(CurrentDateMember([Temps],'["Temps].["||[Temps].currentMember.name||"]."[m].[d]'),[Measures].[CAF])<br /><br />SELECT<br />NON EMPTY {Hierarchize({[Measures].[test]})} ON COLUMNS,<br />NON EMPTY {Hierarchize({[Temps.hTemps].[Annee].Members})} ON ROWS<br />FROM [Avancement]<br /><br />But it isn't works, could someone explain me why ?<br /><br />Thanks in advance!!Anonymoushttps://www.blogger.com/profile/10965511616089500109noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-41702989386919607172011-11-15T11:21:03.596-08:002011-11-15T11:21:03.596-08:00Thanks a lot for your feedback! Much appreciated!Thanks a lot for your feedback! Much appreciated!Anonymoushttps://www.blogger.com/profile/05683544764949933581noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-65219082945560229762011-11-15T05:00:25.062-08:002011-11-15T05:00:25.062-08:00So useful!!! Thank you very much for that post!
c...So useful!!! Thank you very much for that post!<br /><br />cheers,<br />NopsNopshttps://www.blogger.com/profile/12370248315355523454noreply@blogger.com