spec/mondrian_spec.rb in mondrian-olap-1.1.0 vs spec/mondrian_spec.rb in mondrian-olap-1.2.0

@@ -1,5 +1,7 @@
+# encoding: utf-8
+
 require "spec_helper"
 
 describe "Mondrian features" do
   before(:all) do
     @schema = Mondrian::OLAP::Schema.define do
@@ -9,18 +11,44 @@
           hierarchy :has_all => true, :primary_key => 'id' do
             table 'customers'
             level 'Gender', :column => 'gender', :unique_members => true
           end
         end
+        dimension 'Promotions', :foreign_key => 'promotion_id' do
+          hierarchy :has_all => true, :primary_key => 'id' do
+            table 'promotions'
+            level 'Promotion', :column => 'id', :name_column => 'promotion', :unique_members => true, :ordinal_column => 'sequence', :type => 'Numeric'
+          end
+        end
+        dimension 'Linked Promotions', :foreign_key => 'customer_id' do
+          hierarchy :has_all => true, :primary_key => 'id', :primary_key_table => 'customers' do
+            join :left_key => 'related_fullname', :right_key => 'fullname' do
+              table "customers"
+              join :left_key => "promotion_id", :right_key => "id" do
+                table "customers", :alias => "customers_bt"
+                table "promotions"
+              end
+            end
+            level 'Promotion', :column => 'id', :name_column => 'promotion', :unique_members => true, :table => 'promotions', :ordinal_column => 'sequence', :type => 'Numeric', :approx_row_count => 10
+          end
+        end
         dimension 'Customers', :foreign_key => 'customer_id' do
           hierarchy :has_all => true, :all_member_name => 'All Customers', :primary_key => 'id' do
             table 'customers'
             level 'Country', :column => 'country', :unique_members => true
             level 'State Province', :column => 'state_province', :unique_members => true
             level 'City', :column => 'city', :unique_members => false
-            level 'Name', :column => 'fullname', :unique_members => true
+            level 'Name', :column => 'fullname', :unique_members => true do
+              property 'Related name', :column => 'related_fullname', :type => "String"
+            end
           end
+          hierarchy 'ID', :has_all => true, :all_member_name => 'All Customers', :primary_key => 'id' do
+            table 'customers'
+            level 'ID', :column => 'id', :type => 'Numeric', :internal_type => 'long', :unique_members => true do
+              property 'Name', :column => 'fullname'
+            end
+          end
         end
         dimension 'Time', :foreign_key => 'time_id', :type => 'TimeDimension' do
           hierarchy :has_all => false, :primary_key => 'id' do
             table 'time'
             level 'Year', :column => 'the_year', :type => 'Numeric', :unique_members => true, :level_type => 'TimeYears'
@@ -46,8 +74,50 @@
       @olap.from('Sales').
       columns('[Measures].[Unit Sales]').
       rows('[Customers].children').order('Now()', :asc).
       execute
     end.should_not raise_error
+  end
+
+  # test for https://jira.pentaho.com/browse/MONDRIAN-2683
+  it "should order crossjoin of rows" do
+    lambda do
+      @olap.from('Sales').
+      columns('[Measures].[Unit Sales]').
+      rows('[Customers].[Country].Members').crossjoin('[Gender].[Gender].Members').
+        order('[Measures].[Unit Sales]', :bdesc).
+      execute
+    end.should_not raise_error
+  end
+
+  it "should generate correct member name from large number key" do
+    result = @olap.from('Sales').
+      columns("Filter([Customers.ID].[ID].Members, [Customers.ID].CurrentMember.Properties('Name') = 'Big Number')").
+      execute
+    result.column_names.should == ["10000000000"]
+  end
+
+  # test for https://jira.pentaho.com/browse/MONDRIAN-990
+  it "should return result when diacritical marks used" do
+    full_name = '[Customers].[USA].[CA].[Rīga]'
+    result = @olap.from('Sales').columns(full_name).execute
+    result.column_full_names.should == [full_name]
+  end
+
+  it "should execute MDX with join tables" do
+    # Load dimension members in Mondrian cache as the problem occurred when searching members in the cache
+    @olap.from('Sales').columns('CROSSJOIN({[Linked Promotions].[Promotion].[Promotion 2]}, [Customers].[Name].Members)').execute
+
+    mdx = <<~MDX
+      SELECT
+        NON EMPTY FILTER(
+          CROSSJOIN({[Linked Promotions].[Promotion].[Promotion 2]}, [Customers].[Name].Members),
+          (([Measures].[Unit Sales]) <> 0)
+        ) ON ROWS,
+        [Measures].[Unit Sales] ON COLUMNS
+      FROM [Sales]
+    MDX
+
+    expect { @olap.execute mdx }.not_to raise_error
   end
 
 end