owc programming

[michael vardinghus]

im new to this but worked olap tools a lot.

if i want to try to add a calculated field to an owc how do i go about it ?
do i create a data acess page in Access ?

http://msdn2.microsoft.com/en-us/library/aa155706(office.10).aspx

from this article i want to try this

Dim ttl
With ptable.ActiveView
Set ttl = .AddCalculatedTotal("YTD Sales", _
"YTD Sales", "Sum(YTD(),[Measures].[Store Sales])")
.DataAxis.InsertTotal ttl
End With

because this will cover a problem i have in a business case about adding
calculated fields to current pivottable layout.

But how do i make code work on data access page - dont know where to begin.

 

[jam96-BuffaloJoe]

Is there a reason why you do not add this calculated field in the Analysis
Services Manager?

Then the OWC will just see it as part of the Cube.

 

[michael vardinghus]

hi

that is what i normally do in bi projects - however this time we have built
a budgeting application and i would like to put
in features in this application to show different results on the fly based
on user choises.

Is there a reason why you do not add this calculated field in the Analysis
Services Manager?

Then the OWC will just see it as part of the Cube.

im new to this but worked olap tools a lot.

if i want to try to add a calculated field to an owc how do i go about it
?
do i create a data acess page in Access ?

http://msdn2.microsoft.com/en-us/library/aa155706(office.10).aspx

from this article i want to try this

Dim ttl
With ptable.ActiveView
Set ttl = .AddCalculatedTotal("YTD Sales", _
"YTD Sales", "Sum(YTD(),[Measures].[Store Sales])")
.DataAxis.InsertTotal ttl
End With

because this will cover a problem i have in a business case about adding
calculated fields to current pivottable layout.

But how do i make code work on data access page - dont know where to
begin.