Weird behavior of QVW

[#1]

Hi All,

I have QVW file on server, When i open and reload it will show some value. After saving and reopening again it shows some other data. Dunno from where tat data is coming.

In the local its proper

Please help me with this.

Regards,

Keerthi KS

[Anonymous]

No need to change anything

[#3]

After saving also i am getting reduction values.

Its not showing data for one project.

[jonathandienst]

It's by design and sounds like it working correctly, so are you sure you want to 'fix' it?

But assuming that it is wrong, and you no longer require the security, comment out the section access code (everything between Section Access; and Section Application;).

Or change your access in the access source data or the inline load for your load script so that the data is not reduced for you (but will still be reduced for other users).

[#5]

Let me explain is clearly.

Without section access i am getting 18,729,410,110. After saving the document and opening again it shows 11,514,541,906.

So much of difference and its not showing data for few projects.

[#6]

If i comment the section access i will not have access to the document

Please someone help me with this.

[jagan]

Hi,

Try like this instead of giving ALL try giving *. OR remove ROLL column in Section access tables.

ACCESS:

LOAD * INLINE [

    ACCESS, NTNAME, PROJECTID, ROLL

    ADMIN, FUGUEDB\ADMINISTRATOR, 53, ALL

    ADMIN, QlikView1\Administrator, *, ALL

    ADMIN, TEBS\sivannagari.roopa, *, ALL

];

Concatenate(ACCESS)

LOAD 'USER' as ACCESS,

  ADNAME as NTNAME,

     if(Len(trim(PROJECTID))=0,'*',PROJECTID) as PROJECTID,

     ROLL

FROM

[..\..\00_includes\config\Access.xlsx]

(ooxml, embedded labels, table is Access) Where Len(Trim(ADNAME))<>0;

Concatenate(ACCESS)

LOAD Distinct

    'ADMIN' as ACCESS,

  'FUGUEDB\ADMINISTRATOR' as NTNAME,

     PROJECTID as PROJECTID,

     '*' as ROLL

Resident Projects; 

Concatenate(ACCESS)

LOAD Distinct ACCESS,NTNAME,'OTHERS' as PROJECTID,ROLL Resident ACCESS;

    //FROM

//[..\..\10_data_sources\teproject.qvd]

//(qvd);

Section Application;

ROLL:

LOAD ROLL,

     SH_Inventory,

     SH_Sales,

     SH_Receivable,

     SH_Cashflow,

     SH_Marketing

FROM

[..\..\00_includes\config\Access.xlsx]

(ooxml, embedded labels, table is ROLLs);

[#8]

Hi,

I have disabled the

Document Properties---->Opening ----->Initial Data Reduction based on access

and also

Document Properties---->Security------>User Previleges------>Reduce Data

Now its showing full data.

Thanks a lot guys

Regards,

Keerthi KS

[jagan]

Hi Keerthi,

If you do this all data is visible to everyone.  Is that your requirment?  Data will not be reduced based on users?  Check your Section Access requirement once.

Regards,

Jagan.

[#10]

Only few users data is restricted based on ProjectID. Will it be visible if this is removed ??

[jagan]

Yes, it is working earlier correctly as expected.  After your changes all data is visible to all the users.  I think you should not supposed to do this.

You are creating issues when there is no issue in the Dashboard.

Regards,

jagan.