.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Categories the Aggregations

Posted By:      Posted Date: October 20, 2010    Points: 0   Category :Sql Server

I have a cube with one of the dimension as Category(IN, OUT), the measures are sum, avg and distinct products of that category.

The question is: How I can fix / make default and lock the category dimension whenever the cube is browsed by any tool.

The problem is that:

If user exclude the category dimension in the browser window the summation will be of both the categories (IN & OUT), but I always want the output to be divided as category. In other words how can I lock the category dimension as the default selection and always display the mesures in category as below: 

IN Summation Value, Avg Value, Distinct Value

Out Summation Value, Avg Value, Distinct Value

View Complete Post

More Related Resource Links

Category attribute of user control property does not work correctly in categories tab.



I have a User Control (ascx) and a property which a want to display in my categories tab in Visual Studio in the category named "Styles".

[Category("Styles"), DefaultValue(""), Description("The value for formating something.")]
public String MyFormatProperty
set { /* the code for set */; }
get { /* the code for get */; }

And here is the problem: Actually I do not need a get, because I only have to set the property (write only property). But when I omit the get, the property is displayed in the "Misc" category in the categories tab in Visual Studio. Only when I code the get as well, then the property is displayed correctly in the "Styles" category in the categories tab in Visual Studio.

Does anybody know why? How can I display the category correctly only with set?

Thanks, S.

Control Gallery: some categories are not expaning

In this page,I noticed that some categories are not expanding.

Incremental processing -> aggregations dropped, even with rigid attribute relations

Hi! Very briefly, my goal is to incrementally process the fact data for my SSAS 2005 cube, without losing aggregations. For that purpose, I have defined all attribute relationships as rigid (I don't really expect any of the relations to change) because I hear that flexible aggregations get dumped during incremental processing. BIDS Helper indeed confirms that all of my aggregations are rigid. Then I proces the cube, either via the SSMS GUI using the "Process Incremental" option, or with an XMLA command using type "ProcessAdd". The outcome is the same, no matter which method I use. Then I check the status of my aggregations. I do so first by sending a DISCOVER_PARTITION_STAT Discover XMLA query (http://geekswithblogs.net/darrengosbell/archive/2008/12/02/ssas-are-my-aggregations-processed.aspx), and, as a double check, by sending a query to the cube from which I know it normally uses an aggregation and checking in the profiler whether the aggregation is really used. The result is always the same: The aggregations are lost! The DISCOVER_PARTITION_STAT query informs me that all aggregations have size = 0. Note, that after a ProcessFull, all aggregations are there (with size > 0) and work as expected, so the problem only occurs after incremental processing. Also for the problem to occur it is enough to incrementally process the cube, the dimensions are lef

How to create a Measure without aggregations

Hi all, The data in the fact table has columns which are precalculated ranks for the products based on sales. How to create them as measures in the cube without any aggregations. I selected the properties for measure as "No Aggregations" while creating. But I dont see any data. Then I tried to create those columns as seperate dimensions by doing self join to the fact table.In this way I get the correct data,but the performance is slow. Is there any other way to try out which has both data and performance. Please help me out. Thanks, Sam

How do I create Sub-Categories under Categories in a Blog Site

Hello, Looking for help using a blog site I need to create sub-categories under Categories that are located  in the Quick Launch area and also be able to add to sub-categories when needed, plus click the sub-category and it will open the post under that sub-category. I hope that I am making sense.  Thank you so much, JAM

Sharepoint Blog Site, adding sub-categories

Hello, Looking for help using a blog site I need to create sub-categories under Categories that are located  in the Quick Launch area and also be able to add to sub-categories when needed, plus click the sub-category and it will open the post under that sub-category. I hope that I am making sense.  Thank you so much, JAM

How do I add categories to Wiki pages?

I have sharepoint 2010 and I need to add categories to my wiki pages. The problem is that the category field is greyed out and clicking the tags icon next to it does nothing (nothing opens, no error messages). I know this is looked after by the managed metadata and I have access to this and I can add/create/remove terms and groups. But for the life of me, I can't get the categories to open up and be usable. And I can't find any info on troubleshooting this. Can anyone help? I could be doing something stupid so forgive me if this is a dumb question.

Unlimited Categories and Sub Categories

Dear All, I want to add unlimited categories and sub categories facility, But I couldn't solve it for last two days. Can any body help me in this regards, Issue:   1. DB  CategID,CategName,parentid Data:  CategID             CategName                  Parent ID   1                        Electronics                    0 (where 0 means it is main category)   2                        TV                              1 (Self Join whith the categ id Electronics)   3                         Panasonic                  2   4   &

Entities Data Models with multiple Categories using a membership table

(Using SQL Server 2008 and ASP.NET MVC2) I have a simple business table and a category table. I have a 3rd table to map business to category, a many-to-many relationship. the Map table contains a BusinessID and CategoryID. I'm lost as to how I can load the categories into my Business View Model using the entities model.Without incorporating categories, my code looks like this: var businessList = from b in entitiesDB.Businesses select new Models.BusinessViewModel { BusinessID = b.BusinessID, Name = b.Name } with Business View Model defined as: public class BusinessViewModel { [ScaffoldColumn(false)] public Guid BusinessID { get; set; } public string Name { get; set; } public List<Models.CategoryViewModel> Categories { get; set; } } but if i want to populate the Categories with the mapped categories, how would one do that?Thanks in advance for any help!

Returning Customer Count of all categories in each time period



Lets say I have the following Table:

CustomerNumber | Date | MovieCategory
1 |2010-01-01|A
1 |2010-02-01|A
1 |2010-03-01|A
1 |2010-04-01|A
1 |2010-05-01|A
1 |2010-06-01|D
1 |2010-07-01|A
2 |2010-01-01|A
2 |2010-02-01|A
2 |2010-03-01|D
2 |2010-04-01|D
2 |2010-05-01|D
2 |2010-06-01|C
2 |2010-07-01|C
3 |2010-01-01|B
3 |2010-02-01|B
3 |2010-03-01|B
3 |2010-04-01|C
3 |2010-05-01|C

What I want to do is count the number of customers for each movie type in each date. Now I started with the following simple query

Select Date, MovieCategory, Count(CustomerNumber)
From AboveTable
Group By Date, MovieCategory
Order by Date, MovieCategory

which would be okay, but if no customer has a MovieCategory of say 'B' on a particular date then the results of the above query won't return a row that has

Date| B| 0     (date here could be any date).


which is really what I need. Is there a good way to

Need to show all categories


I need for my select statement to return all categories in the tblLookupCateg table even if a client had no points for the category for the month. Here is what I have, can anyone help me modify to show all categories, but zero if null points for any of them?

SELECT     tblLookupCateg.Category, Sum(tblPoints.Points) AS TotalPoints, MONTH(tblpoints.[pDate]) Month
FROM         stblpoints left outer JOIN
                      tblLookupCateg ON stblpoints.CategID = tblLookupCateg.CategID
WHERE     (YEAR(tblpoints.[pDate]) = 2010) AND (MONTH(tblpoints.[pDate]) = 8) AND (tblPoints.IndivID=14)
GROUP BY tblLookupCateg.Category,tblpoints.[pDate]

Category TotalPoints Month
PlanA    0    8
PlanB    3    8
PlanC    0    8
PlanD    5    8

Privacy categories user profile properties



I would like to delete some privacy categories, used to display the user profile properties.

Default options are : only me, my manager, my team, my colleagues and everyone.
I only wish to display "only me" and "everyone".

How can I accomplish this?


Organize pages in categories



I am setting up a site for news. On the first page I have added a CQWP to display all the news-articles (pages).

I want to make some kind of dropdown functionality or something, that when you create a new page you have to select which category you are putting the article in. What is the best solution for this?

I tried this;

I created a new column with a choice in the site settings and implemented this code to the pagelayout.

<SharePointWebControls:DropDownChoiceField FieldName="Category" runat="server" />


This didn't work apparently.. 

how to ensure aggregations and partitions are effectively being used by MDX queries?


we have added partitions and aggregations on all big measures groups, but want to ensure whether they are really being used by MDX query engine or not. I know we can use profiler for this, but want to know how to interpret those details.


Problem seeing all Web Part Categories When Adding a Web Part

I have a development page that a one of my users is currently working on.  When he tries to add a web part to the page, the only web part category that he can see is the "Lists and Libraries" category.  When I go in, I see every category.  I have set him as an owner of the site, but that still has not given him access to see the other web parts.  I am convinced that this is a permissions issue, but I don't know what permission set he seems to be missing.  Anyone have any ideas?

Creating aggregations in SSAS 2005



I'm beginning to use the SSAS aggregations. I have created the aggregations for a cube after I have specified the estimated count and I have saved them without deploy them. Is it possible to see the aggregations without the deploy?

Any helps to me, please? Thanks

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend