rendered paste body<?xml version="1.0" encoding="UTF-8"?>
<Schema name="coin" measuresCaption="Veliine">
<Dimension name="tvrtka" caption="KORISNIK">
<Hierarchy name="tvrtke" hasAll="true" allMemberName="SVI KORISNICI" primaryKey="id">
<Table name="tvrtka"/>
<Level name="Vrsta" column="grupa2" type="String" uniqueMembers="true" ordinalColumn="id"/>
<Level name="Naziv" column="naziv" type="String" uniqueMembers="true" ordinalColumn="id"/>
</Hierarchy>
</Dimension>
<Dimension name="banka" caption="BANKA">
<Hierarchy name="banke" hasAll="true" allMemberName="SVE BANKE" primaryKey="id">
<Table name="banke"/>
<Level name="Banka" column="naziv" uniqueMembers="true"/>
</Hierarchy>
</Dimension>
<Dimension name="Period" type="TimeDimension" caption="PERIOD">
<Hierarchy hasAll="true" allMemberName="SVI PERIODI" primaryKey="id">
<Table name="period"/>
<Level name="Years" column="godina" type="Numeric" uniqueMembers="true" levelType="TimeYears"/>
<Level name="Months" column="mjesecugodini" nameColumn="mjesec" type="Numeric" uniqueMembers="false" levelType="TimeMonths"/>
<Level name="Days" column="danumjesecu" type="Numeric" uniqueMembers="false" levelType="TimeDays"/>
</Hierarchy>
</Dimension>
<Cube name="likvidnost">
<Table name="likvidnost"/>
<DimensionUsage name="tvrtka" source="tvrtka" foreignKey="tvrtka_id"/>
<DimensionUsage name="banka" source="banka" foreignKey="banka_id"/>
<DimensionUsage name="Period" source="Period" foreignKey="time_id"/>
<Dimension foreignKey="racun_id" name="likvidnost" caption="RAUN">
<Hierarchy name="racuni" hasAll="true" allMemberName="SVI RACUNI" allMemberCaption="SVI RAUNI" primaryKey="id">
<Table name="racuni"/>
<Level name="Grupa1" column="level1" uniqueMembers="true" ordinalColumn="id">
<Property name="Id" column="id" type="Numeric" caption="ID"/>
</Level>
<Level name="Grupa2" column="level2" uniqueMembers="false" ordinalColumn="id">
<Property name="Id" column="id" type="Numeric" caption="ID"/>
</Level>
<Level name="Grupa3" column="level3" uniqueMembers="false" ordinalColumn="id">
<Property name="Id" column="id" type="Numeric" caption="ID"/>
</Level>
</Hierarchy>
</Dimension>
<Measure name="StanjeSum" column="stanjekn" visible="false" aggregator="sum" formatString="#,##0; -#,##0"/>
<Measure name="StanjeAvg" column="stanjekn" visible="false" aggregator="avg" formatString="#,##0; -#,##0"/>
<Measure name="HiddenPriljev" column="priljevkn" visible="false" aggregator="sum" formatString="#,##0; -#,##0"/>
<Measure name="HiddenOdljev" column="odljevkn" visible="false" aggregator="sum" formatString="#,##0; #,##0"/>
<CalculatedMember name="Saldo" caption="Saldo" dimension="Measures">
<Formula>[Measures].[Priljev] + [Measures].[Odljev]</Formula>
<CalculatedMemberProperty name="FORMAT_STRING" value="#,##0; -#,##0"/>
</CalculatedMember>
<CalculatedMember name="Priljev" caption="Priljev" dimension="Measures">
<Formula>[Measures].[HiddenPriljev]</Formula>
<CalculatedMemberProperty name="FORMAT_STRING" value="#,##0; -#,##0"/>
</CalculatedMember>
<CalculatedMember name="Odljev" caption="Odljev" dimension="Measures">
<Formula>[Measures].[HiddenOdljev]</Formula>
<CalculatedMemberProperty name="FORMAT_STRING" value="#,##0; -#,##0"/>
</CalculatedMember>
<CalculatedMember name="Stanje" caption="Stanje" dimension="Measures">
<Formula>CASE [Period].Level WHEN [Period].[Days] THEN [Measures].[StanjeSum].Value ELSE Avg(Descendants([Period].CurrentMember, [Period].[Days]), [Measures].[StanjeSum].Value) END</Formula>
<CalculatedMemberProperty name="FORMAT_STRING" value="#,##0; -#,##0"/>
</CalculatedMember>
</Cube>
<Cube name="likvidnost1">
<Table name="likvidnost1"/>
<DimensionUsage name="tvrtka" source="tvrtka" foreignKey="tvrtka_id"/>
<DimensionUsage name="Period" source="Period" foreignKey="time_id"/>
<Measure name="StanjeSum" column="stanje" visible="false" aggregator="sum" formatString="#,##0; -#,##0"/>
<CalculatedMember name="Stanje" caption="Stanje" dimension="Measures">
<Formula>CASE [Period].Level WHEN [Period].[Days] THEN [Measures].[StanjeSum].Value ELSE Avg(Descendants([Period].CurrentMember, [Period].[Days]), [Measures].[StanjeSum].Value) END</Formula>
<CalculatedMemberProperty name="FORMAT_STRING" value="#,##0; -#,##0"/>
</CalculatedMember>
</Cube>
<Role name="herculanea">
<SchemaGrant access="all">
<CubeGrant cube="likvidnost" access="all">
<HierarchyGrant hierarchy="[tvrtka]" access="custom" rollupPolicy="partial" topLevel="[tvrtka].[Vrsta]">
<MemberGrant member="[tvrtka].[TVRTKA].[Pula Herculanea d.o.o.]" access="all"/>
</HierarchyGrant>
</CubeGrant>
</SchemaGrant>
</Role>
<Role name="vodovod">
<SchemaGrant access="all">
<CubeGrant cube="likvidnost" access="all">
<HierarchyGrant hierarchy="[tvrtka]" access="custom" rollupPolicy="partial" topLevel="[tvrtka].[Vrsta]">
<MemberGrant member="[tvrtka].[TVRTKA].[Vodovod d.o.o.]" access="all"/>
</HierarchyGrant>
</CubeGrant>
</SchemaGrant>
</Role>
<Role name="pulapromet">
<SchemaGrant access="all">
<CubeGrant cube="likvidnost" access="all">
<HierarchyGrant hierarchy="[tvrtka]" access="custom" rollupPolicy="partial" topLevel="[tvrtka].[Vrsta]">
<MemberGrant member="[tvrtka].[TVRTKA].[Pulapromet d.o.o.]" access="all"/>
</HierarchyGrant>
</CubeGrant>
</SchemaGrant>
</Role>
<Role name="trznica">
<SchemaGrant access="all">
<CubeGrant cube="likvidnost" access="all">
<HierarchyGrant hierarchy="[tvrtka]" access="custom" rollupPolicy="partial" topLevel="[tvrtka].[Vrsta]">
<MemberGrant member="[tvrtka].[TVRTKA].[Trnica d.o.o.]" access="all"/>
</HierarchyGrant>
</CubeGrant>
</SchemaGrant>
</Role>
<Role name="pulaparking">
<SchemaGrant access="all">
<CubeGrant cube="likvidnost" access="all">
<HierarchyGrant hierarchy="[tvrtka]" access="custom" rollupPolicy="partial" topLevel="[tvrtka].[Vrsta]">
<MemberGrant member="[tvrtka].[TVRTKA].[Pula parking d.o.o.]" access="all"/>
</HierarchyGrant>
</CubeGrant>
</SchemaGrant>
</Role>
<Role name="montegiro">
<SchemaGrant access="all">
<CubeGrant cube="likvidnost" access="all">
<HierarchyGrant hierarchy="[tvrtka]" access="custom" rollupPolicy="partial" topLevel="[tvrtka].[Vrsta]">
<MemberGrant member="[tvrtka].[TVRTKA].[Monte Giro d.o.o.]" access="all"/>
</HierarchyGrant>
</CubeGrant>
</SchemaGrant>
</Role>
<Role name="kastijun">
<SchemaGrant access="all">
<CubeGrant cube="likvidnost" access="all">
<HierarchyGrant hierarchy="[tvrtka]" access="custom" rollupPolicy="partial" topLevel="[tvrtka].[Vrsta]">
<MemberGrant member="[tvrtka].[TVRTKA].[Katijun d.o.o.]" access="all"/>
</HierarchyGrant>
</CubeGrant>
</SchemaGrant>
</Role>
<Role name="plinara">
<SchemaGrant access="all">
<CubeGrant cube="likvidnost" access="all">
<HierarchyGrant hierarchy="[tvrtka]" access="custom" rollupPolicy="partial" topLevel="[tvrtka].[Vrsta]">
<MemberGrant member="[tvrtka].[TVRTKA].[Plinara d.o.o.]" access="all"/>
</HierarchyGrant>
</CubeGrant>
</SchemaGrant>
</Role>
<Role name="castrum">
<SchemaGrant access="all">
<CubeGrant cube="likvidnost" access="all">
<HierarchyGrant hierarchy="[tvrtka]" access="custom" rollupPolicy="partial" topLevel="[tvrtka].[Vrsta]">
<MemberGrant member="[tvrtka].[TVRTKA].[Castrum Pula 97 d.o.o.]" access="all"/>
</HierarchyGrant>
</CubeGrant>
</SchemaGrant>
</Role>
<Role name="lukapula">
<SchemaGrant access="all">
<CubeGrant cube="likvidnost" access="all">
<HierarchyGrant hierarchy="[tvrtka]" access="custom" rollupPolicy="partial" topLevel="[tvrtka].[Vrsta]">
<MemberGrant member="[tvrtka].[TVRTKA].[Luka Pula d.o.o.]" access="all"/>
</HierarchyGrant>
</CubeGrant>
</SchemaGrant>
</Role>
<Role name="djecjivrtici">
<SchemaGrant access="all">
<CubeGrant cube="likvidnost" access="all">
<HierarchyGrant hierarchy="[tvrtka]" access="custom" rollupPolicy="partial" topLevel="[tvrtka].[Vrsta]">
<MemberGrant member="[tvrtka].[USTANOVA].[PU Djeji vrtii Pula]" access="all"/>
</HierarchyGrant>
</CubeGrant>
</SchemaGrant>
</Role>
<Role name="rintintin">
<SchemaGrant access="all">
<CubeGrant cube="likvidnost" access="all">
<HierarchyGrant hierarchy="[tvrtka]" access="custom" rollupPolicy="partial" topLevel="[tvrtka].[Vrsta]">
<MemberGrant member="[tvrtka].[USTANOVA].[PU-IP Rin Tin Tin]" access="all"/>
</HierarchyGrant>
</CubeGrant>
</SchemaGrant>
</Role>
<Role name="knjiznica">
<SchemaGrant access="all">
<CubeGrant cube="likvidnost" access="all">
<HierarchyGrant hierarchy="[tvrtka]" access="custom" rollupPolicy="partial" topLevel="[tvrtka].[Vrsta]">
<MemberGrant member="[tvrtka].[USTANOVA].[Gradska knjinica i itaonica]" access="all"/>
</HierarchyGrant>
</CubeGrant>
</SchemaGrant>
</Role>
<Role name="inkgkpula">
<SchemaGrant access="all">
<CubeGrant cube="likvidnost" access="all">
<HierarchyGrant hierarchy="[tvrtka]" access="custom" rollupPolicy="partial" topLevel="[tvrtka].[Vrsta]">
<MemberGrant member="[tvrtka].[USTANOVA].[INK - Gradsko kazalite Pula]" access="all"/>
</HierarchyGrant>
</CubeGrant>
</SchemaGrant>
</Role>
<Role name="pulasport">
<SchemaGrant access="all">
<CubeGrant cube="likvidnost" access="all">
<HierarchyGrant hierarchy="[tvrtka]" access="custom" rollupPolicy="partial" topLevel="[tvrtka].[Vrsta]">
<MemberGrant member="[tvrtka].[USTANOVA].[JU Pula Sport]" access="all"/>
</HierarchyGrant>
</CubeGrant>
</SchemaGrant>
</Role>
<Role name="ssgpule">
<SchemaGrant access="all">
<CubeGrant cube="likvidnost" access="all">
<HierarchyGrant hierarchy="[tvrtka]" access="custom" rollupPolicy="partial" topLevel="[tvrtka].[Vrsta]">
<MemberGrant member="[tvrtka].[USTANOVA].[Savez sportova grada Pule]" access="all"/>
</HierarchyGrant>
</CubeGrant>
</SchemaGrant>
</Role>
<Role name="pffestival">
<SchemaGrant access="all">
<CubeGrant cube="likvidnost" access="all">
<HierarchyGrant hierarchy="[tvrtka]" access="custom" rollupPolicy="partial" topLevel="[tvrtka].[Vrsta]">
<MemberGrant member="[tvrtka].[USTANOVA].[Pula Film Festival]" access="all"/>
</HierarchyGrant>
</CubeGrant>
</SchemaGrant>
</Role>
<Role name="ztkpula">
<SchemaGrant access="all">
<CubeGrant cube="likvidnost" access="all">
<HierarchyGrant hierarchy="[tvrtka]" access="custom" rollupPolicy="partial" topLevel="[tvrtka].[Vrsta]">
<MemberGrant member="[tvrtka].[USTANOVA].[Zajednica tehnike kulture]" access="all"/>
</HierarchyGrant>
</CubeGrant>
</SchemaGrant>
</Role>
<Role name="poupula">
<SchemaGrant access="all">
<CubeGrant cube="likvidnost" access="all">
<HierarchyGrant hierarchy="[tvrtka]" access="custom" rollupPolicy="partial" topLevel="[tvrtka].[Vrsta]">
<MemberGrant member="[tvrtka].[USTANOVA].[Puko otvoreno uilite]" access="all"/>
</HierarchyGrant>
</CubeGrant>
</SchemaGrant>
</Role>
<Role name="SVI KORISNICI">
<SchemaGrant access="all">
<CubeGrant cube="likvidnost" access="all">
</CubeGrant>
</SchemaGrant>
</Role>
<Role name="TVRTKA">
<SchemaGrant access="all">
<CubeGrant cube="likvidnost" access="all">
<HierarchyGrant hierarchy="[tvrtka]" access="custom" topLevel="[tvrtka].[Vrsta]">
<MemberGrant member="[tvrtka].[TVRTKA]" access="all"/>
</HierarchyGrant>
</CubeGrant>
</SchemaGrant>
</Role>
<Role name="USTANOVA">
<SchemaGrant access="all">
<CubeGrant cube="likvidnost" access="all">
<HierarchyGrant hierarchy="[tvrtka]" access="custom" topLevel="[tvrtka].[Vrsta]">
<MemberGrant member="[tvrtka].[USTANOVA]" access="all"/>
</HierarchyGrant>
</CubeGrant>
</SchemaGrant>
</Role>
</Schema>