I would like to define an advanced filter within my pivot table that allows me to look at diagnosis codes, or at procedure codes - but I do not want to hard code values within the pivot table definition (get the %OR defined).

I would like to be able to allow my dashboard user to chose what specific diagnosis codes or procedure codes they are interested in. So for example one user may want to look for # of patients with cancer dx or patients who have had a radiation procedure.

How can I accomplish this OR feature using dashboard filters?

0 2
0 380

Hi

I have a pvot table defined. that generates a set of data. I want. to. execute the pivot table programatically which I believe involves using %DeepSee.ResultSet. Does someone have an example showing how to apply filters to the results?

For. example

[DateTime of Filing].[Date].[Date Filed Year] = &[2023]

Thanks

0 2
0 190

I built a dashboard to show hourly instrument capacities based on a term list. The term list consists of the TestInstrumentID and the number of tests that instrument can perform in 1 hour. The calculation works correctly and the data is accurate but periodically if you go to check the dashboard the percentages all get changed to 100% across every hour. If you check it later or add an additional site to the filter then the percentages correct themselves. I don't know what's causing this or how to troubleshoot it because it does calculate correctly but is not consistent.

0 6
0 179

How can I create a calculated member in Analyzer using MDX for the following logic?

WHEN 'F' THEN 'FEMALE'
WHEN 'Female' THEN 'FEMALE'
WHEN 'M' THEN 'MALE'
WHEN 'Male' THEN 'MALE'
WHEN 'U' THEN UNDIFFERENTIATED'
WHEN 'UN' THEN UNDIFFERENTIATED'
WHEN 'Undifferentiated' THEN UNDIFFERENTIATED'
ELSE 'OTHER'
END

0 2
0 189

Hello everyone,

I am new to Deepsee (BI intelligence) concepts in IRIS. I am looking for a solution of below question

Question: We have a server where we are currently storing archive PDF reports of our application.

We want to add and view these archive reports (PDF format only) in dashboards. Is there any way we can do this? Or any article which can help us performing this task.

Thanks in advance!!

0 1
0 80

Hi Community,

I have below scenario

We have IRIS BI Reports in my application. Now these reports currently being acessed by users through dashboard url's.

I want to create a automated utility (background cache system task) which run these bi reports and export them to a specific path.

I am looking for a system method through which we can open these dashboard url's through code and export the excel report to a speciific path.

Thanks in advance.

0 1
0 50

Hi Community,

I have below scenario

We have IRIS BI Reports in my application. I want to create a automated backend utility (similar to background cache system task) which run these bi reports and export them to PDF at a specific path. In dashboard we have defined <property name="print">1</property> which allows report export to PDF.

Now I want to debug the code (line by line) from dashboard to %DeepSee.UI.MDXPDF.cls but I am not sure is this possible or not.

Please suggest. Thanks in advance!

0 1
0 68