===== 只要是汇总和level对不上,汇总少,level多.就是维度表主键有重复.
===== 事实表有需要丢弃的数据,必须在建模的时候做个屏蔽,否则汇总和level对不上,汇总多,level少
解决方案1: default member
Can not find Default Member with name "[src].[src_name_level1]" in Hierarchy "src"
Can not find Default Member with name "[src].[src_name_level1].members" in Hierarchy "src"
Can not find Default Member with name "[src].AllMembers" in Hierarchy "src"
Can not find Default Member with name "[src].[src_name_level1].AllMembers" in Hierarchy "src"
Can not find Default Member with name "[src].[src_name_level1].[AllMembers]" in Hierarchy "src"
<Hierarchy hasAll="true" primaryKey="src_id" allLevelName="(汇总)" allMemberName="汇总数据" defaultMember="[src].[自主访问]" defaultMember="[src].淘宝站外]"> 直接不通过
<Hierarchy hasAll="true" primaryKey="src_id" allLevelName="(汇总)" allMemberName="汇总数据" defaultMember="汇总数据" > 相当于什么也没做
不知道怎么样才能让default member 默认为第一级.
解决方案2: 衍生出一个level,只有一个值
最终解决方案:
<HierarchyGrant hierarchy="[src]" access="custom" rollupPolicy="partial">
<MemberGrant access="all" member="[src].[一淘]" />
<MemberGrant access="all" member="[src].[淘宝付费流量]" />
<MemberGrant access="all" member="[src].[淘宝免费流量]" />
<MemberGrant access="all" member="[src].[淘宝站外]" />
<MemberGrant access="all" member="[src].[淘宝站外-SNS网站]" />
<MemberGrant access="all" member="[src].[自主访问]" />
</HierarchyGrant>
===== 如果有汇总多,level少的情况,就是维度表主键有丢失
===== 退化维度本来就是会做去重的
===== 用excel透视表与olap对数据一点:有子level的必须搞出来父level
=====