Showing posts with label dimension. Show all posts
Showing posts with label dimension. Show all posts

Thursday, March 22, 2012

Can't add a sibling or child to a member in a dimension

Following the Foodmart tutorial, I get to a point where I create a parent-child dimension and I browse data. Then I have to add a sibling or a child by right-clicking a member and selecting "New member" (all in the Dimension Editor). However, nothing happens on my right-clicking, no context menu at all. Could it be a versioning issue? I'm using SQL Server 2000 Standard edition. I already found out I can't use the writeback feature in this version...

Thanks and happy holidays!

Ale

Hi Ale,

I think that you need Enterprise Edition, since the right-click menu is only available after the dimension's Write-enabled property is set to True:

http://msdn2.microsoft.com/en-us/library/aa198057(SQL.80).aspx

>>

Analysis Services

Write-Enabled Dimensions

...

Note This feature is available only if you install Analysis Services for Microsoft? SQL Server? 2000 Enterprise Edition.

...

To write-enable a dimension, set its Write-enabled property to True in the properties pane of Dimension Editor (if the dimension is shared) or Cube Editor (if the dimension is private).

>>

|||That makes a lot of sense, thanks Deepak!

Tuesday, March 20, 2012

cant access invisible dimension. (still no solution)

i am trying to access invisible dimension in the reporting services surface. but it is giving error. is there any way to access invisible dimension in the reporting services surface. but this hidden dimension can access in the sql 2005 management server. but in the reporting services cant. pls tel m some way to do that.
pls give me the solution if anyone know about this.
|||

You cannot use Hidden Dimensions in SSRS.

But U can create Hidden Calculated Members in Cube, which U R creating in SSRS MDX.

Then use that Calculated Members in Report MDX Query, It will work fine.

Bhudev

|||thx dev

cant access invisible dimension(urgent). still couldnt find the answer

i am trying to access invisible dimension in the reporting services surface. but it is giving error. is there any way to access invisible dimension in the reporting services surface. but this hidden dimension can access in the sql 2005 management server. but in the reporting services cant. pls tel m some way to do that.
pls give me the solution if anyone know about this.
|||

You cannot use Hidden Dimensions in SSRS.

But U can create Hidden Calculated Members in Cube, which U R creating in SSRS MDX.

Then use that Calculated Members in Report MDX Query, It will work fine.

Bhudev

|||thx dev

Saturday, February 25, 2012

Cannot specify 'dimension' for: Maintenance plan remove files older than

OS: Windows Server 2003 Standard Edition. MSDE 2000.

SQL Server Enterprise Manager Version 8.0.

The Maintenance Plan Wizard will not allow me to specify a value for the 'Remove Files...' I can enter a number but there is nothing in the drop down e.g. 3 'DAYS' perhaps?

Create then plan and then edit - yields the same result.

Any ideas on why there is no 'dimension' for Remove Files Older than ?

Appreciate any tips, ideas, etc.

Thank.s

Anybody have issues trying to specify a dimension for 'Remove Files...' either during Maintenance Wizard (create) or afterwards - edit properties?

The drop down - where you would expect a list of values like: day, week, month - is completely blank?

|||

I'm experiencing the exact same problem with my MSDE database. I cannot specify anything as to days, weeks, etc. It also will take other information, such as scheduling, directory, extension name, and actually create the jobs correctly, but then when you go back to the Maintenance Plan, you find the information has disappeared. If you try to modify any other aspect of the plan, you get an error, because this information is now missing. This is the only MSDE db I have, all the rest are standard or enterprise and work normally from the same Enterprise Manager.

I have not found any explanation or work-around for this problem.

Cannot specify 'dimension' for: Maintenance plan remove files older than

OS: Windows Server 2003 Standard Edition. MSDE 2000.

SQL Server Enterprise Manager Version 8.0.

The Maintenance Plan Wizard will not allow me to specify a value for the 'Remove Files...' I can enter a number but there is nothing in the drop down e.g. 3 'DAYS' perhaps?

Create then plan and then edit - yields the same result.

Any ideas on why there is no 'dimension' for Remove Files Older than ?

Appreciate any tips, ideas, etc.

Thank.s

Anybody have issues trying to specify a dimension for 'Remove Files...' either during Maintenance Wizard (create) or afterwards - edit properties?

The drop down - where you would expect a list of values like: day, week, month - is completely blank?

|||

I'm experiencing the exact same problem with my MSDE database. I cannot specify anything as to days, weeks, etc. It also will take other information, such as scheduling, directory, extension name, and actually create the jobs correctly, but then when you go back to the Maintenance Plan, you find the information has disappeared. If you try to modify any other aspect of the plan, you get an error, because this information is now missing. This is the only MSDE db I have, all the rest are standard or enterprise and work normally from the same Enterprise Manager.

I have not found any explanation or work-around for this problem.