mondrian,java,MDX问题

vsduizhanss 2013-01-05 04:40:54
select

{[Measures].[余额],[Measures].[户数]} ON COLUMNS,

Crossjoin({FILTER([机构].MEMBERS,[机构].CurrentMember.Name MATCHES '<%=sOrgID %>.*')},

{([客户类型].[All 客户类型],[业务品种].[All 业务品种]ON ROWS



from [TFACTLOAN]





<%=sOrgID %>这个是我传进来的一个值,想取到以它开头的一些数据;



这样是可以过滤掉了 但是 展示的时候不是我想要的,先现在展示时把机构这一列没有加号减号(下转)可点

全部展示出来了如图:





我想要的是 能够和后面那些列都能点加号或减号



求高手指点啊!!

谢谢

现在第一列不能像第2列或者第3列那样有加号点

或者有其他的写法能实现这个功能

能只要我传进来的机构号开头的数据

打开时都能点下转 点加号



重复点加号不会出现机构限制的无效

...全文
156 4 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
4 条回复
切换为时间正序
请发表友善的回复…
发表回复
christyxia 2013-05-20
  • 打赏
  • 举报
回复
Urgent hiring--Investment bank hiring -- Senior BI Developer – China – Shanghai Top tire investment bank Basic in Shanghai Attractive package Found in 19th this multinational group is involved in diversified industries, such as oil and gas, construction and chemicals , but internationally the group is known as a financial services, financial management consultancy group.They provides a vast array of advisory and capital-raising solutions to corporations, financial institutions, governments and public-sector organizations around the world. As Europe debt crises they decide to forces in Asia clients accessing deep pools of liquidity and dynamic growth market. Hence a senior BI developer vacancy has arisen. This is a rare opportunity to be part of a legend. You will be involved in Develop Fixed Income Global Reporting Repository and Data Aggregation and Reporting applications project. These projects are global projects that being used by risk managers, senior management desk heads and support-groups on managing firm wide risk for Fixed Income department. This role need you have strong BI and DB skills including UDB&DB2, Microsoft Analysis Service, OLAP and SQL Server knowledge. As a developer you also need to have solid coding experience using SQL & MDX scripts and Cube tuning. As a Senior Business intelligence you are require to have good communication and coordinate skills both in English and Chinese feel comfortable work with senior management on global scale. Plus if you have Java J2EE and C# .NET experience with investment banking background understand fixed income products familiar with GUI and web application will make you a perfect suite for this Senior BI Developer. Sounds a little bit challenge but also very interest? Do not hesitate pick up the phone reach Christy Xia via +86 23229707 or send an email now to Christy.xia@hays.cn For more job opportunities in the market, please refer to our website www.hays.cn/en for details.
vsduizhanss 2013-01-08
  • 打赏
  • 举报
回复
我想知道 最左边那个按钮 就是 点了 那个按钮的事件在哪写的 自己找不到了。。。

因为想 把那个过滤器 功能去掉
abc41106 2013-01-06
  • 打赏
  • 举报
回复
这个不懂啊。 帮顶一下吧。。。
vsduizhanss 2013-01-05
  • 打赏
  • 举报
回复

51,396

社区成员

发帖
与我相关
我的任务
社区描述
Java相关技术讨论
javaspring bootspring cloud 技术论坛(原bbs)
社区管理员
  • Java相关社区
  • 小虚竹
  • 谙忆
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧