.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

Cube is showing twice the amount / qty I see in the relational DB ...

Posted By:      Posted Date: September 21, 2010    Points: 0   Category :Sql Server

Our OLAP cube is showing almost (but not exact) twice the summed up value stored in the relational fact table. I am scratching my head here to figure out as to what the issue may be here. Any thoughts?



Jagannathan Santhanam

View Complete Post

More Related Resource Links

Retrieve cube data directly from Relational database - is this possible?

I have a cube created in SSAS R2 2008. Now i would like to retrieve some data from this cube, using MDX language, and then to process it in Relational SQL database! Is this possible? I am new in SSAS, please help!  

Cube is showing empty values.

Hello,          When I do the full process for the cube, the data present the fact table getting updated properly into the cube and I had done the full process on the dimension which are part of the cube. But, when I tried to browse the cube, I am getting the empty values. Please help me on this. Thank you!! Regards, Pradeep.  

Value in cube not showing in SSRS report



I'm scratching my head on this one!

I have an MDX query which gives me the value 287529 for a field. I can see this in SSAS, excel, and in the query designer is SSRS but when the report renders it brings back 0 for that field.

All other fields are okay its just that one. I have taken off alll cell formatting in the mdx script and on the report.


Any iedas...


Many thanks.



showing NULL under "Amount" and "Type" columns

When i run this code it brings back data for "Amount" and "Type" columns for 1st week only, and for rest of 14 weeks it shows NULL under "Amount" and "Type" columns.
I need to get the date for all 15 weeks under "Amount" and "Type" columns.
@parm_account Varchar(50),
@parm_currency Varchar(10),

@parm_location Varchar(50),

--@parm_month Int,

@parm_week Int,

@parm_year Int

--SET @parm_account = 'CITINETTING-417A'
--SET @parm_account = 'CPS-465-USD'
SET @parm_account = 'WAR-458-USD'

SET @parm_currency = 'USD'

--SET @parm_location = '(417A) - Cebu, Philippines Div. Office TM'
--SET @parm_location = '(465) - Juarez Div. Ofc. (368) - Juarez, Mexico'
SET @parm_location = '(458) - Tampa, FL'

--SET @parm_month = 1

SET @parm_week = 1

SET @parm_year = 2009

CREATE TABLE #date_fill( 

      date   DateTime,

      year   Int,

      week   Int


DECLARE @date_from DateTime

DECLARE @date_to DateTime
--SELECT @date_from = Min(beginday) FROM Lex_Reporting.lex.learfiscalcal WHERE year = @parm_year and month = @parm_month

SELECT @date_from = Min(beginday) FROM Reporting.fiscalcal WHERE year = @parm_year and week = @parm_week

--SELECT @date_to = Max(endday) FROM Reporting.fiscalcal WHERE year = @parm_year and month = @parm_month
SELECT @date_to = (SELECT max(T.MaxEnddate

want to execute url without showing that page or url to client.


hello friends,

I need ur help,what i want to do is to execute a url ("To send a text message to client") on client registration but without showing that url page, in short executing url without displaying any page or url to the client.

please help and thanks in advance.

Trouble with UpdateProgress showing...


Recently I converted a project to VS.NET2010 and ASP.NET 4.0 (not convinced this is the problem, but regardless this is when the problem began) and now I am having an issue with an AJAX UpdateProgress showing. Here is the abrriviated code:

   <asp:UpdatePanel ID="UpdatePanelPostPageLoad" runat="server">
         <asp:Timer ID="tmrPostPageLoad" Enabled="false" Interval="100" OnTick="PostPageLoad_LoadData"
         <asp:Timer ID="tmrPostPageLoadPt2" Enabled="false" Interval="1" OnTick="PostPageLoad_LoadDataPt2"
         <%--Placing the UpdateProgress inside the UpdatePanel targeted--%>
         <asp:UpdateProgress ID="UpdateProgressPostPageLoad" runat="server" DisplayAfter="0" AssociatedUpdatePanelID="UpdatePanelPostPageLoad">
                       Updating blah blah....


DAL Dataset showing all the column


I follow the tutorial and create DAL with Dataset. I created a Table Adapter with many column, but when i Call a simple Get for 2 column only. The system display 2 column and the rest column with empty data.

My question is that will this affect the performance? because i only need 2 column.

example: Table with 40 column define in Dataset in DAL. I have GetMember from Dataset with 40 column, some request only 1 column (with 39 empty), some request 22 column (with 18 empty column). Will this affact the performance?

Should i create a seperate DatasetAllColumn, Dataset1Column, Dataset22Column ?? so system only return exact column i need. and hofully the performance is optimized to it best.

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
            CrystalReportViewer1.ParameterFieldInfo = paramFields;

Toolbox: User Interfaces, Podcasts, Object-Relational Mappings and More


This column covers common user interface groupings, configuring NHibernate using C#, and a look at interesting books and podcasts.

Scott Mitchell

MSDN Magazine October 2009

SQL Data Services: The Relational Database of the Azure Services Platform


This article shows you the new face of SQL Data Services, explores its architecture, and shows how it is truly an extension of SQL Server in the cloud.

David Robinson

MSDN Magazine August 2009

Dynamic Data Entities Modal GridViewPager not showing


I am using the ModalEF template, converted to a web application.

The GridViewPager is not showing up, though everything else works fine (filters, updates, etc).

I have tried several things in the last two weeks, to no avail.

Any assistance would be greatly appreciated.

The GridViewPager.ascx.cs Page_Load fires, but the Page_PreRender does not.




<%@ Page Title="" Language="C#" MasterPageFile="~/DefaultMaster.master" AutoEventWireup="True" CodeBehind="ListDetailsModal.aspx.cs" Inherits="DATTWeb.DynamicData.PageTemplates.ListDetailsModal" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="ajaxToolKit" %>
<%@ Register Assembly="System.Web.Entity, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089" Namespace="System.Web.UI.WebControls" tagprefix="asp" %>

<%@ Register src="~/DynamicData/Content/GridViewPager.ascx" tagname="GridViewPager" tagprefix="asp" %>
<%@ Register src="~/DynamicData/Content/FilterUserControl.ascx" tagname="DynamicFilter" tagprefix="asp" %>

<asp:Content ID="Content2&quo

memberships web part not showing memberships


Hi all,

We are using MOSS 2010.

The My Sites area offers a web part called "My Memberships" (memberships.dwp).
I have copied this to our portal site collection and am using it on the homepage.

After doing user profile imports and full search crawls the web part however is not correctly showing user memberships.
Sometimes it shows all, sometimes it shows a few, sometimes it shows none.

Can anyone please advise?




Content and Structure Report not showing all items

I have an environment where the Site Owner is not seeing all items pending approval when they access that view from the root node in the Content And Structure section.

We can see pending items in this view if they access some of the lower level nodes in the tree structure, just not from the top node.

I've noticed that the second level nodes are not inheriting permissions from the root node, but I'm not sure if that is relevant. I've also checked the CAML for the Pending Approval view and it has not been altered in any way.

Any ideas?

Top-Level Search Scope not showing in Sub-Site


I've got a site 'B' created under site 'A' in SharePoint. When I'm at Site A, I can search and find things that exist in both A&B. However, when I'm in B, the 'highest' search scope I can pick is 'B.' I'd like to be able to select one step higher so that I can search A&B from any page. Is this possible?

Excel file not showing in search results

We have a strange issue. I have one Excel document (or at least one that I am aware of) that will not show up in search results for content within the document. I can find the document by title just fine, but when I search for words within the document I do not see it. The document was originally a 2003 Excel document and was recently converted to 2007. Other than that there isn't really anything unusual about it (some formatting stuff, but mainly just background colors and whatnot, nothing fancy). The crawl log shows the document was crawled without error. Anyone know anything else I can check on?

Organization Hierarchy - Manger not showing


SharePoint 2007 SP2 on Server 2008 R2

I am doing a custom profile import using AD and a BDC connection.  All the data comes in and populates correctly, including the 'Manager' field which is being populated from the BDC entity. All main fields are being populated from the BDC entity.  Fields are; First name, last name, email, office and cell phone, and manager.

However, when viewing the Organization Hierarchy, the users 'Manager' is not showing up in the Hierarchy. Nothing above the current user is shown in the Hierarchy.  The Manager field is populated with a valid user.  If I display the Manager field in the 'Details' section, I can see the name and click on it to see their profile page as well, so it is all valid and accurate.

Colleagues ( users with the same Manager ) are listed in the Hierarchy, but none of their hierarchy's show the manager either.

I have deleted every profile and then done a full import several times with the same result. Incremental import does ont have any affect either.

Any suggestions or advice on how to get the Manager to display?

Thanks to all!


Showing the rows of a gridview as hyperlinks


Hi all, 
In the following code i have to continuing showing the rows of the gridview as links. For example: the user will click on a customer and will see more detailed information. Please suggest how to continue with an example. Thank you

    protected void Button1_Click(object sender, EventArgs e)
        //List<Customer> customersresult = new List<Customer>(); does not match the type here
        CustomerWebServiceClient.Customer[] cust;
        CustomerWebServiceClient.CustomerWebService client = new CustomerWebServiceClient.CustomerWebService();
        cust = client.GetCustomerContract(TextBox1.Text); //coming across now..
        //if (cust.va) validate if there is data
        GridView1.DataSource = cust;

// this is showing the gridview with the data coming. What would be next steps to show the rows as hyperlinks.

Thank you

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