.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

Translate Named Sets

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


I have some Named Sets that I want to translate. I have done exactly the same way as with the Calculated Members but the Sets don´t use the translations? Any ide why?

View Complete Post

More Related Resource Links

Named Sets and hierarchies


I'm trying to build some requested relative date logic in a SSAS 2005 cube.  I can build the named sets, and they work fine.  When I drag them out as a column in my tool (Cognos, if it's relevant) it lists the actual members of the named set.  I would like to give those members some sort of artificial parent, so that when I add it, I get the parent.  If I drill into it, I get the actual members.


Hopefully this makes sense. I'm very new to SSAS, so I may be messing up my terminology.


Named Sets vs. Calculated Members and the Filter Field Conundrum (Year-to-Date measures by company c


I’m going to describe our SSAS solution a bit and what I have in it so far in order to ask the question regarding “year-to-date” sales. This is part example and part question, I suppose. "The Filter Field Conundrum" sounds like it should be a high-tech Encyclopedia Brown case or something. Can't seem to find a similar situation through searching, although perhaps I'm wrong and this has been done before.

We have a data warehouse that contains our transactional detail for the last nine or so years. Tables are somewhat analogous to the AdventureWorks solution, with a table for Sales, a table for Customers, Geographic information, etc. The data warehouse has a time table that contains many of the usual bits of information one would expect:

Full Date (mm/dd/yyyy)
Month Number
Month Name
Day of Month
Day of Week
Day of Week Name
Day of Year
Week of Year
and maybe a few other typical fields.

Then we also have:
Working Day (bit, with a 1 indicating that this was a scheduled working day according to our company calendar, and a 0 indicating that it was not)
Working Day of Month
Working Day of Year
(these fields indicate that a day is the nth scheduled working day, according to our company calendar, for a given month or year)

So, for example, 5/1

Permissions needed on Named Sets?


Hello All.

I have a simple cube deployed and I just now added a named set using the TopCount functin as follows:


AS TopCount([Publisher].[Publisher Initials].Members, 10,[Measures].[Ad Rate]),

DISPLAY_FOLDER = 'Top Performers';

After processing, I can see and use the new Named Set in both the BIDS Cube Browser and in Excel, but another user cannot even see it. I have Administrator rights on the Analysis Server, he is simpl

hierarchical named sets?


Hi all,
When you create a named set in AS, it seems to be a flat set and drilldown or drillup is not possible. How can I implement something like a named set that would allow drilldown?

A better way to reference your wizard steps using named steps

Note: this article uses the plain vanilla but the concepts apply equally well to its popular counterpart .

By far the most common way that I see wizard steps reference in code snippets is by their index.

.NET 3.5 Adds Named Pipes Support

you want a named pipe server, all you have to do is create some instances of NamedPipeServerStream to handle each client connection. I stole the following code straight from the MSDN documentation.

Introduction to strongly Typed Data Sets

This article teaches how to create a strongly-typed dataset class library in your C# database applications. Our objectives are as follows:

.Learn what an strongly-Typed Data Set is
.Let Visual Studio Create a ST Data Set
.(Semi)Manually create a ST Data Set using XSD (Xml Schema Definition)

{ End Bracket }: Translate This Page


This month we examine the Microsoft translation Web service and show you how you can incorporate translation services into your own Web application.

Sandor Maurice & Vikram Dendi

MSDN Magazine April 2009

Optional named parameters work pretty well

Rob has found a use for dynamic: http://blog.wekeroad.com/2010/08/06/flexible-parameters-with-csharp Yay! Let's celebrate! Well, I was a little puzzled because I don't think it quite adds up in the specific example he chose (although please see no aggressiveness here: Rob's a friend; peace!). The idea is to have the same flexibility that a dynamic language can offer in terms of evolution of an API. Here's his original Ruby example: def my_method(args)   thing_one = args["thing1"]   thing_two = args["thing2"] end my_method :thing1 => "value", :thing2 = Time.now The idea, which is quite common in dynamic languages, is that instead of passing a list of predetermined parameters in a specific order, you...(read more)

Is master page a best alternative for Frame Sets ??


My webpage has one banner with a logo, a vertical menu bar on the left side of the page and a footer . I have 5 other pages which should get loaded when the user select them from the menu bar. what my concern is actually the banner,  menu bar  and the footer should not change when the requested page loads. This definitely can be handled by sets. But I want to know whether there are any other alternatives for frame sets or could master page be helpful for this purpose ????? 

Any help would be appreciative .

Linq to sql does not return appropriate multiple result sets with "If exists" conditions in the stor


Hello All,

I have a stored proc that returns 4 resultsets, they are in the format.

ALTER PROCEDURE [dbo].[pGetManagerEmployeeSummaryDummy]

    @ManagerStaffID int,
    @PeriodID int



IF EXISTS (select 1 from dbo.temployee e
    inner join dbo.temployeedetail ed
        on e.staffindividualid = ed.staffindividualid
        and ed.periodid = @PeriodID  
    inner join Incentive.tRole r
        on rm.IncentiveRoleID = r.RoleID
    where ed.ManagerIndividualStaffID = @ManagerStaffID
    AND r.RoleID = 1) --Closer
        SELECT e.StaffIndividualID, e.LastName, e.FirstName, r.RoleName, e.xname, e.yname

from dbo.temployee e

inner join dbo.temployeedetail ed
            on e.staffindividualid = ed.staffindividualid
            and ed.periodid = @PeriodID

where ed.ManagerIndividualStaffID = @ManagerStaffID

'There is no Web named' in logs


I was wondering if anybody could help me.  When i look at logs in C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\LOGS i get a lot of errors saying 'There is no Web named'.

For example:-
09/08/2008 09:29:37.17  w3wp.exe (0x1BA0)                        0x296C Windows SharePoint Services    General                        8kh7 High     There is no Web named "/quality/Audit Reports/Forms/AllItems.aspx". 

There are no errors in server application event log.  I was hoping to find out what this means and if i should worry about the errors. 


Chris Rees.

Video: SharePoint 2010: Advanced Routing and Document Sets

Learn how to work with document sets such as RPFs (Request for Proposal), which may be made up of multiple documents such as the question document, the answer document, and many other supporting documents and files. (Length: 13:56)

Named Pipes code

We created a very simplistic wrapper for named pipes. If all you need is a basic messag epipe, this should work for you. Code & info at Named Pipes in .NET thanks - daveVery funny video - Reporting as a Metaphor

working with multiple data sets

i am new to ssrs and looking for guidance : i need to develop a report based on multiple tables: general ledger, customer ledger and customer master... the purpose of report is to have customer segment wise sales and expense information.... for given month and YTD. customer segments are defined in customer master, sales is in customer ledger and expenses are in general ledger.. the problem i am facing are: 1. I need to display all customer segments, and if no sales /expenese for any segment, then show 0 values.. .however, if i join tables and apply WHERE clause for date..i am missing some segments due to lack of data within where condition 2. i believe having subqueries is expensive when u r dealing with millon records. further i want to know how to have a calculated field based on two different dataset fields.  

Issue with contacting named instance

Hi. I'm having problem with connecting to the named instance of SQL Server. The machine runs Windows 2008 x64 and SQL Server 2008 Std SP1+CU7. It holds 3 instances of service: default, and 2 named ones. We have 2 networks in our company. All instances can be contacted from the 1st localization (the one, which is local to the SQL), but the named instance cannot be contacted form the remote localization. What's amazing, users can connect to the default instance, but when they try to reach the named one, they receive message: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) "Remote" users have permissions to the named instance - I've given them sysadmins to test, they can ping the SQL box and all works fine from the "local" network. Client is Win7+SSMS 2008. Please help.

Named Pipes provider error - backup script

I have a couple of installs of SQL Server 2005 Express.  One thing it doesn't provide is an agent to schedule jobs so I read where you can use Windows job scheduler to execute a batch job to in turn run a sqlcmd file.  I have that working on one server but on the other server I get the dreaded Name Pipes provider error and it goes on to talk about it may not be setup to allow remote connections.  If I check using Surface Configurator it is set to allow remote connections using both tcpip and named pipes.  To my knowledge all I want it tcpip but I enabled named pipes in an effort to get things working. About the only difference I can see is on the working system the database is a named instance (ie. Servername) versus default instance on the non-working system which shows up as (Servername\SQLEXPRESS).  Hopefully I have my terminology right here. Any tips on how to troubleshoot?  Does it depend on the username I am using?  Domain admin or local server admin or what have you? I should mention I can execute the backup script and it does work.  It is when I run the batch job that it fails. The batch job just says "sqlcmd -i d:\MSSQL_Jobs\backup.sql -o d:\Logs\sqlbackup_output.txt"
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