How to control owc

[Johan]

I am looking for methods to control the presentation of data in a owc
connected to MS Analysis Service cubes:
Can I somehow control the way owc present dimensions. So users only see
combinations that I control. I have considered using AS security!
Can I do MDX to do the trick or events handling ?

 

[Alvin Bruney - MVP ASP.NET]

mdx is your best bet, if you know the language you can control exactly what
data is pulled back from the cube which affects what shows up on the client

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET

 

[Johan]

Thanks.

But can I use MDX "inside" or "with" the owc? I am a bit uncertain on these
matters. But I like the potential I see in the owc. And before I go to
programmers I need to be more clarified.

Regards
Johan

mdx is your best bet, if you know the language you can control exactly what
data is pulled back from the cube which affects what shows up on the client

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET
--------------------------------------------------------------------------------------------------------

I am looking for methods to control the presentation of data in a owc
connected to MS Analysis Service cubes:
Can I somehow control the way owc present dimensions. So users only see
combinations that I control. I have considered using AS security!
Can I do MDX to do the trick or events handling ?

 

[Alvin Bruney - MVP ASP.NET]

The pivot table can fire queries. These queries may be either sql semantic
or MDX.

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET
--------------------------------------------------------------------------------------------------------

Thanks.

But can I use MDX "inside" or "with" the owc? I am a bit uncertain on
these
matters. But I like the potential I see in the owc. And before I go to
programmers I need to be more clarified.

Regards
Johan

mdx is your best bet, if you know the language you can control exactly
what
data is pulled back from the cube which affects what shows up on the
client

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET
--------------------------------------------------------------------------------------------------------

I am looking for methods to control the presentation of data in a owc
connected to MS Analysis Service cubes:
Can I somehow control the way owc present dimensions. So users only see
combinations that I control. I have considered using AS security!
Can I do MDX to do the trick or events handling ?

 

[Johan]

Hi Alvin

Thanx for the response....

In my opinion there seems to be difference between excel olap component and
the owc web component.

From the owc web component I actually succeeded in using MDX in the
commandtext property which resulted in an automatically designed pivottable.
Havent yet managed to do this as a result of coding but based on your opinion
it sounds like that is possible.

When you say that it is supported do you know if it is supported in the
excel olap component as well?

Excel had some features that we thought would be nice when using writeback -
however if we were to use OWC for writeback how would the user be able to
enter data into cells ? We have never tried this ?

In excel we could activate a command to allow editing in cells and we
believe this is possible to do in the OWC component as well but what about

a) do you move from cell to cell when using the arrow keys
b) can you copy/paste between cells
c) can you use one cell value as basis for another and multiply this with a
factor

The pivot table can fire queries. These queries may be either sql semantic
or MDX.

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET
--------------------------------------------------------------------------------------------------------

Thanks.

But can I use MDX "inside" or "with" the owc? I am a bit uncertain on
these
matters. But I like the potential I see in the owc. And before I go to
programmers I need to be more clarified.

Regards
Johan

mdx is your best bet, if you know the language you can control exactly
what
data is pulled back from the cube which affects what shows up on the
client

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET
--------------------------------------------------------------------------------------------------------




I am looking for methods to control the presentation of data in a owc
connected to MS Analysis Service cubes:
Can I somehow control the way owc present dimensions. So users only see
combinations that I control. I have considered using AS security!
Can I do MDX to do the trick or events handling ?

 

[Alvin Bruney - MVP ASP.NET]

OWC is Excel on steroids. Everything Excel can do, OWC excel can do and then
some. However, you have licensing issues to figure in to the equation for
the part where users enter data into the spreadsheet.

To write back data to the database from OWC excel is trivial - there is an
example or two in the black book on this.

From the owc web component I actually succeeded in using MDX in the
commandtext property which resulted in an automatically designed
pivottable.

Yup, that was what i was talking about.

enter data into cells ? We have never tried this ?

The excel spreadsheet appears in the browser. Users may or may not be able
to enter data into the sheet (dependent on licensing rules and regulations),
all you need do is write the code to move the data from the spreadsheet to
the database. 10 or 12 lines of code perhaps???

a) do you move from cell to cell when using the arrow keys
b) can you copy/paste between cells
c) can you use one cell value as basis for another and multiply this with
a
factor

It's the same excel, no different from desktop excel. Use the same keys,
treat it like you would desk top excel. The most difficult part of your task
is figuring out the licensing regulations for your particular scenario, the
black book has more details on all the licensing considerations.

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET
--------------------------------------------------------------------------------------------------------

Hi Alvin

Thanx for the response....

In my opinion there seems to be difference between excel olap component
and
the owc web component.

From the owc web component I actually succeeded in using MDX in the
commandtext property which resulted in an automatically designed
pivottable.
Havent yet managed to do this as a result of coding but based on your
opinion
it sounds like that is possible.

When you say that it is supported do you know if it is supported in the
excel olap component as well?

Excel had some features that we thought would be nice when using
writeback -
however if we were to use OWC for writeback how would the user be able to
enter data into cells ? We have never tried this ?

In excel we could activate a command to allow editing in cells and we
believe this is possible to do in the OWC component as well but what about

a) do you move from cell to cell when using the arrow keys
b) can you copy/paste between cells
c) can you use one cell value as basis for another and multiply this with
a
factor

The pivot table can fire queries. These queries may be either sql
semantic
or MDX.

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET
--------------------------------------------------------------------------------------------------------

Thanks.

But can I use MDX "inside" or "with" the owc? I am a bit uncertain on
these
matters. But I like the potential I see in the owc. And before I go to
programmers I need to be more clarified.

Regards
Johan


:

mdx is your best bet, if you know the language you can control exactly
what
data is pulled back from the cube which affects what shows up on the
client

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET
--------------------------------------------------------------------------------------------------------




I am looking for methods to control the presentation of data in a owc
connected to MS Analysis Service cubes:
Can I somehow control the way owc present dimensions. So users only
see
combinations that I control. I have considered using AS security!
Can I do MDX to do the trick or events handling ?

 

[Johan]

Thanks again.
And your answer will be the same if I tell you that I am thinking on a owc
pivottable connected to an olap cube in which I would like to write back?
just to clear my mind!

regards
Johan

OWC is Excel on steroids. Everything Excel can do, OWC excel can do and then
some. However, you have licensing issues to figure in to the equation for
the part where users enter data into the spreadsheet.

To write back data to the database from OWC excel is trivial - there is an
example or two in the black book on this.

From the owc web component I actually succeeded in using MDX in the
commandtext property which resulted in an automatically designed
pivottable.

Yup, that was what i was talking about.

enter data into cells ? We have never tried this ?

The excel spreadsheet appears in the browser. Users may or may not be able
to enter data into the sheet (dependent on licensing rules and regulations),
all you need do is write the code to move the data from the spreadsheet to
the database. 10 or 12 lines of code perhaps???

a) do you move from cell to cell when using the arrow keys
b) can you copy/paste between cells
c) can you use one cell value as basis for another and multiply this with
a
factor

It's the same excel, no different from desktop excel. Use the same keys,
treat it like you would desk top excel. The most difficult part of your task
is figuring out the licensing regulations for your particular scenario, the
black book has more details on all the licensing considerations.

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET
--------------------------------------------------------------------------------------------------------

Hi Alvin

Thanx for the response....

In my opinion there seems to be difference between excel olap component
and
the owc web component.

From the owc web component I actually succeeded in using MDX in the
commandtext property which resulted in an automatically designed
pivottable.
Havent yet managed to do this as a result of coding but based on your
opinion
it sounds like that is possible.

When you say that it is supported do you know if it is supported in the
excel olap component as well?

Excel had some features that we thought would be nice when using
writeback -
however if we were to use OWC for writeback how would the user be able to
enter data into cells ? We have never tried this ?

In excel we could activate a command to allow editing in cells and we
believe this is possible to do in the OWC component as well but what about

a) do you move from cell to cell when using the arrow keys
b) can you copy/paste between cells
c) can you use one cell value as basis for another and multiply this with
a
factor

The pivot table can fire queries. These queries may be either sql
semantic
or MDX.

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET
--------------------------------------------------------------------------------------------------------




Thanks.

But can I use MDX "inside" or "with" the owc? I am a bit uncertain on
these
matters. But I like the potential I see in the owc. And before I go to
programmers I need to be more clarified.

Regards
Johan


:

mdx is your best bet, if you know the language you can control exactly
what
data is pulled back from the cube which affects what shows up on the
client

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET
--------------------------------------------------------------------------------------------------------




I am looking for methods to control the presentation of data in a owc
connected to MS Analysis Service cubes:
Can I somehow control the way owc present dimensions. So users only
see
combinations that I control. I have considered using AS security!
Can I do MDX to do the trick or events handling ?

 

[Alvin Bruney - MVP ASP.NET]

yup

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET
--------------------------------------------------------------------------------------------------------

Thanks again.
And your answer will be the same if I tell you that I am thinking on a owc
pivottable connected to an olap cube in which I would like to write back?
just to clear my mind!

regards
Johan

OWC is Excel on steroids. Everything Excel can do, OWC excel can do and
then
some. However, you have licensing issues to figure in to the equation for
the part where users enter data into the spreadsheet.

To write back data to the database from OWC excel is trivial - there is
an
example or two in the black book on this.

From the owc web component I actually succeeded in using MDX in the
commandtext property which resulted in an automatically designed
pivottable.

Yup, that was what i was talking about.

enter data into cells ? We have never tried this ?

The excel spreadsheet appears in the browser. Users may or may not be
able
to enter data into the sheet (dependent on licensing rules and
regulations),
all you need do is write the code to move the data from the spreadsheet
to
the database. 10 or 12 lines of code perhaps???

a) do you move from cell to cell when using the arrow keys
b) can you copy/paste between cells
c) can you use one cell value as basis for another and multiply this
with
a
factor

It's the same excel, no different from desktop excel. Use the same keys,
treat it like you would desk top excel. The most difficult part of your
task
is figuring out the licensing regulations for your particular scenario,
the
black book has more details on all the licensing considerations.

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET
--------------------------------------------------------------------------------------------------------

Hi Alvin

Thanx for the response....

In my opinion there seems to be difference between excel olap component
and
the owc web component.

From the owc web component I actually succeeded in using MDX in the
commandtext property which resulted in an automatically designed
pivottable.
Havent yet managed to do this as a result of coding but based on your
opinion
it sounds like that is possible.

When you say that it is supported do you know if it is supported in the
excel olap component as well?

Excel had some features that we thought would be nice when using
writeback -
however if we were to use OWC for writeback how would the user be able
to
enter data into cells ? We have never tried this ?

In excel we could activate a command to allow editing in cells and we
believe this is possible to do in the OWC component as well but what
about

a) do you move from cell to cell when using the arrow keys
b) can you copy/paste between cells
c) can you use one cell value as basis for another and multiply this
with
a
factor

:

The pivot table can fire queries. These queries may be either sql
semantic
or MDX.

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET
--------------------------------------------------------------------------------------------------------




Thanks.

But can I use MDX "inside" or "with" the owc? I am a bit uncertain
on
these
matters. But I like the potential I see in the owc. And before I go
to
programmers I need to be more clarified.

Regards
Johan


:

mdx is your best bet, if you know the language you can control
exactly
what
data is pulled back from the cube which affects what shows up on
the
client

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET
--------------------------------------------------------------------------------------------------------




I am looking for methods to control the presentation of data in a
owc
connected to MS Analysis Service cubes:
Can I somehow control the way owc present dimensions. So users
only
see
combinations that I control. I have considered using AS security!
Can I do MDX to do the trick or events handling ?

 

[Michael Vardinghus]

Thanx again

Can I enter data in any cells ? Even cells that are non leaf ... can I then
choose to allocate these using UPDATE CUBE...

regards
Johan

yup

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET
-------------------------------------------------------------------------- ------------------------------

Thanks again.
And your answer will be the same if I tell you that I am thinking on a owc
pivottable connected to an olap cube in which I would like to write back?
just to clear my mind!

regards
Johan

OWC is Excel on steroids. Everything Excel can do, OWC excel can do and
then
some. However, you have licensing issues to figure in to the equation for
the part where users enter data into the spreadsheet.

To write back data to the database from OWC excel is trivial - there is
an
example or two in the black book on this.
From the owc web component I actually succeeded in using MDX in the
commandtext property which resulted in an automatically designed
pivottable.
Yup, that was what i was talking about.

enter data into cells ? We have never tried this ?
The excel spreadsheet appears in the browser. Users may or may not be
able
to enter data into the sheet (dependent on licensing rules and
regulations),
all you need do is write the code to move the data from the spreadsheet
to
the database. 10 or 12 lines of code perhaps???

a) do you move from cell to cell when using the arrow keys
b) can you copy/paste between cells
c) can you use one cell value as basis for another and multiply this
with
a
factor
It's the same excel, no different from desktop excel. Use the same keys,
treat it like you would desk top excel. The most difficult part of your
task
is figuring out the licensing regulations for your particular scenario,
the
black book has more details on all the licensing considerations.

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET

------------------------------------------------------------------------- -------------------------------

Hi Alvin

Thanx for the response....

In my opinion there seems to be difference between excel olap component
and
the owc web component.

From the owc web component I actually succeeded in using MDX in the
commandtext property which resulted in an automatically designed
pivottable.
Havent yet managed to do this as a result of coding but based on your
opinion
it sounds like that is possible.

When you say that it is supported do you know if it is supported in the
excel olap component as well?

Excel had some features that we thought would be nice when using
writeback -
however if we were to use OWC for writeback how would the user be able
to
enter data into cells ? We have never tried this ?

In excel we could activate a command to allow editing in cells and we
believe this is possible to do in the OWC component as well but what
about

a) do you move from cell to cell when using the arrow keys
b) can you copy/paste between cells
c) can you use one cell value as basis for another and multiply this
with
a
factor

:

The pivot table can fire queries. These queries may be either sql
semantic
or MDX.

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET

------------------------------------------------------------------------- -------------------------------

Thanks.

But can I use MDX "inside" or "with" the owc? I am a bit uncertain
on
these
matters. But I like the potential I see in the owc. And before I go
to
programmers I need to be more clarified.

Regards
Johan


:

mdx is your best bet, if you know the language you can control
exactly
what
data is pulled back from the cube which affects what shows up on
the
client

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET

------------------------------------------------------------------------- -------------------------------

I am looking for methods to control the presentation of data in a
owc
connected to MS Analysis Service cubes:
Can I somehow control the way owc present dimensions. So users
only
see
combinations that I control. I have considered using AS security!
Can I do MDX to do the trick or events handling ?

 

[Igor]

I have the same problem. Did you figure out how to do that?

Igor

 

[Johan]

Igor

Sorry no. I haven't any concrete on it. Alvin B meant it was possible but I
guess he didn't really know.

regards
Johan

 

[Alvin Bruney - MVP ASP.NET]

I'm not that good on MDX expressions which is what you will need to
accomplish your task. I suppose you can figure it out - it's not that hard
to build the syntax. I simply don't have the time to poke around to find a
solution for you.

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET

 

[Johan]

Alvin. My apology. I didn't mean it that way.

I have colleauges that know mdx, so we can transfer data from OWC to
olapcubes. But how can I write-enable the OWC pivottable and can I do it with
excel copy cells (drag) functionality?

Johan

I'm not that good on MDX expressions which is what you will need to
accomplish your task. I suppose you can figure it out - it's not that hard
to build the syntax. I simply don't have the time to poke around to find a
solution for you.

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET
--------------------------------------------------------------------------------------------------------

Igor

Sorry no. I haven't any concrete on it. Alvin B meant it was possible but
I
guess he didn't really know.

regards
Johan

 

[Alvin Bruney - ASP.NET MVP]

That behavior is not supported.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

Alvin. My apology. I didn't mean it that way.

I have colleauges that know mdx, so we can transfer data from OWC to
olapcubes. But how can I write-enable the OWC pivottable and can I do it with
excel copy cells (drag) functionality?

Johan

I'm not that good on MDX expressions which is what you will need to
accomplish your task. I suppose you can figure it out - it's not that hard
to build the syntax. I simply don't have the time to poke around to find a
solution for you.

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET
-------------------------------------------------------------------------- ------------------------------

Igor

Sorry no. I haven't any concrete on it. Alvin B meant it was possible but
I
guess he didn't really know.

regards
Johan

:

I have the same problem. Did you figure out how to do that?

Igor


:

I am looking for methods to control the presentation of data in a owc
connected to MS Analysis Service cubes:
Can I somehow control the way owc present dimensions. So users only see
combinations that I control. I have considered using AS security!
Can I do MDX to do the trick or events handling ?

 

[Simon Masters]

I am using OWC 11 and MDAC 2.8, Excel 2003 (version 11.8033) SP2 connecting
to Analysis Services Cubes

I need to have limited interactivity e.g. Pick from Drop Down but no drag
and drop movement of the pivot fields in the publish web page

I have successfuly set the DragToPage, Darg to Row etc properties to False
in Excel and that works in the client application, but when published as
either a chart of pivot with interactivity I cannot get the Web page to "lock
down" pivot fields so they cannot be moved by the user.

Viewing the source HTML suggests that only some fields output the required
</NoDragToData> tags

ANYONE PLEASE HELP?