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


Post New Web Links

row number and the top 3 members in a set and the last 3 members

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :
 

hi ,

I need to bring the row number of each member in a set.

and to recognize the top 3 members and the last tree members

I also know that the numbers of rows change the dynamicly, so I need to recognize last row

for example if I run this query:

 

select

{[Measures].[Internet Sales Amount]}

on 0,

{[Customer].[Customer Geography].

members} on 1
 

View Complete Post


More Related Resource Links

The number of members in the conceptual type ... does not match with the number of members on the ob

  

 Hello,

I've added a scalar property to an entity and now ASP.NET Dynamic Data scaffolding throws this error:

The number of members in the conceptual type 'TrainingModel.Users' does not match with the number of members on the object side type 'TrainingModel.Users'. Make sure the number of members are the same.

This happens at the following line in global.asax:
model.RegisterContext(typeof(TrainingModel.TrainingEntities), new ContextConfiguration() { ScaffoldAllTables = true });

Please help!
Thanks


How do I get the emails of all the members of a given group in ActiveDirectory - Need help

  

Hi,

  I have a need to send out emails to all the people who are in a given group say "HR Department". I need to be able to get all the emails through a for loop and then as it retrieves I should send emails to them. Can some one please help me with the code

this is what I came up with but not sure how to go about writing a for loop to get all the emails in the given group.

public static string SendEmails(string loginName)
    {
        string Department = "HR Department"
        string userName = ExtractUserName(loginName);
        DirectorySearcher search = new DirectorySearcher();
        search.Filter = String.Format("(SAMAccountName={0})", userName);
        //search.Filter = String.Format("(SAMAccountName={FAY ImprovmentForm})", userName);
        //LdapSearcher.Filter = string.Format("(&(objectClass=user)(department={0}))", Department); 
        //search.Filter = string.Format("(&(objectClass=group)(SAMAccountName=" + Department + "))", userName);
        search.PropertiesToLoad.Add("cn");
        search.PropertiesToLoad.Add("samaccountname");
        search.PropertiesToLoad.Add("givenname");
        search.PropertiesToLoad.Add("sn");
        sea

overriding "grand totals" for calculated members

  
hi all, is there a workaround for overriding "grand totals" for calculated members?  (I cannot use the workaround whereby I create the calculation in the DSV or view directly due to it being a pretty complex Descendant parent/child calculation).   thanks much for any thoughts, Cos

MDX to read members from "restricted access" role

  
Is it possible to read list of members from "restricted access" roles? I want an MDX so we can create an exception report for maintance purposes to match this list with some other list. I only need to list what I see when I open "resticted access" role - domains with user names. thank you!

Aggregate only filtered members

  
I’m creating a measure in a cube as lookup from another cube: CREATE MEMBER CURRENTCUBE.[MEASURES].[Test]  AS     lookupcube("[Cube1]",     "([Measures].[PublicPrice],     [Cube1 DimDate].[TIME Hierarchy].[" + [Cube2 DimDate].[TIME Hierarchy].currentmember.name + "]     )")     If I select in filter only January 2010 and February 2010 in Cube1, for Quarter 1  I obtain 100; in Cube2  I obtain 150. Even if March 2010 is not selected in Cube2 the aggregation level (the Quarter) considers it. Could someone help me? Thank you very much, Giada

No results for users that are members of a 'Deny All' policy for web application

  
I have a SharePoint Farm with search working happily.  This farm also has a remote access component that I have configured on a separate extended web application.  The business has some accounts that it does not want to allow access to the Intranet remotely, and has added these accounts to a 'Non Remote Intranet Users' security group.  I then set up a rule on the Extranet zone to Deny All access for this group.  The Default zone still allows them to browse however, which is working great. The only problem is that members of this group do not get any search results whatsoever.  From the logs it appears that all results get security trimmed.  :( Can I disable security trimming somehow?  Is this a bug?  Any suggestions would be appreciated.  :)

SSAS - How to get other members from dimension that has Parent Child hierarchy?

  
I have a Sales Territory dimension that has employee and parent employee attribute on which parent child hierarchy is defined and it gives below hierarchy while browsing - - Mark Rolls --- Lumin Jacs ----- Larry Gomes ------- Messica Owens ------- Tom Ted ----------- Jackson Lopez ----- Matthew Ron --- Fred jacob - Jason Ron --- Jecy Pedro   But beside this parent-child hierarchy I have other attributes like employee address, email and telephone. My facts related sales transaction is tagged to lowest level. For example here facts are available only for Jackson Lopez (being Field Executive). When use below query I get complete sales reporting hierarchy result with some measures like sales amount, sales volume. But while accesing other attributes like address or email, it's repeating address/email/telephone of jackson Lopes everywhere to whom fact record is linked, Actually I want address/email/telephone of each sales employee from that dimension within hierarchy. How do I get it? The query I used is: Here Parent Terr ID is parent child hierachy. SELECT ( Descendants( { [Dim SalesRegion].[Parent Terr ID].[Employee Level 01].&[538018] /* here Mark Rolls is 538018 */ }, 0,AFTER), NONEMPTY([Dim SalesRegion].[Emp Address].[Emp Address].Members), NONEMPTY([Dim SalesRegion].[Emp Email].[Emp Email].Members) ) ON ROWS , { ([Dim Date].[The Year].[The Year].[CY-2010], [Dim

Long list of calculated members

  
·         I have a long list of calculated members. How can I make this long list user friendly like categorizing them by functionality? Can I create measure group for calculated measures?   Alex  

Parent child hierarchy & MDX to fetch particular level & all members below it along with measures us

  
I have a Sales Territory dimension that has employee and parent employee attribute on which parent child hierarchy is defined and it gives below hierarchy while browsing - - Mark Rolls --- Lumin Jacs ----- Larry Gomes ------- Messica Owens ------- Tom Ted ----------- Jackson Lopez ----- Matthew Ron --- Fred jacob - Jason Ron --- Jecy Pedro   But beside this parent-child hierarchy I have other attributes like employee address, email and telephone. My facts related sales transaction is tagged to lowest level. For example here facts are available only for Jackson Lopez (being Field Executive). When use below query I get complete sales reporting hierarchy result with some measures like sales amount, sales volume. But while accesing other attributes like address or email, it's repeating address/email/telephone of jackson Lopes everywhere to whom fact record is linked, Actually I want address/email/telephone of each sales employee from that dimension within hierarchy. How do I get it? The query I used is: Here Parent Terr ID is parent child hierachy. SELECT ( Descendants( { [Dim SalesRegion].[Parent Terr ID].[Employee Level 01].&[538018] /* here Mark Rolls is 538018 */ }, 0,AFTER), NONEMPTY([Dim SalesRegion].[Emp Address].[Emp Address].Members), NONEMPTY([Dim SalesRegion].[Emp Email].[Emp Email].Members) ) ON ROWS , { ([Dim Date].[The Year].[The Year].[CY-2010], [Dim

MDX query performance is slow for complex logic implementation in Calculated Members.

  
We have implemented a calculated members which involves multiple calculated members  called in a nested e.q. Cal1 calls Cal2 and Cal2 calls  Cal3  and Cal3 calls Cal4 .  And when browing Cal1 through Excel it takes around 30 mins for getting result from a Partition having row count around 5 million. Follwing are the information on the scenario I am having: We are having partitioning in the cube. one partition contains around 4-6 million records Processers on Query Server: 4 quad core RAM on the Query Server: 64 GB Calculated members having simple calculation logics are giving results in no time. There is a Calculated members which calls 6 intermediate calculated in nested way and with small Data Set like 5-6 k rows it is running fine.   Any help will be much appreciated.   Regards, Sandeep

Cannot Access Certain Members of a Non-Null SPUser

  
When logged in with certain users and we try to access SPUser.Groups or SPUser.OwnerGroups we are getting an error that redirects us to our custom error page. The odd part is that the SPUser object is not null and even when surrounding these offending statements in try/catch blocks we still receive the error redirect. Here is a code snippet showing one of the member accesses that is causing the error redirect:   SPUser _user =SPControl.GetContextWeb(this.Context).CurrentUser; if (_user == null) { _user = SPContext.Current.Web.EnsureUser("Sharepoint/System"); } if(_user != null) { if(_user.Groups != null) { foreach (SPGroup _userGroup in _user.Groups) { _HiddenDiv.Text += _userGroup.Name.ToString() + ", " ; } } This along with any access of Groups or OwnerGroups will cause a redirect to our custom error page. However, as mentioned above, this is only affecting about half of our user population -- the other half is able to login and have their groups examined properly. As always, please let me know if you have any questions or need some further information. Any help with this is greatly appreciated as I'm not sure I have too many hairs left to pull out of my head ;) -Tim

Use of Calculated members from one fact into the other fact MDX

  
Hi, I have a FactBookvalues which calculates the Book value of several aircraft. this book value has a startdate going fro example from 1980 up to inlcuding 2030. With this MDX statement im able to determine what the book value is for a specific month: SELECT {[Measures].[Asset Bookvalue balance]} ON 0,   [MSN].[Asset Label].allmembers on 1 from CMSX_DWH_OLAP where {StrToMember("[Book Value Start Date].[Year - Quarter - Month].[Month].&["  + Format(now(), "yyyy") + "]&[" +  Format(now(), "MM") + "]")}   this work great in SQL server management studio, it will list all aircraft with the bookvalue for that particulair month.What i want is to get this value for that specific date and use this value as a fact for the AssetFact. how is this possible? i tried to make a calculated member but this didnt work. Im a bit stuck. I dont want to get this bookvalue from the ETL process but from the the cube itself to see how you can reuse dataelements in other areas of ssas

People search results showing members deleted from AD

  
Hi guysWe've configured a full nightly import of users from AD, but I'm seeing users who have been deleted showing up under the People Search function.  Does the import job delete accounts from SharePoint that no longer exist in AD?  If not, is there a way to change this?Tks,steven

Can I use class members for data or do I need to use Variable?

  
I have a class derived from CodeActivity that creates some objects in its constructor which will be used by Execute. These objects are exposed as properties so I can fake them for unit tests. In a code review a colleague suggested that I might need to make all of those objects Variable<T> "for them to play nicely in WF (with all the threading etc. going on)", but wasn't sure on that. Do I need to make these Variable<T>? If not, when would I want to use Variable<T> in a CodeActivity?

MDX to pass all members of a hierarchy to SSRS

  
Hi.. I am creating a report action for a cube. i want to pass the members of different levels from the hierarchy to the report.I don know how to retrieve the members from different level. Can some one provide me a basic strcture of the code to achive that.    
Categories: 
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