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


Top 5 Contributors of the Month
Kaviya Balasubramanian
Imran Ghani
Post New Web Links

filtered drillthrough

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

Ist it possible to define a drillthrough action in ssas, that returns only rows, that meet certain criteria?

In my case, rows are marked with a flag. When this flag is set, i want to hide those rows when the user uses the drillthrough action




View Complete Post


More Related Resource Links

Showing filtered Records in Crystal Report as per User Requirement

  

ReportDocument reportDocument = new ReportDocument();
    ParameterField paramField = new ParameterField();
    ParameterFields paramFields = new ParameterFields();
    ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
    
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            paramField.Name = "@Ext";
            //*Remember to reconstruct the paramDiscreteValue and paramField objects
            paramDiscreteValue.Value = 44854
            paramField.CurrentValues.Add(paramDiscreteValue);
            paramFields.Add(paramField);
            CrystalReportViewer1.ParameterFieldInfo = paramFields;
            reportDocument.Load(Server.MapPath("CMS_Report.rpt"));
&

Getting filtered data from Role based SSAS security

  
Hi everyone,I've got a heap of reports that are based on various SSAS cubes. I have roles defined on these cubes that restrict data via certain dimensions. Question is, will these restrictions filter through to the report...ie, if I have a sales person restricted in the SSAS cube to only see sales against their territory (restricted in the Territory dimension), when they run the report will it filter the result based on their SSAS credentials and only show the data they have access to (even though the SSRS report has no direct filters or parameters applied)?Cheers for any help!!

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

retrun dataType of filtered data using REST API ?

  
I know how to get filter data but unable to figure out return type Here is my Code if you can please correct me       ClientsItem item = (ServiceReference1.ClientsItem) client;     string cl = item.Title;     string url = @"http://sharepoint04/sites/Test/_vti_bin/listdata.svc/Projects$filter=Client eq ' " + cl + @"'" ; ServiceReference1.   TestDataContext cont = new ServiceReference1.TestDataContext(new Uri(url));

How do you change the datasource for a list based on another? ie a secondary list being a filtered

  
I'm actually using Sharepoint 2007, but am hoping this forum will help.  We want to be able to create a list based on a filtered view of another list.  I can create a Filtered List in Designer, but evidently this is saved as a query object on the server and not as another list that can be selected when using the basic Sharepoint tools.  In other words, it's only visible when in Designer.  This means that in order to use this for say a lookup column in another list object, I have to modify the datasource tags for the EditForm and NewForm.aspx pages within Designer.  Also, it means that adding a column would constantly require use of Designer.  We need this to be simple as not all those tasked with administrating pages will know how to do this.  I thought it would be easier if I could simply source a secondary list with the filtered list I created in designer.  In other words, make a secondary list source be that of a queried view of a master list.  Then this list could be used with all the simple tools provided.  Is this possible?  If so... how?

ancestor function not filtered by the where

  
Hi all! this issue might seem easy but I’m fighting it for 2 days now. All I need is to filter the month level to specific children for example with member semiMonthlySum as sum(       ancestor([Time].[Reporter Time].currentmember,[Time].[Reporter Time].[Semi Monthly])                  ,[Measures].[Interaction Count All]) select non empty {[Measures].[Interaction Count All],semiMonthlySum} on 0 , non empty [Time].[Reporter Time].[Date] on 1 from [niceKPI] where {[Time].[dtDate].&[2010-08-16T00:00:00]:[Time].[dtDate].&[2010-08-18T00:00:00]}   Gives me the folowing results Interaction Count All   semiMonthlySum 2010-08-16 00:00:00   1.00                             1,419.00 2010-08-17 00:00:00   101.00                         1,419.00 2010-08-18 00:00:00   12.00                           1,419.00   I would expect that the values for semiMonth

Unique filtered index

  
Hi Friends   Here is my scenario Employee ( EmployeeID int, EmployeeName varchar(50), EmployeeCode varchar(15), IsDeleted bit ) I created a non clustered unique filtered index as below, but it doesn't work for me. That is to say, I cant create two rows with same EmployeeCode and different IsDeleted values. I want to maintain the unique filtered index on Employee code having IsDeleted = 0 CREATE UNIQUE NONCLUSTERED INDEX [U_Nix_User_EmployeeCode] ON [dbo].[Employee] ( [EmployeeCode] ASC ) WHERE ([IsDeleted]=(0)) GO If that is the way it works, Do I create trigger to enforce such a constraint? Thanks in advance for any help Best Regards Asharaf MCTS, http://asharafaliptb.wordpress.com

SSRS 2005 Drillthrough chart Passing Wrong parameter value

  
Hi I have a drillthrough report that in Report A I have a week of data, showing Sunday through Saturday on the X-axis. When a data point is clicked on this chart, it shpuld pass the date of the weekday for that data point to Report B. But sometimes, it passes the prior weekday date, eg click on the Monday date data point, but Sunday's date is passed to the next report. Has anyone observed this type of behavior? I should mention that it is intermittent.   Thanks all.   Bobrpress

Document Library Filtered by Document Type in Sharepoint 2007

  
Dear Friends, I have a doucment library where we uploade the word document, but when I uploade the document that time it show the all file type, Can I filtered those file type in sharepoint 2007, Its very urgent for me.  

Drillthrough not functioning on deployed report (SSRS2008)

  
Hi I have a report with a drillthrough functionality on two cells in a tablix, the intention is for each cell to pass different parameters to the target report. The report fuctions exactly as expected when previewing in BIDS, each drillthough passing the appropriate parameters to the target report. However once the report is deployed (to a SharePoint environment), only one of the drillthroughs will function. In the other, the pointer recognises some kind of link (it changed to a 'clickable' icon) but it won't function (and there is no target displayed at the bottom of the browser as there is with the working link). I've cheked the html source for the page and it appears not to have an onclick command for the first cell (contianing the text 'BSC C701 - BIOCHEMISTRY (4 YR)(I)'): <TD ID="11iT0r9c0" class="a144c"><br/> <DIV class="a144"><br/> <DIV style="overflow-x:hidden;WIDTH:73.14mm;" class="r13"><br/> <DIV class="a143"><br/> <span style="font-style:normal;" class="a140">BSC C701 </span><br/> <span style="font-style:normal;" class="a141"> - </span><br/> <span style="font-style:normal;" class="a142">BIOCHEMISTRY (4 YR)(I) </span><br/> </DIV><

How do I get a filtered collection of MembershipUsers from a data store using custom profile propert

  
A portion of my web.config file:   <profile enabled="true" defaultProvider="AspNetSqlProfileProvider">      <properties>        <add name="FirstName" type="System.String" />        <add name="LastName" type="System.String" />        <add name="Age" type="System.Byte" />        <add name="Weight" type="System.Byte" />        <add name="City" type="System.String" />        <add name="State" type="System.Byte" />        <add name="RelationshipStatus" type="System.Byte" />        <add name="PostalCode" type="System.String" allowAnonymous="true" />        <add name="FavoriteURLs" type="System.Collections.Specialized.StringCollection" allowAnonymous="true" />        <add name="ProfilePhotoFullPath" type="System.S

Filtered Lookup with C#

  
Good day or night, 1)I have a problem with Sharepoint. 2)Ineed to make filter from multimle lookup second listbox2.(It is on NewForm.aspx in sharepoint designer) 3)Problem: get items in C# from lookup listbox2 on sharepoint site. What i have: Multiple lookup. With button "add" from listbox1 we can add multiple items to listbox2. I need get this item to C#. It needs for listbox3(which I create in C#) with CALM query to filter all items what connected only form items what we have choose in listbox2. 4)My tryings: On Shapepoint page with F12 I open source code select listbox2 and get name and ID In C# with recursion find all controls with names and ID. And find usefull control. After that with recursion and table name get litbox2 control than wont get all items from listbox2. Igave control but it anything contain, all time a have null. I thought that problem with page life cycle. Use Page Onload, PreRender but result is null. Problem with control? Can you advice how i can get items in C# from listbox2 or better with simple example (all in NewForm.axp when we wont make new row in sharepoint)?   I try to use JavaSCript in C#, but suppose it is "Epic Fail" of using JS on server site. Because items not selected and tryin get them. But in script is problem the PATH i dont know how to put properly to sharepoint page. Page.RegisterStartupScript

Filtered Lookup with C#

  
Good day or night, 1)I have a problem with Sharepoint. 2)Ineed to make filter from multiple lookup(contain listbox1 and listbox2) second listbox2.(It is on NewForm.aspx in sharepoint designer) 3)Problem: get items in C# from lookup listbox2 on sharepoint site. What i have: Multiple lookup. With button "add" from listbox1 we can add multiple items to listbox2. I need get this item to C#. It needs for listbox3(which I create in C#) with CALM query to filter all items what connected only form items what we have choose in listbox2. 4)My tryings: On Shapepoint page with F12 I open source code select listbox2 and get name and ID In C# with recurson find all controls with names and ID. And find usefull control. After that with recursion and table name get litbox2 control than wont get all items from listbox2. Igave control but it anything contain, all time a have null. I thought that problem with page life cycle. Use Page Onload, prerender but result null. problem with control? can you advice how i can get items in C# from listbox2 or better with simple example (all in NewForm.axp when we wont make new row in sharepoint)?  

disable Infinite Drillthrough (SQL 2008-R2 ) ?

  
Hi all, we upgraded from 2008 to 2008 R2 and now our automatically generated reportmodels (based on Analysis Services) always produce very long hyperlinks as soon as we build reports with RB 1.0. If we export them by excel we encountered timeouts  due to the size. I haven't found any option how to disable the feature "infinite drillthrough" complete or at least for a reportmodel based on a analysis services datasource. Any ideas/suggestions? Thanks for all your help in advance. best regards, Martin

Use Report Action as default drillthrough on a calculated cell in Excel

  
Hi, I am using SSAS 2008 R2 and Excel 2010. Is there a way to override the default behavior from the cube to force an excel pivot table to perform a report action rather than a drillthrough when I double click a cell that is a calculated member? Currently, I get an error message. Truth be told, I wouldn't mind making all the double clicking in my pivot table cells pop a report for the user since the drillthrough formatting is so primitive, but I really need to know how to do it for the calculated cells. Thanks, James

Calculated Measure scenario with a filtered dimensional attribute

  
I have a cube with a Measure (A) and a dimension (C).  I've created a Calculated Measure (B) whose tuple is Measure A with the all member of Dimension C.  The Calculated Measure looks like this: ([Measures].[A], [C].[ALL]) Scenario 1 When I place the dimension on a pivot table, the Calculated Measure B reflects the correct value, Measure A by all members of dimension C. Scenario 2 When I place the dimension in the filter area and filter by one or more members, the Calculated Measure B reflects the correct value, Measure A by all members of dimension C.  The same answer as Scenario 1. Scenario 3 When I place the dimension in the pivot table AND filter by one or more members, I am getting a different answer than I want.  It is filtering first by the members selected and then reflecting the Calculated Measure as the All value of ONLY the selected filter members.  I want the calculated Measure to reflect Measure A by all members of dimension C.  (The same number as in the first two scenarios)   Is there any way to create the Calculated Measure differently so that all three scenarios give me the same answer?  

Using LINQ to Get Filtered List of Controls

  

I have zero experience with LINQ but had occasion to use it today.  I implemented a working solution but do have a question.

First, let me provide the background:

I have 20 large web pages that altogether have several hundred data input controls on them.  There are strong similarities between how each type of control is handled.  Rather than wire up each control individually (ie. hard code it in the layout page), I thought it would be a lot easier to just do so dynamically through a common method.  On each of these web pages there's a MultiView control, inside of which are 2+ View controls.  The guts of my original version of the common method looked like this:

      foreach (View view in multiView.Controls)
      {
        foreach (Control ctrl in view.Controls)
        {
          switch (ctrl.GetType().Name)
          {
            case "DropDownList":
              DropDownList ddList = (DropDownList)ctrl;
       &nbs

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