Luc
(Luc)
March 8, 2022, 12:15pm
1
Hi
Atlas => Data Sources shows results for dashboard, data density, person and visit. There are “No data” for condition_occurrence.
When I use the url http://localhost:8080/WebAPI/cdmresults/cdm_v1/person a “json-anwer” is seen. With http://localhost:8080/WebAPI/cdmresults/cdm_v1/condition the result is []
Where should I look?
Thanks in advance for your feedback.
How long ago did you run Achilles? Sometimes it takes longer for some of the dashboards & underlying JSON to populate than others.
After Achilles successfully completed, for me it still took some time for the dashboard to populate with the results from the Achilles run.
Did you check to make sure there are results for the condition occurrence analyses in achilles_results
?
Luc
(Luc)
March 8, 2022, 4:43pm
5
In the table achilles_results there are 6476 records for analysis_id 401 e.g. (Analysis 401 (Number of condition occurrence records, by condition_concept_id)
Did you run the conceptHierarchy script when setting up your WebApi results schema?
Although I can’t find this requirement in the documentation, it seems that it is used to build the Condition treemap .
Luc
(Luc)
March 10, 2022, 9:31am
7
It was run but can I check somewhere that this part was run succesfully?
Try to run this query on your results schema. If this returns results, the issue is not with Achilles or the results schema setup.
SELECT
concept_hierarchy.concept_id,
CONCAT(
isNull(concept_hierarchy.level4_concept_name, 'NA'), '||',
isNull(concept_hierarchy.level3_concept_name, 'NA'), '||',
isNull(concept_hierarchy.level2_concept_name, 'NA'), '||',
isNull(concept_hierarchy.level2_concept_name, 'NA'), '||',
isNull(concept_hierarchy.concept_name, 'NA')
) AS concept_path,
ar1.count_value AS num_persons,
round(1.0 * ar1.count_value / denom.count_value, 5) AS percent_persons,
round(1.0 * ar2.count_value / ar1.count_value, 5) AS records_per_person
FROM (SELECT *
FROM @results_database_schema.achilles_results WHERE analysis_id = 400) ar1
INNER JOIN
(SELECT *
FROM @results_database_schema.achilles_results WHERE analysis_id = 401) ar2
ON ar1.stratum_1 = ar2.stratum_1
INNER JOIN
@results_database_schema.concept_hierarchy concept_hierarchy
This file has been truncated. show original