Is there a way to pull a scalar value from a cube? Is this common?
Can I do it using .NET? Does anybody have a sample query that I can
test against the Adventure Works example.

Thanks,

leo (AT) junquera (DOT) com wrote:
SELECT FROM [Cube Name] WHERE ([Measures].DefaultMember, ... )

will give you a scalar value.

Yes, you can do it from .NET
How are you connecting to the cube? In your case I'd think the MSOLAP.2
OLEDB provider will be the simplest option.

You can use it with an OLEDB Command ExecuteScalar, just like you would
with a SQL database

-- a --
PS: No, it's not unheard of to want a single value from a cube ... as
long as that's not all that the cube's for

Thank you. Currently we have function calls into the database that can
be used in Excel cells. The calls for aggregate transactional data are
two slow so the idea of "pre-calculated" values made sense. That lead
me to OLAP and Analysis Services. This would allow users to also
larger sets of data via pivot tables which might end up being more
valuable to them. The individual calls allow them the flexibility to
create models and ad hoc requests so I still want to maintain that
functionality. Just give them a richer set of calls. This is all a
little new to me coming from a OLTP background.

Thanks for your help.

In article <1151494969.124424.252890 (AT) 75g2000cwc (DOT) googlegroups.com>,
leo (AT) junquera (DOT) com says...
You might be interested in looking into the Excel Addin for Analysis
Services. It has some functions that allow you to get a single scalar
value.

http://www.microsoft.com/downloads/d...DAE82128-9F21-
475D-88A4-4B6E6C069FF0&displaylang=en

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell