The fuzzy logic tasks should be able to help you achieve your requirement.  Prob best to look over BOL and maybe the samples but from memory there is one that...

Not sure why it would be doing that but you could always try i) casting the data field to ensure it's the correct type [e.g. CInt(field) ]; or ii) possilby using...

right click the project within your BI Dev studio (in the solution explorer pane). Select properties. I think under the debug (there's not too many things to look...

Just out of interest, is this a 64-bit install of SQL (and in particular, SSIS)? If so, you may want to change your (project) settings to execute the package...

You're looking for AMO (Analysis Management Objects).  Here's a few links around AMO and porting DSO to AMO.

http://technet.microsoft.com/en-us/library/ms345089.aspx

http://technet.microsoft.com/en-us/library/ms403376.aspx

As noted in the first link, AMO is not used for...

taking steve's question a little further, maybe you intended the parentheses to be around the Hazard value checks, like

= IIF((Fields!Hazard.Value >=19 AND Fields!Hazard.Value <=76)

AND Fields!Complience.Value <=11,"Excellent", "OOH OOH")

Hi Chethan,

Take a look at the presentation (linked to from here) .  It details a few of the connection settings you can try, in particular looking to get PTS...

Possibly not at all related but have you got your attribute relationships set correctly between the attributes in the dimension?

It probably wouldn't be too hard to write a script to run with RS.exe to do this, especially fi the reports can all be found nested under a primary folder...

Hi Georgie,

Have you read through the books online section on security, in particular Roles? It's quite possible that you can achieve your desired outcome using the role based security...

Definitely can get and use external values.  See here for the Username function in MDX.

The quote youve got there really looks like it is refering to the aggregations (and also to the base/actual data).  With AS you have the partition of data an also some...

You don't *want* to make changes to the connection string in the MultiServer connection object as this is done as part of the loop container.

At a guess, i would say...

I don't think you can (migrate the metadata to a DB), it's now filesystem based.  Does mean that you might want to ensure your filesystems permissions are set up correctly...

I get the feeling you're trying to query the cube to reverse engineer yourself a fact table...  fun...

Looking at what you've provided above,...