PHP phpOlap\Mdx Query::addCalculatedMember Examples

Example #1

File: QueryTest.php Project: romaricdrigon/phpOlap

 public function test2Members()
 {
     $test = new Query("[Sales]");
     $test->addElement("[Measures].[Store Sales]", "ROW");
     $test->addElement("[Time].[Month].Members", "COL");
     $test->addCalculatedMember('[Measures].[moyenne]', '[Measures].[Store Sales] / [Measures].[Sales Count]', 'ROW');
     $test->addCalculatedMember('[Measures].[tendance]', 'IIF(([Measures].[Store Sales], Time.PrevMember)<=([Measures].[Store Sales], Time.CurrentMember), "Croissance", "Décroissance")', 'ROW');
     $result = 'WITH MEMBER [Measures].[moyenne] AS [Measures].[Store Sales]' . ' / [Measures].[Sales Count] MEMBER [Measures].[tendance] AS' . ' IIF(([Measures].[Store Sales], Time.PrevMember)<=([Measures].[Store Sales],' . ' Time.CurrentMember), "Croissance", "Décroissance")' . ' SELECT [Time].[Month].Members ON COLUMNS,' . " {[Measures].[Store Sales], [Measures].[moyenne], [Measures].[tendance]} ON ROWS" . " FROM [Sales]";
     $this->assertEquals($test->toMdx(), $result);
 }