ReportPortal: Zero-footprint OLAP client for Microsoft Analysis Services

ReportPortal

All Forums

ReportPortal General Forum

Report Portal General Issues

dashboard filtering with SQL and OLAP

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:

UserName:

Password:

Anti-Spam Code:

Message:

* HTML is ON
* Forum Code is OFF

Smilies

[quote][i]Originally posted by admin[/i]
[br]It is not possible to create a filter that would filter OLAP and SQL report at the same time.

It is possible to create an OLAP report action to filter an SQL report.  In OLAP report design mode, add calculated members and select �Add  Action�.  Select the target SQL report.  Select the values you want to pass to the SQL filter.  The �Add Action� wizard will create MDX which you can modify.  Change target='_blank' to target='frm2'.  The number 2 means that the SQL report will be the second widget in dashboard.

It is also possible to create a link in SQL report to point to an OLAP report. The link target should be: target='frm1'.  The SQL would look something like:

<textarea style='width:100%; height: 120px;'>SELECT c.FirstName, c.LastName, c.Title, c.BirthDate, c.MaritalStatus, c.Gender, c.Phone,   '<a target=''frm1'' href=''../Proxy.aspx?reportId=1702&toolbar=0&filters=1&description=1&name=1&scroll=1&[Customer].[Commute Distance]=%5bCustomer%5d.%5bCommute+Distance%5d.%5b' + c.CommuteDistance + '%5d''>' + c.CommuteDistance + '</a>' as Commute, g.EnglishCountryRegionName as Country FROM DimCustomer c	INNER JOIN DimGeography g ON g.GeographyKey = c.GeographyKey WHERE g.EnglishCountryRegionName = '::1'

You can see an example here: http://www.reportportal.us. Go to: My Reports > Customer-Dashboard [/quote]

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
WildCard	Posted - 04/21/2016 : 08:05:23 Hi, in a dashboard is there any possibility to filter an SQL report with an OLAP filter or, vice versa, an OLAP report with an SQL filter?
2 L A T E S T R E P L I E S (Newest First)
WildCard	Posted - 04/22/2016 : 02:29:13 Thanks, works like a charm!
admin	Posted - 04/21/2016 : 23:58:28 It is not possible to create a filter that would filter OLAP and SQL report at the same time. It is possible to create an OLAP report action to filter an SQL report. In OLAP report design mode, add calculated members and select �Add Action�. Select the target SQL report. Select the values you want to pass to the SQL filter. The �Add Action� wizard will create MDX which you can modify. Change target='_blank' to target='frm2'. The number 2 means that the SQL report will be the second widget in dashboard. It is also possible to create a link in SQL report to point to an OLAP report. The link target should be: target='frm1'. The SQL would look something like: SELECT c.FirstName, c.LastName, c.Title, c.BirthDate, c.MaritalStatus, c.Gender, c.Phone, '<a target=''frm1'' href=''../Proxy.aspx?reportId=1702&toolbar=0&filters=1&description=1&name=1&scroll=1&[Customer].[Commute Distance]=%5bCustomer%5d.%5bCommute+Distance%5d.%5b' + c.CommuteDistance + '%5d''>' + c.CommuteDistance + '</a>' as Commute, g.EnglishCountryRegionName as Country FROM DimCustomer c INNER JOIN DimGeography g ON g.GeographyKey = c.GeographyKey WHERE g.EnglishCountryRegionName = '::1' You can see an example here: http://www.reportportal.us. Go to: My Reports > Customer-Dashboard

ReportPortal