Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I encounter some issue when i notice i found that below expression when place at dimension it does not work for QV ver 9 ( it work for Ver 12 ) :-
=IF(GROUP_CLASS='G1',COMPANY)
I also consult the expert here , Mr Kri advise me my sales order table , should have only 1 field link to other table.
After check my data model on sales table , i found that most of them have only 1 field link to other table , which is correct. except for $Syn 5 which i found there are 3 field link to other table.
Am i correct to said that i should focus on remove the field that link to $Sync 5 Table , that is to remove the link on field name for SOURCE GROUP_CLASS date ?
Try this
Rename Currency field from WhatifDimension13 table
Rename GROUP_CLASS field from sales_G table
Rename date field from Supplier table
Rename GROUP_CLASS field from sales table
Hi,
If you have a synthetic Key starting with $syn5, it means that you have already 5 synthetic Keys.. and you probably should remove them.
Can you attach a screen shot of your complete model ? and if you can of your script ?
Hi Youssef
Thank you for look into my question. Enclosed is my QVW.
Paul
Try this
Rename Currency field from WhatifDimension13 table
Rename GROUP_CLASS field from sales_G table
Rename date field from Supplier table
Rename GROUP_CLASS field from sales table
Hi P M
I have rename those field , and now all the $Syn key missing now. All the report still able to working fine. Thank a lot.
But then i still have 2 more Syn key.
Can you share with me whcih field name from which table i need to rename ?
Paul Yeo
Hi PM
Enclosed my latest QVW
for first Syn key try this
IntervalMatch:
INTERVALMATCH ([Reporting Code]) LOAD DISTINCT
ExecPLStart as YourFieldName,
ExecPLEnd as YourFieldName1
RESIDENT ExecProfitLoss ;
and second syn
Rename SOURCE or date field from GL_TABLE table as per your requirement
Hi PM
Thank you very much , After rename Intermatch table , now not more $Syn Key.
Paul
Please close this thread with marking helpful or correct. if you get answer.
Hi PM
I notice that after I remove the $Syn key by rename the field name for those field you recommend , after I reload I notice that it does not affect my report. Any reasons why ?
Paul Yeo
DIrector
TDS Technology (S) P/L
Whatsapp +65 9326 1804
www.tdstech.com<http://www.tdstech.com>