Analysis view

0

Hi

Iam using 4.0 commercial version

i want to add a analysis view by writing a mondrianschema.xml file.

 

and the mdx query is

SELECT {[Contact Location].[All Locations]} ON COLUMNS,
 {([Contact Categorization].[All Accounts]} ON ROWS
FROM [ContactDetails]

I got the error like...

Invalid MDX Query ,Document Parse failed :[Fatal Error]:1:1:content is not allowed in prolog.

Code:
<?xml version="1.0" ?> 
 
- <Schema name="SugarCRM Sales Performance">
-     <Dimension name="Contact Categorization">
-         <Hierarchy hasAll="true" allMemberName="All Contacts" primaryKey="id">
              <Table name="contacts" />
              <Level name="Name" column="last_name" uniqueMembers="false" />
              <Level name="PhoneNumber" column="phone_work" uniqueMembers="true" />
          </Hierarchy>
      </Dimension>
-     <Dimension name="Contact Location">
-         <Hierarchy hasAll="true" allMemberName="All Locations" primaryKey="id" primarykeyTable="contacts">
              <Table name="contacts" />
-             <Join leftKey="id" rightKey="id_c">
                  <Table name="contacts_cstm" /> 
              </Join>
              <Level name="Country" table="contacts_cstm" column="country_c" uniqueMembers="true" />
              <Level name="State/Province" table="contacts_cstm" column="state_c" uniqueMembers="false" />
              <Level name="City" table="contacts_cstm" column="city_c" uniqueMembers="false" />
          </Hierarchy>
      </Dimension>
      <Cube name="ContactDetails">
          <DimensionUsage name="Contact Categorization" source="Contact Categorization" primaryKey="id" />
          <DimensionUsage name="Contact Location" source="Contact Location" primaryKey="id" />
      </Cube>
  </Schema>

sowjanyam's picture
Joined: Jul 5 2011 - 10:18pm
Last seen: 8 years 3 months ago

0 Answers:

No answers yet
Feedback
randomness