Hi

try this:

[font="Tahoma"]

WITH MEMBER [measures].[test]

AS SUM ( Existing ([Deals BOID].[Deal Rate].[Deal Rate].members )

, strtovalue([Deals BOID].[Deal Rate].CurrentMember.properties("Key"))

//, Cint ( [Deals BOID].[Deal Rate].CurrentMember.membervalue )...

Hi,

Pointing you into the right direction. You have to think in Sets (Set Theory). You need to OR the sets.. Using the sample below..

set 1 = { {all fruit members...

Use the built-in User!UserID field and assign this to a parameter of the dataset!!!

pe @user-id = User!UserID

however in MDX you need to map the User!userID to a MDX...

Indeed, your MDX just does what you asked it do do.

Because you created 2 seperate dimensions (date and time) with no relationship (parent child hierarchy). The MDX creates first a...

Hi

Try this

WITH MEMBER

[Measures].[WeekIDNo] as [Date].[Week ID].CURRENTMEMBER.PROPERTIES('Member_Value' )

--Assuming WEEK ID increases..

SELECT NON EMPTY { [Measures].[Record Count - Dim Employee AS] } ON COLUMNS,

TOPCOUNT( { ([Date].[H_CalendarWeekHierarchy].[Calender Week].ALLMEMBERS * [Date].[Week ID].[Week ID].MEMBERS *...

Hi Doodles

Indeed you need 2 report-parameters.. However you need to override automatic MDX creation by SSRS.

SSRS Subcubes, when you use two parameters having the same dimensionallity you end up with...

Hi

What do you mean, fact table does not contain data.. The error means when parsing the fact-table no corresponding PK was found in the dimension for the given FK in...

Hi,

I suggest reading various articles, technet and MSDN, pressing F1 in BIDS helps too pointing you into the right direction.

When to use is defined by requirement..

Sometimes a user wants to...

Hi

Lets suggest you want to display the Dimension (Custom member) properties, add

them into the Dimension Properties clause in your MDX.:ermm:

If you mean creating the dimension attributes within BIDS, you can...

Hi ,

I suggest you read the ASSP documentation carefully on the codeplex site.

The SQLQuery is placed in a different assembly. That has been done for security reasons.

If you want to...

Hi Cindy,

Unfortunately, no there is no mdx you can use from the out-of-the-box SSAS to get a list of users and their roles.

However there is an SSAS codeplex project that...

What do you want the easy, the automatic or the hard way..

One the easy;

Save the partition designs in SMSS into a XMLA file. Alter the XMLA by changing the partition...

Value Description

Dataset

Returns a Multidimensional Expressions (MDX) statement, representing a multidimensional dataset, to be run and displayed by the client application.

Proprietary

Returns a proprietary string that...

Hi Michael,

I guess the Oracle type you are using Varchar2() Varchar2 is limited by default to 4Kbyte characters.

I just see one workaround: Convert the string to the...

Hi

Read this http://en.wikipedia.org/wiki/Data_warehouse#Normalized_versus_dimensional_approach_for_storage_of_data

Before deciding to Normalize to Sixth Normal Form:-)

Regards Kees