Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: SQL generated by SqlTupleReader.readTuples do not include measurefilters

  1. #1

    Default SQL generated by SqlTupleReader.readTuples do not include measurefilters

    Hi,

    I have created a cube and configured role level security in Analyzer report and it works fine, but for some levels it throws heap space error.

    Checked mondrian_sql.log and it generates 2 sql for each combination of Levels.

    1. SqlTupleReader.readTuples - generates SQL without filter condition.
    2. Segment.load - generates SQL with filter condition.

    In my sample cube, for few combination which holds small dimension data, it works fine ..

    In some combinations, fetches nearly 4 Lac records from dimension table (alldimension data irrespective of security access) and leads to huge performance issue. Some time it even throws heap space error..

    This performance issue will solve, if my Role level security in applied as filter condition in SQL generated by SqlTupleReader.readTuples.

    Can anyone please suggest workqround to solve this issue?

    Thanks in advance..

    Herwin Rayen

  2. #2

    Default

    Anyone can help to reply the this question? Why Mondrian will post two queries for one request? It definitely harm the performance when the query is very heavy.

    I think everybody who use Mondrian will have this issue.

    Thank you.

  3. #3
    Join Date
    Oct 2016
    Posts
    12

    Default

    I have the same problem, anyone can help?

Tags for this Thread

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.