ProClarity Slicersel parameters

Hi,

I am using ProClarity 6.1 and Enterprise version of analysis server 2005. (not sure if I need an proclarity update or a fix for ProClarity because i guess there is a newer version 6.2)

Because of one of the performance optimizations that I did after following some blogs on the net, I can't specify slicerSel parameters to my proclarity graphs! Let me explain:

I have a slicer in Proclarity graph for which I used to specify a url querystring parameter as slicerSel=xxxxxx. This was working until I modified the dimension.

The modification: initially my dimension had the following attributes: Key, Name. Now I just have one attribute Name, whose key column points to KEY (db) and Name column points to NAME (db). because of this my slicerSel parameters do not work.

I checked the html of proclarity by doing an view souce and found the following difference.

before:

<option value ="[CLIENTNAME].[NAME].&amp;[ABCDE FGHIJK]">ABCDE FGHIJK<option>

After modifing the Keycolumn and Namecolumn:

<option value ="[CLIENTNAME].[NAME].&amp;[4.94735E6]">ABCDE FGHIJK</option>

Now I can't specify the slicer using the number 4.94735E6 which i dont think is the key (its in scientific format).

My question is, Is there any way out to specify the slicer as ABCDE FGHIJK (Name) as before ?

If it is not possible, shall I add another attribute to the dimension called Key and then seperate the Key and Name from the single attribute? will this impact the performance? especially because the dimension will have another attribute which contains just the key, which will not be displayed but used in the relationships. Is there any specific way to design this? (Key is the primary key column of the database table, which is used for storing dimension values and referenced in the Fact tables).

Regards

Your key is 494735.

The only way you will get the name there is to set-up the name only as a separate attribute. Then the name will be used as a key, slightly less efficient. ProClarity generates the MDX with the key element of the attribute value that is selected from the slicer.

You can also change the data type of the key when creating the attributes in Visual Studio. Sometimes it defaults to a double if the data is sourced from a view rather than a table.

Processing SSAS 2005 Database Hangs

Hi,

After making changes to our development SSAS 2005 Database, I try to reporcess but it just seems to hang. Rebooting the server seems to fix the issue because once the server comes back up, I'm able to reprocess and see the progress immediately.

This server has SP2 installed.

Has anyone else run across this?

Thanks,

Brian

Maybe the was an lock on the database by you or an other user.

If there is an lock on the database this is the intended behavior.

In the analysis services samples there is an activity viewer where you could check for locks and sessions on the server.

Best Regards, HANNES

|||Thank you for the reply. Can you explain more on where to find the activity viewer that displays locks and instances?|||

It is a C# Sample Code Program you have to manually setup with SQL Server 2005 Samples.

By default the samples install to C:\Program Files\Microsoft SQL Server\90\Samples with the special location of \Analysis Services\Administrator\ActivityViewer for the analysis activitiy viewer.

HANNES

Processing a cube dimension

I am trying to process a time dimension on a cube and get the following error. Can some one please help. How can I fix this error?

Error 1 Errors related to feature availability and configuration: Exceeded the maximum number of partitions in a measure group. The installed server editions allows not more than 3 partitions and not more than 1 writeback partition. 0 0

That is the error if you try to use Standard Edition and partitioning.

Partitioning is an EE-only feature.

_-_-_ Dave