I'm using the HierCube .net OLAP component from rainbowsoft
(http://www.rbwsoft.com/) in a vb winform application (vs2003). The data
source is an MS Access 2000 table; the data adapter is of the oledb
type; and the sql string has two parameters ala =?

At runtime the app provides values for the params like so:

oledaPivotData.SelectCommand.Parameters("Conversion").Value =
cboConversion.SelectedValue
oledaPivotData.SelectCommand.Parameters("Year").Value =
cboYear.SelectedValue

The cube works fine. However the cube control won't let me access the
Dimension Mapping facility, it complains that "Parameter ?_1 has no
default value". I'm not sure how to solve this. I've written to the
control developers, but they can be slow to respond...and this issue
seems to be more generic than specific to this control. I've not been
able to find a discussion here that deals with my situation, most other
cases are using SPs.

Re: Parameter ?_1 has no default value by kiln

kiln
Thu Mar 10 09:55:23 CST 2005

Right after posting this I found the manner in which param default
values are set, via the params collection in properties. That solved it.

In article <MPG.1c9a0c9a924695ec989935@msnews.microsoft.com>,
kiln@brick-like.com says...
> I'm using the HierCube .net OLAP component from rainbowsoft
> (http://www.rbwsoft.com/) in a vb winform application (vs2003). The data
> source is an MS Access 2000 table; the data adapter is of the oledb
> type; and the sql string has two parameters ala =?
>
> At runtime the app provides values for the params like so:
>
> oledaPivotData.SelectCommand.Parameters("Conversion").Value =
> cboConversion.SelectedValue
> oledaPivotData.SelectCommand.Parameters("Year").Value =
> cboYear.SelectedValue
>
> The cube works fine. However the cube control won't let me access the
> Dimension Mapping facility, it complains that "Parameter ?_1 has no
> default value". I'm not sure how to solve this. I've written to the
> control developers, but they can be slow to respond...and this issue
> seems to be more generic than specific to this control. I've not been
> able to find a discussion here that deals with my situation, most other
> cases are using SPs.
>