OWC 11 Pivot table.

[bluewind44]

Hello, All.

I' m new to use OWC 11 Pivot table and now I try to use OWC 11 Pivot
table to my ASP.NET project. Before I start the project, I have to
figure out whether I can use OWC 11 Pivot table or not.

Here is my question, can I use a normal sql query as a datasource of
the OWC Pivot table? I mean, Can I use a sql query like 'SELECT A, B, C
FROM VI100010 WHERE SITEID = 44' for a datasorce and set A, B, C as a
item of the pivot table? and If so, how?


Thank you in advance.

 

[Alvin Bruney]

The backend for a pivot table is an OLAP cube. Querying the OLAP cube is
done thru an MDX syntax very similar to SQL but more powerful because of the
need to service a different architecture. MDX is not terrible difficult to
learn if you have a good grasp of SQL however, you will need to pull data
out of your SQL table and store it in a cube. This is easily accomplished
thru wizards, but you will need to beef up your understanding of OLAP before
you take the plunge.

--

________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Professional VSTO.NET - Wrox/Wiley 2006

 

[bluewind44]

Thanks for reply.

so you mean I have to use OLAP cube for using OWC pivot table, right?

If you have a time, plz suggest me a way to devlop the OWC pivot table.

Here is my situation.
I have a ASP.NET project that is used by several companies.
All of my tables of databases have a column named SITEID (INT) ,
and it is the key for dividing one company's data from others'.

Now I try to use OWC pivot table and chart for user-defined reports.
I want users can set up reports freely, which means user can make
'where' clauses, and can set the row axis, col axis, data axis
from several tables.
All the tables should join one table that used for user defined column,
so the normal sql query for the reports should include JOIN.
ex) 'SELECT A, B, C FROM TB100010 A LEFT JOIN TB950040 B ON
B.TABLENAME = 'TB100010' WHERE SITEID = 44'

I don't want users can see the SITEID column on web pages, but should
include the SITEID-where clauses.

Can I use the OWC pivot table for this situation?

 

[Alvin Bruney]

Yes, the pivot table is suitable. However, you will need to bring yourself
up to speed on pivot table and olap technology BEFORE you start.

--

________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Professional VSTO.NET - Wrox/Wiley 2006

 

[bluewind44]

Thanks really.

Actually I have a progress with the pivot table, and there is a another
question far from the topic before.

It's a question about the connection string.
I don't want the connection string is on the html source, but I can't
see the way to do it.

Now, I try to save the xmlData to DB on the setup page of the reports,
and call it on the page that have pivot table by webservice.

Is there a solution to hide the connection string?
Or is there a way to set the real-data for the pivot table, instead the
architecture-data like xmlData?