EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB45699: Cross join is used between two data import cubes in MicroStrategy Web 9.4.x


Community Admin

• Strategy


Cross join is used between two data import cubes in MicroStrategy Web 9.4.x

SYMPTOM:
Import following two Excel files into Strategy Web 9.4.x:

ka04W000000OhF9QAK_0EM440000002CWV.jpeg

NOTE: All columns are imported as attributes.
Add columns from two datasets into one dashboard, but cross join is used between datasets and there are many redundant rows, as shown below:

ka04W000000OhF9QAK_0EM440000002CWY.png

CAUSE:
Strategy Web 9.4.x does not support 1:1 relationship between data import cubes.
 
ACTION:
Please upgrade to Strategy 9.5.1 or higher version.


Comment

0 comments

Details

Knowledge Article

Published:

May 30, 2017

Last Updated:

May 30, 2017