Viewing 15 posts - 1,471 through 1,485 (of 1,839 total)
Will look to provide ore MDX later today but in te meantime, you can use the SQRT function "natively" within MDX. If you open BOL and use the index, type...
April 28, 2005 at 5:04 pm
Depending on whether you can change your user environment, this might not help, but have you considered/tried the Excel/OFfice Accelerator for OLAP? It basically gives you more powerful report building...
April 28, 2005 at 12:58 am
it depends a little on your environment, but if you're *intranet* only then you could try just using the Office webcomponents (http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=38be67a5-2056-46a1-84b1-337ffb549c5c 
. I...
April 28, 2005 at 12:54 am
Apologies if you've already stated or checked it, but are your dims marked as 'changing'?
April 28, 2005 at 12:50 am
Mmmm, beer....
Can you dumb it down a little for me? One thing you haven't given is the measures within your cube.
Assuming (always dangerous) that you have:
1. Total Population size (int?)
2. ...
April 28, 2005 at 12:48 am
this is probably not the fastest way, but on your Dev box, open report manager, go to the properties of a report, click the 'Edit' hyperlink, this should allow you...
April 26, 2005 at 5:15 pm
Quick note on your original post, after you finish designing your report use VS to open the rdl and do a search (either for the DS name or for the element...
April 21, 2005 at 6:14 am
If you have an MSDN subscription you can download it, otherwise you contact your local MSft software supplier (be it microsoft or a reseller or distributor). If you're still in...
April 21, 2005 at 1:17 am
based on seeing spaces be replaced with %20 you could try replacing your ampersands with %26 , this may work?
April 20, 2005 at 5:57 pm
Harry, are you asking leading questions?![]()
The repository is where the meta-data about your AS objects resides, so yeah, it's somewhat important if you want...
April 20, 2005 at 8:02 am
What Phil means is 'point and click' here http://www.microsoft.com/sql/reporting/productinfo/features.asp to see that other than scalability and security extensions, the only thing knobled is data-driven...
April 20, 2005 at 7:52 am
No prob.
If you have an 'All' member in a dim you shouldn't need to do the calculated member (ie use the SUM), you can just use the total in...
April 20, 2005 at 7:44 am
This is one option
WITH
MEMBER [Product].[All Products].[All] AS '[Product].[All Products].[Drink] + [Product].[All Products].[Food]'
MEMBER [Time].[All] AS '[Time].[1997] + [Time].[1998]'
SELECT
{[Product].[All Products].[Drink], [Product].[All Products].[Food], [Product].[All Products].[All]} ON 0,
{[Time].[1997], [Time].[1998], [Time].[All]} ON 1
FROM
[Sales]
WHERE
[Measures].[Store Sales]
April 20, 2005 at 4:53 am
I reckon you could still embed them and then just reference them as appropriate but forgetting that, if you clickn drag an image control onto a report, you'll get a...
April 19, 2005 at 12:40 am
you could try using a data-driven subscription, but this seems like a long way around to do what you want.
April 18, 2005 at 5:19 pm
Viewing 15 posts - 1,471 through 1,485 (of 1,839 total)