Friendly Names of Dimension Attributes for ProClarity UI tool

Hi,

I am creating Cubes, Dimensions and most of all the SSAS objects using AMO. I use the data from a Oracle datawarehouse for this. Finally when the cubes are ready I use a front end tool called ProClarity Web Professional to create reports off it.

Proclarity displays the cube data with the dimensions as drop downs in the web page. The problem is that the Dimensions and its attributes display the label and value as "DIM_dimname_ColumName". This is because in SSAS the id is programmatically set as "DIM_DimName_ColumnName", This is a standard in the system and cant be changed.

Now I want ProClarity to display friendly names, that I would set in the ssas objects. I am not able to find any property in SSAS where i can set friendly names.

Guess: While I create reports in ProClarity, it gives me a option under Cube Options > Memeber Names > Show Default Names Or Show Alternate member Names. Proclarity displays a message saying that "Alternate names are only avaliable if they exists in the cube definition." Now my question is, does this have to do something with friendly names of the dim and dimAttirbutes? if so how to set them in SSAS?

Regards

Vijay R

Hi Vijay:

The IDs can definitely be changed in the XML. But I am not sure whether the AMO code will give you access to that. You could try setting the Dimension.Name property in your code.

Thanks.

Suranjan

Freeze Panes?

Is there functionality within the Table or Matrix objects to freeze columns or row headers when you scroll thru a wide or long report? Similay to the freeze panes functionality in Excel.

Thanks

Yes, RS 2005 provides this functionality. E.g. in the table properties dialog on the general tab, select "Header should remain visible while scrolling".

-- Robert

|||Sorry.. i may be missing something obvious within the properties, but where is this functionality with a Matrix for row and column headings?|||

In the matrix case, the setting is on the row / column groupings. For instance, you can
1. open the matrix properties dialog
2. go to the Groups tab
3. edit a column or row group
4. and on the general tab of the grouping and sorting dialog, select "Group header should remain visible while scrolling"

-- Robert

|||

I noticed that facility in RS 2005, but could not found it in RS 2000.
I'd appreciate if anybody could give a work around.
Vincent

|||

As I mentioned in my initial response, only RS 2005 provides this feature. It is not available in RS 2000.

-- Robert

|||Thank you Robert.
Vincent|||

I am unable to get this to work on my matrix. When I select 'group header should remain visible while scrolling' (for either row or column), I then get the error

[rsFixedHeadersInInnerDataRegion] The matrix ‘matrix1’ includes a table header or column with FixedHeader set to true. This is not allowed on data regions inside other data regions.

Can anyone provide any help?

|||It seems that your matrix is nested inside another data control which as the error message suggests does not allow fixed headers.|||

Hi ,

Is ther any way to keep the first set of N columns along with the data as frozen and the other columns move behind it as in excel.

I tried to check the option in layout --> fixed header = true but the header along remains frozen but the data is getting overlapped.

please do help at the earliest.

thanks,
Vidula

|||

Hi,

I got the same problem when I select 'group header should remain visible while scrolling' (for either row or column), I got the error

[rsFixedHeadersInInnerDataRegion] The matrix ‘matrix1’ includes a table header or column with FixedHeader set to true. This is not allowed on data regions inside other data regions.

I have matrix inside a table which I set FixedHeader to False but still got the same error. I can't find other places who set fixedheader properties. Any suggestion would be very appraciate!

Thanks in advance!

Freeze Panes?

Is there functionality within the Table or Matrix objects to freeze columns or row headers when you scroll thru a wide or long report? Similay to the freeze panes functionality in Excel.

Thanks

Yes, RS 2005 provides this functionality. E.g. in the table properties dialog on the general tab, select "Header should remain visible while scrolling".

-- Robert

|||Sorry.. i may be missing something obvious within the properties, but where is this functionality with a Matrix for row and column headings?|||

In the matrix case, the setting is on the row / column groupings. For instance, you can
1. open the matrix properties dialog
2. go to the Groups tab
3. edit a column or row group
4. and on the general tab of the grouping and sorting dialog, select "Group header should remain visible while scrolling"

-- Robert

|||

I noticed that facility in RS 2005, but could not found it in RS 2000.
I'd appreciate if anybody could give a work around.
Vincent

|||

As I mentioned in my initial response, only RS 2005 provides this feature. It is not available in RS 2000.

-- Robert

|||Thank you Robert.
Vincent|||

I am unable to get this to work on my matrix. When I select 'group header should remain visible while scrolling' (for either row or column), I then get the error

[rsFixedHeadersInInnerDataRegion] The matrix ‘matrix1’ includes a table header or column with FixedHeader set to true. This is not allowed on data regions inside other data regions.

Can anyone provide any help?

|||It seems that your matrix is nested inside another data control which as the error message suggests does not allow fixed headers.|||

Hi ,

Is ther any way to keep the first set of N columns along with the data as frozen and the other columns move behind it as in excel.

I tried to check the option in layout --> fixed header = true but the header along remains frozen but the data is getting overlapped.

please do help at the earliest.

thanks,
Vidula

|||

Hi,

I got the same problem when I select 'group header should remain visible while scrolling' (for either row or column), I got the error

[rsFixedHeadersInInnerDataRegion] The matrix ‘matrix1’ includes a table header or column with FixedHeader set to true. This is not allowed on data regions inside other data regions.

I have matrix inside a table which I set FixedHeader to False but still got the same error. I can't find other places who set fixedheader properties. Any suggestion would be very appraciate!

Thanks in advance!

Freeze Panes?

Is there functionality within the Table or Matrix objects to freeze columns or row headers when you scroll thru a wide or long report? Similay to the freeze panes functionality in Excel.

Thanks

Yes, RS 2005 provides this functionality. E.g. in the table properties dialog on the general tab, select "Header should remain visible while scrolling".

-- Robert

|||Sorry.. i may be missing something obvious within the properties, but where is this functionality with a Matrix for row and column headings?|||

In the matrix case, the setting is on the row / column groupings. For instance, you can
1. open the matrix properties dialog
2. go to the Groups tab
3. edit a column or row group
4. and on the general tab of the grouping and sorting dialog, select "Group header should remain visible while scrolling"

-- Robert

|||

I noticed that facility in RS 2005, but could not found it in RS 2000.
I'd appreciate if anybody could give a work around.
Vincent

|||

As I mentioned in my initial response, only RS 2005 provides this feature. It is not available in RS 2000.

-- Robert

|||Thank you Robert.
Vincent|||

I am unable to get this to work on my matrix. When I select 'group header should remain visible while scrolling' (for either row or column), I then get the error

[rsFixedHeadersInInnerDataRegion] The matrix ‘matrix1’ includes a table header or column with FixedHeader set to true. This is not allowed on data regions inside other data regions.

Can anyone provide any help?

|||It seems that your matrix is nested inside another data control which as the error message suggests does not allow fixed headers.|||

Hi ,

Is ther any way to keep the first set of N columns along with the data as frozen and the other columns move behind it as in excel.

I tried to check the option in layout --> fixed header = true but the header along remains frozen but the data is getting overlapped.

please do help at the earliest.

thanks,
Vidula

|||

Hi,

I got the same problem when I select 'group header should remain visible while scrolling' (for either row or column), I got the error

[rsFixedHeadersInInnerDataRegion] The matrix ‘matrix1’ includes a table header or column with FixedHeader set to true. This is not allowed on data regions inside other data regions.

I have matrix inside a table which I set FixedHeader to False but still got the same error. I can't find other places who set fixedheader properties. Any suggestion would be very appraciate!

Thanks in advance!

Freeze Panes?

Is there functionality within the Table or Matrix objects to freeze columns or row headers when you scroll thru a wide or long report? Similay to the freeze panes functionality in Excel.

Thanks

Yes, RS 2005 provides this functionality. E.g. in the table properties dialog on the general tab, select "Header should remain visible while scrolling".

-- Robert

|||Sorry.. i may be missing something obvious within the properties, but where is this functionality with a Matrix for row and column headings?|||

In the matrix case, the setting is on the row / column groupings. For instance, you can
1. open the matrix properties dialog
2. go to the Groups tab
3. edit a column or row group
4. and on the general tab of the grouping and sorting dialog, select "Group header should remain visible while scrolling"

-- Robert

|||

I noticed that facility in RS 2005, but could not found it in RS 2000.
I'd appreciate if anybody could give a work around.
Vincent

|||

As I mentioned in my initial response, only RS 2005 provides this feature. It is not available in RS 2000.

-- Robert

|||Thank you Robert.
Vincent|||

I am unable to get this to work on my matrix. When I select 'group header should remain visible while scrolling' (for either row or column), I then get the error

[rsFixedHeadersInInnerDataRegion] The matrix ‘matrix1’ includes a table header or column with FixedHeader set to true. This is not allowed on data regions inside other data regions.

Can anyone provide any help?

|||It seems that your matrix is nested inside another data control which as the error message suggests does not allow fixed headers.|||

Hi ,

Is ther any way to keep the first set of N columns along with the data as frozen and the other columns move behind it as in excel.

I tried to check the option in layout --> fixed header = true but the header along remains frozen but the data is getting overlapped.

please do help at the earliest.

thanks,
Vidula

|||

Hi,

I got the same problem when I select 'group header should remain visible while scrolling' (for either row or column), I got the error

[rsFixedHeadersInInnerDataRegion] The matrix ‘matrix1’ includes a table header or column with FixedHeader set to true. This is not allowed on data regions inside other data regions.

I have matrix inside a table which I set FixedHeader to False but still got the same error. I can't find other places who set fixedheader properties. Any suggestion would be very appraciate!

Thanks in advance!

Freeze Panes?

Is there functionality within the Table or Matrix objects to freeze columns or row headers when you scroll thru a wide or long report? Similay to the freeze panes functionality in Excel.

Thanks

Yes, RS 2005 provides this functionality. E.g. in the table properties dialog on the general tab, select "Header should remain visible while scrolling".

-- Robert

|||Sorry.. i may be missing something obvious within the properties, but where is this functionality with a Matrix for row and column headings?|||

In the matrix case, the setting is on the row / column groupings. For instance, you can
1. open the matrix properties dialog
2. go to the Groups tab
3. edit a column or row group
4. and on the general tab of the grouping and sorting dialog, select "Group header should remain visible while scrolling"

-- Robert

|||

I noticed that facility in RS 2005, but could not found it in RS 2000.
I'd appreciate if anybody could give a work around.
Vincent

|||

As I mentioned in my initial response, only RS 2005 provides this feature. It is not available in RS 2000.

-- Robert

|||Thank you Robert.
Vincent|||

I am unable to get this to work on my matrix. When I select 'group header should remain visible while scrolling' (for either row or column), I then get the error

[rsFixedHeadersInInnerDataRegion] The matrix ‘matrix1’ includes a table header or column with FixedHeader set to true. This is not allowed on data regions inside other data regions.

Can anyone provide any help?

|||It seems that your matrix is nested inside another data control which as the error message suggests does not allow fixed headers.|||

Hi ,

Is ther any way to keep the first set of N columns along with the data as frozen and the other columns move behind it as in excel.

I tried to check the option in layout --> fixed header = true but the header along remains frozen but the data is getting overlapped.

please do help at the earliest.

thanks,
Vidula

|||

Hi,

I got the same problem when I select 'group header should remain visible while scrolling' (for either row or column), I got the error

[rsFixedHeadersInInnerDataRegion] The matrix ‘matrix1’ includes a table header or column with FixedHeader set to true. This is not allowed on data regions inside other data regions.

I have matrix inside a table which I set FixedHeader to False but still got the same error. I can't find other places who set fixedheader properties. Any suggestion would be very appraciate!

Thanks in advance!

FREE SOFTWARE!

DB Ghost - the scripter, scripts out all your database objects as individual scripts. This includes static data, so you can select your static data tables and "the scripter" will create a .SQL file containing all the insert statements for that table. Each
different object type will be created within it's own directory. DB Ghost - the scriptor can then add all these files into Visual SourceSafe mirroring the structure on your hard-drive as Directory to Project and source file to SourceSafe item.
So there you have it, a quick and painless way to script and save all your SQL Server database code into SourceSafe - just point and click.
Best of all though - it's free, just download the DB Ghost evaluation version (which is limited to thirty days) and DB Ghost - the scripter is included which never expires!
www.dbghost.com
Mark, spammers often use subjects such as yours within their posts. I =
almost did not open your post, but then I read your name and I figured =
that this message had a 95% chance of being legit so I took the chance =
and opened the post. You may want to submit another post that mentions =
your product in the subject line.
--=20
Keith
"mark baekdal" <anonymous@.discussions.microsoft.com> wrote in message =
news:B32097DF-10D3-4D4C-8C5C-965A46178E3D@.microsoft.com...
> DB Ghost - the scripter, scripts out all your database objects as =
individual scripts. This includes static data, so you can select your =
static data tables and "the scripter" will create a .SQL file containing =
all the insert statements for that table. Each different object type =
will be created within it's own directory. DB Ghost - the scriptor can =
then add all these files into Visual SourceSafe mirroring the structure =
on your hard-drive as Directory to Project and source file to SourceSafe =
item.
>=20
> So there you have it, a quick and painless way to script and save all =
your SQL Server database code into SourceSafe - just point and click.
>=20
> Best of all though - it's free, just download the DB Ghost evaluation =
version (which is limited to thirty days) and DB Ghost - the scripter is =
included which never expires!=20
>=20
> www.dbghost.com
>
|||thanks Keith, I'll follow your advice

Free database tool ~ DB Ghost - the scripter

DB Ghost - the scripter, scripts out all your database objects as individual scripts. This includes static data, so you can select your static data tables and "the scripter" will create a .SQL file containing all the insert statements for that table. Each
different object type will be created within it's own directory. DB Ghost - the scriptor can then add all these files into Visual SourceSafe mirroring the structure on your hard-drive as Directory to Project and source file to SourceSafe item.
So there you have it, a quick and painless way to script and save all your SQL Server database code into SourceSafe - just point and click.
Best of all though - it's free, just download the DB Ghost evaluation version (which is limited to thirty days) and DB Ghost - the scripter is included which never expires!
www.dbghost.com
But its not really free is it. Its a trial version of your software.
"mark baekdal" <anonymous@.discussions.microsoft.com> wrote in message
news:87390168-7861-4238-AB47-CDB3A281492F@.microsoft.com...
> DB Ghost - the scripter, scripts out all your database objects as
individual scripts. This includes static data, so you can select your static
data tables and "the scripter" will create a .SQL file containing all the
insert statements for that table. Each different object type will be created
within it's own directory. DB Ghost - the scriptor can then add all these
files into Visual SourceSafe mirroring the structure on your hard-drive as
Directory to Project and source file to SourceSafe item.
> So there you have it, a quick and painless way to script and save all your
SQL Server database code into SourceSafe - just point and click.
> Best of all though - it's free, just download the DB Ghost evaluation
version (which is limited to thirty days) and DB Ghost - the scripter is
included which never expires!
> www.dbghost.com
>
|||No Brian,
"DB Ghost - the scripter" really is free, no evaluation period, no cost - Free!
"DB Ghost" has an evaluation period and has a cost - "DB Ghost" is not free.
Two seperate exe's, doing different things, one which is free, one which is not.
Same MSI, two exe's. Download the DB Ghost evaluation and it'll come with the scripter which is free.
-- Bryan Oliver wrote: --
But its not really free is it. Its a trial version of your software.
"mark baekdal" <anonymous@.discussions.microsoft.com> wrote in message
news:87390168-7861-4238-AB47-CDB3A281492F@.microsoft.com...
> DB Ghost - the scripter, scripts out all your database objects as
individual scripts. This includes static data, so you can select your static
data tables and "the scripter" will create a .SQL file containing all the
insert statements for that table. Each different object type will be created
within it's own directory. DB Ghost - the scriptor can then add all these
files into Visual SourceSafe mirroring the structure on your hard-drive as
Directory to Project and source file to SourceSafe item.[vbcol=seagreen]
SQL Server database code into SourceSafe - just point and click.[vbcol=seagreen]
version (which is limited to thirty days) and DB Ghost - the scripter is
included which never expires![vbcol=seagreen]