mondrian,java,MDX问题

2013-01-05 04:40:54 241 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

mondrian使用测试项目中需要调研使用mondrian，自己从网上下了一个的demo，但是运行过程中遇到了一些问题，随着对问题的分析和解决也加深了对mondrian的使用。阅读详情

select

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

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

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

from [TFACTLOAN]

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

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

全部展示出来了如图：

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

求高手指点啊！！

谢谢

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

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

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

打开时都能点下转点加号

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

...全文

2021哈工大网安837考研初试经验贴这里写自定义目录标题欢迎使用Markdown编辑器新的改变功能快捷键合理的创建标题，有助于目录的生成如何改变文本的样式插入链接与图片如何插入一段漂亮的代码片生成一个适合你的列表创建一个表格设定内容居中、居左、居右SmartyPants创建一个自定义列表如何创建一个注脚注释也是必不可少的KaTeX数学公式新的甘特图功能，丰富你的文章UML 图表FLowchart流程图导出与导入导出导入欢迎使用Markdown编辑器你好！这是你第一次使用 Markdown编辑器所展示的欢迎页。如果你想学习如何使用Mar 阅读详情

vsduizhanss

Java 51,407 成员 86,130 内容

+ 关注 + 加入社区

切换为时间正序

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

打赏
举报

mondrian,java,MDX问题

相关推荐