What you want to see on DotNetFunda.com ?
DotNetFunda.Com Logo
Twitter TwitterLinkedIn
YouTubeGoogle
 Online : 62097 |  Welcome, Guest!   Register  Login
 Home > Forums > Sql Server > How to fix the Design Warings in Analysis Services in SQL Server 2008 ? ...
Devanand

How to fix the Design Warings in Analysis Services in SQL Server 2008 ?

Replies: 1 | Posted by: Devanand on 5/22/2010 | Category: Sql Server Forums | Views: 1825 | Status: [Member]  


hi Dude

I am using Analysis Services in SQL Server 2008, When i deploy the SSAS, I had one Error saying that "Browser Server Error".... and two Warnings.

I fixed that one Error. But the Warnings still there.

Kindly tell me how to hide the all warnings ?

Hierarchy [DimSchedule].[Rate by Item] : Attribute relationships do not exist between one or more levels of this hierarchy. This may result in decreased query performance.

Dimension [DimSchedule] : Avoid visible attribute hierarchies for attributes used as levels in user-defined hierarchies.


thanks in advance
Devanand


Reply | Reply with attachment | Alert Moderator

 Responses below this adGet hundreds of .NET Tips and Tricks videos

 Replies

PandianS
PandianS  
Posted on: 5/22/2010 2:29:52 AM
Level: Silver | Status: [Member] [MVP]

Hi Devanand

Good Day

A) Hiding the Design warnings can be done as the following way...

1. Open your Analysis Services Project.

2. Normally your project will show the Design warnings. If its not showing the design warning then...
Click View menu --> Click Error List menu item. It will show you the all Errors, Design Warnings and Messages.

3. In your case, you have two design warnings.... OK

4. Right click on First Design Warning and Click Dismiss..., Continue this activity for remaining all Design warnings.

Fine. Now you have hidden all your Design warnings.

B) Un-Hiding the Design warnings can be done as the following way...

If you want to Un-hide the hidden design warnings then...

1. Right click on your SSAS Solution on Solution Explorer.

2. Click Edit Database, You will have two Tabs (General, Warnings).

3. Click on Warnings Tab. Under the Dismissed Warnings area.

4. Click the Design warning and Click Re-enable button under the grid.

5. Click Build menu, Click Deploy <Sollution Name>. Now the all un-Hidden design warnings will display in Error List.

Note: The Hiding / Un-Hiding activities is not permanent solution / not recommended. So, You have to define Hierarchy.

Cheers

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Devanand, if this helps please login to Mark As Answer. | Reply | Alert Moderator 

Reply - Please login to reply


Click here to login & reply

Found interesting? Add this to:


 Latest Posts

Write New Post | More ...

About Us | Contact Us | The Team | Advertise | Software Development | Write for us | Testimonials | Privacy Policy | Terms of Use | Link Exchange | Members | Go Top
General Notice: If you find plagiarised (copied) contents on this page, please let us know the original source along with your correct email id (to communicate) for further action.
Copyright © DotNetFunda.Com. All Rights Reserved. Copying or mimicking the site design and layout is prohibited. Logos, company names used here if any are only for reference purposes and they may be respective owner's right or trademarks. | 5/24/2013 11:11:43 AM