Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an application which is now not responding to filter selections. It could be a breakdown in my model. Please see attached QV App and assist.
Regards.
Ok, fair enough. Your data model does not relate the dimension DimProduct correctly to Product. Add fields from both tables in one table box object and include the Check and NDANumber fields. You'll see that the table box won't contain any rows where all the fields have values. There are no Check values in the DimProduct table that have a matching NDANumber value in the Product table. And that's not suprising since you use two different ways to calculate the Check values:
FDAPlatformsfGrowth:
AutoNumberHash128(ATCLevelOneCode&ATCLevelTwoCode&ATCLevelThreeCode) as Check;
DimProduct:
AutoNumberHash128(ATCLevelOneCode&ATCLevelTwoCode&ATCLevelThreeCode&ATCLevelFourCode) as Check
Please don't clutter this site with duplicate discussions: Application not responding to a "From: "To:" date selections
Gysbert
Your posting refers. You might think these are duplicate discussions, these are not, i have posted them differently as one part of the application is relating to date selections and the other to non-date selections.
Ok, fair enough. Your data model does not relate the dimension DimProduct correctly to Product. Add fields from both tables in one table box object and include the Check and NDANumber fields. You'll see that the table box won't contain any rows where all the fields have values. There are no Check values in the DimProduct table that have a matching NDANumber value in the Product table. And that's not suprising since you use two different ways to calculate the Check values:
FDAPlatformsfGrowth:
AutoNumberHash128(ATCLevelOneCode&ATCLevelTwoCode&ATCLevelThreeCode) as Check;
DimProduct:
AutoNumberHash128(ATCLevelOneCode&ATCLevelTwoCode&ATCLevelThreeCode&ATCLevelFourCode) as Check
Many thanks Gysbert, i was failing to locate this mistake