I have a scenario like this:
WServer 2008, SQL Server 2005, MS Analysis Services (SSAS), ISS7, and OLAP CUBE.
I need to paste the OLAP result into a webpage on an existing site.
I don’t need any choice of measurement, no detail, no 3-dimensional measurement, just a passive result of a programmed MDX query.
The following is an example of the MDX query used: (sales statistics for the agent for the period)
SELECT NON EMPTY { [Measures].[Valore] } ON COLUMNS,
NON EMPTY { ([Prodotti].[Top Marca].[Top Marca].ALLMEMBERS * [Calendario].[Anno - Mese].[Mese].ALLMEMBERS * [Agenti].[Cod Agente].[Cod Agente].ALLMEMBERS ) }
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( { [Calendario].[Anno].&[2012] } ) ON COLUMNS
FROM ( SELECT ( { [Agenti].[Vw Agenti].&[005] } ) ON COLUMNS FROM [Vendite]))
CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS
Below is the easy result that I need to show on the website:
I tried using the Report Viewer, but it seems like I cannot because of this error:
Remote Report Processing requires Microsoft SQL Server 2008 Reporting Service or later
SQL Server 2008, .
- , JAVA , SQL Server -.
TSQL-, 1 ,
. , iPad, Mac, Windows, Linux,... HTML
, :
- (asp aspx) ( ) , ( HTML), , - ?
?
, !