Action in AS 2005

Hello,
Which is the utility of the mitre "Action" in Analysis Services 2005 ?
Thank you for your help!
Nico
You may place an action on dimension members and levels(and other things)...
( You may do this in SQL 2000 as well.)
The action occurs when a user selects, or right clicks on the member or
level ( depending on the support from the front end client which is being
using.)
SQL 2k actions include the following
Select the type of action. The following table summarizes the available
types.
Type Description
Command Line Executes a command at the command prompt in Microsoft
Windows NT 4.0 or Windows 2000
Statement Executes an OLE DB command
HTML Executes an HTML script in an Internet browser
URL Displays a variable page in an Internet browser
Data set Retrieves a dataset
Rowset Retrieves a rowset
Proprietary Performs an operation using an interface different from
those listed earlier in this table
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"pralnico" <pralnico@.discussions.microsoft.com> wrote in message
news:2C1C2836-90F7-44AF-AD83-B24FC9B88146@.microsoft.com...
> Hello,
> Which is the utility of the mitre "Action" in Analysis Services 2005 ?
> Thank you for your help!
> Nico

Action in AS 2005

Hello,
Which is the utility of the mitre "Action" in Analysis Services 2005 ?
Thank you for your help!
NicoYou may place an action on dimension members and levels(and other things)...
( You may do this in SQL 2000 as well.)
The action occurs when a user selects, or right clicks on the member or
level ( depending on the support from the front end client which is being
using.)
SQL 2k actions include the following
Select the type of action. The following table summarizes the available
types.
Type Description
Command Line Executes a command at the command prompt in Microsoft
Windows NT 4.0 or Windows 2000
Statement Executes an OLE DB command
HTML Executes an HTML script in an Internet browser
URL Displays a variable page in an Internet browser
Data set Retrieves a dataset
Rowset Retrieves a rowset
Proprietary Performs an operation using an interface different from
those listed earlier in this table
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"pralnico" <pralnico@.discussions.microsoft.com> wrote in message
news:2C1C2836-90F7-44AF-AD83-B24FC9B88146@.microsoft.com...
> Hello,
> Which is the utility of the mitre "Action" in Analysis Services 2005 ?
> Thank you for your help!
> Nico

Action in AS 2005

Hello,
Which is the utility of the mitre "Action" in Analysis Services 2005 ?
Thank you for your help!
NicoYou may place an action on dimension members and levels(and other things)...
( You may do this in SQL 2000 as well.)
The action occurs when a user selects, or right clicks on the member or
level ( depending on the support from the front end client which is being
using.)
SQL 2k actions include the following
Select the type of action. The following table summarizes the available
types.
Type Description
Command Line Executes a command at the command prompt in Microsoft®
Windows NT® 4.0 or Windows® 2000
Statement Executes an OLE DB command
HTML Executes an HTML script in an Internet browser
URL Displays a variable page in an Internet browser
Data set Retrieves a dataset
Rowset Retrieves a rowset
Proprietary Performs an operation using an interface different from
those listed earlier in this table
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"pralnico" <pralnico@.discussions.microsoft.com> wrote in message
news:2C1C2836-90F7-44AF-AD83-B24FC9B88146@.microsoft.com...
> Hello,
> Which is the utility of the mitre "Action" in Analysis Services 2005 ?
> Thank you for your help!
> Nico

Accumulated values in analysis services

Hello,

I'm making a report where I have a matrix showing the weeks of a month in the columns and certain data. The user selects a month and I use it as a parameter to show all the calculations from a cube. I already have all the data needed for the matrix, the problem is that I need an accumulated value in the last row that sums the first week's accumulated value and the second week's value and so on (the month can have 4 or 5 weeks). The first week's accumulated value is the data itself since there is no previous value.

week1

week2

week3

....

data

x1

x2

x3

...

accumulated value

x1

x1+x2

x1+x2+x3

...

I don't know if I can do this from the cube using a mesure or something(i think it would be easier to have all the calculations in the cube),or if it has to be done from the matrix in the report.

I would appreciate all help you can give me. Thanks in advance.

Assuming that you have a hierarchy with something like Year - Month - Week, you should be able to create a calculated "MonthToDate" figure using the PeriodsToDate function.

eg.

CREATE MEMBER Measures.MonthToDate AS SUM(PeriodsToDate([Time].[Year-Month-Week].[Month],[Time].[Year-Month-Week].CurrentMember),Measures.[data])

|||

Hello Darren!,

Thanks for your reply!, that is what I wanted to do :)

Accessing SQL Server Analysis Services through something other than Windows Based Authentication

Hi,

My company has developed several Analysis Services cubes for a client. They also developed an application for them to read the cubes. However, the problem comes from the fact that these cubes have to be read by anyone that accesses them, not just people belonging to the domain in which the server resides.

Now, my question is, how can they make the app so that anyone can access the cubes from anywhere, but by bypassing the Windows Authentication Procedure? This app is web-based.

I know you cannot use SQL Based authentication on Analysis Services. Is there a way I can set up IIS to maybe use the IUSR_<username> user for authentication? Maybe by adding the IUSR_<username> to the list of administrators?

Thanks,
If you set up HTTP authentication you can specify a username and password on the connection string. AS 2005 also supports allowing anonymous connections. I would not add the IUSR account to the administrators role, they only need to be added to a standard role that has rights to read the cube(s).