I am trying in our student information system. But now ı have a problem. I can’t create On-line analytical processing document with what-if engine.I am trying in our student information system. But now ı have a problem. I can’t create On-line analytical processing document with what-if engine.
OBYS_DB datasource in MSSQL 2016
<Schema name="OLAP_OBYS_LITE">
<Dimension visible="true" highCardinality="false" name="Organizasyon" caption="Organizasyon">
<Hierarchy visible="true" hasAll="true" allMemberName="Tum Birimler" primaryKey="ORGANIZATION_ID">
<Table name="OLAP_ORGANIZATION" schema="dbo" alias="OLAP_ORGANIZATION">
</Table>
<Level name="Bolge" visible="true" column="AREA_NAME" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
</Level>
<Level name="Ulke" visible="true" column="COUNTRY_NAME" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
</Level>
<Level name="Kampus" visible="true" column="INSTITUTION_NAME" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
</Level>
<Level name="Okul" visible="true" column="ORGANIZATION_NAME" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
</Level>
</Hierarchy>
</Dimension>
<Cube name="Students" visible="true" cache="true" enabled="true">
<Table name="OLAP_STUDENT" schema="dbo" alias="OLAP_STUDENT">
</Table>
<DimensionUsage source="Organizasyon" name="Organizasyon" visible="true" foreignKey="ORGANIZATION_ID" highCardinality="false">
</DimensionUsage>
<Measure name="Student Count" column="STUDENT_ID" aggregator="count">
</Measure>
</Cube>
</Schema>
