Hitachi Vantara Pentaho Community Forums
Results 1 to 7 of 7

Thread: Disable MDX Editor

  1. #1
    Join Date
    Oct 2006
    Posts
    22

    Question Disable MDX Editor

    Hello
    I use xaction file to create specific MDX query with where statement [Shop].[ShopA]. Work's great, but user can change this in MDX query Where [Shop].[ShopB]. How can an disable MDX editor, or how can i disale changing shop.
    Ofcourse I have 20 users and 20 shops.
    Tahnks for help

  2. #2

    Default

    Hi,

    In the options of the pivotviewComponent of your xaction, just remove the <mdx-edit/> tag.

    Marc

  3. #3

    Default disable with a parameter

    it's works but how can change this with a parameter ?

  4. #4

    Default

    Well, what I would do in that case is using a conditional expression in the xaction.

    Something like that :

    <actions>

    <actions>
    <condition><![CDATA[PARAM == "XX"]]></condition>
    <action-definition>
    (...)
    <mdx-edit/>
    (...)
    </action-definition>
    </actions>

    <actions>
    <condition><![CDATA[PARAM == "YY"]]></condition>
    <action-definition>
    (...)
    </action-definition>
    </actions>

    </actions>

  5. #5
    Join Date
    Oct 2006
    Posts
    22

    Question

    OK it works, but users still can change filter "In Olap Navigator". Can I disable changing filter or Is it posible to create dynamic Access Gran (Role) ?
    Ofcourse I can hide Olap Navigator but I don't want do it.

  6. #6

  7. #7
    Join Date
    Oct 2006
    Posts
    22

    Default

    Please tell me how , I tried everthing but it doesn't work.
    I've created cube

    <Dimension name="Shops">
    <Hierarchy name="Shops" hasAll="false" allMemberName="All Shops">
    <Table name="MyTable">
    </Table>
    <Level name="Shop" table="MyTable" column="ShopName" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
    </Level>
    </Hierarchy>
    </Dimension>

    On Mdx query I add where [Shops.Shops].[ShopBlue]
    Works, but users stiil can change filter, How can i disable changing this filter.
    Of course I can't use "static role" becouse I have 300 users, and 500 shops.
    Is it posible to hide dimension in Olap Navigator ??
    Please tell me how ??
    Thanks for help

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.