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


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

mdx or cube structure change?

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

Hi,

Here is the issue I am having with one of the fact table in cube:

My FactTable structure:

EID   LoadTime                         Billable  Traceable

230    2010-09-01 00:08:000      1               1

230    2010-09-04 11:03:000      0               1

230    2010-09-05 00:00:000      1               0

230    2010-09-06 09:12:000      1               0

230    2010-09-07 06:59:000      1               1

231    2010-09-03 09:17:000      1               1

231    2010-09-07 00:00:000      0               1

 

I created a measure group in the cube. EID is for a member and 1 member can have multiple loads. For any given time frame, I need to calculate 2 counts:

Count of EID's and SUM(Billable) of EID's with latest loadTime.

So, how can I calculate SUM(Billable) for EID's with latest LoadTime in


View Complete Post


More Related Resource Links

How to change connection string of a pivot table pointing to SSAS 2005 cube using excel 2003?

  
Hi All,I am not sure if I should have posted this query to Excel 2003 forum. But posting it here as it applies to SSAS 2005 as well.Ok, let me give the background before I tell the actual problem.We have users on ABC domain and the SSAS server is also on ABC domain. Users on this domain can acess the excel pivots by connecting to cube to browse the data. They leave the Userid & password field blank while they setup the connection string and it works fine. Thanks to windows authentication that takes the credentials of user logged in. Let's say I have two users A and B, they login to ABC domain with their own windows ids.  Now when user A creates a excel file having a cube pivot and then sends this file to user B, user B can refresh and modify the same excel file (he can select new measures to pivot, new hierarchies in filters and so on).Now, let's say I have another user, user C. He has excel 2003 installed on his PC and cannot migrate to excel 2007. He is on different domain XYZ but have a valid windows userid on domain ABC. The domain ABC & XYZ can not be setup to have trusted relationship. Now, when user A sends the same excel file to user C. When user C opens the file and try to refresh it or try to modify the pivot by selecting/deselecting any elements, he gets below error prompt:" An error was encountered in the transport layer." and "Errors in the

change data source of cube

  
how to change data source of cube?

Building a Mining Structure from a Cube

  
Hi, I have a problem with creating a time series mining structure from an existing cube. I get the error: The data type specified for the  'Date' column of the 'Purchase Date' OLAP mining structure is not compatible with its source attribute   My date column in this dimension is in fact a Datetime, so it should be the right type for this exercise.  I wonder, am I getting this error because the cube dimension has a Name column of type Varchar specified even though the Key column is dateime?   Thanks, Steve

Building a Mining Structure from a Cube

  
Hi, I have a problem with creating a time series mining structure from an existing cube. I get the error: The data type specified for the  'Date' column of the 'Purchase Date' OLAP mining structure is not compatible with its source attribute   My date column in this dimension is in fact a Datetime, so it should be the right type for this exercise.  I wonder, am I getting this error because the cube dimension has a Name column of type Varchar specified even though the Key column is dateime?   Thanks, Steve

Regarding realtime update of SSAS cube when underlying data change

  

Hello All,

This is regarding the automatic update for SQL Server Analysis Service cube incremental update.

We have developed one cube which contains item details with several attributes.

And in our application, we have built search and to get result we are querying that cube. Now whenever new item is added or any of its details changed, we want to update the cube with changes.

I already know, that we can do it via scheduling cube processing at some small interval. But we want to have some real time optimal solution to update the cube.

If anyone has idea about any optimal method, please let me know. Its very urgent.

Thanks in advance.

 

 


Darshan Vyas

Regarding realtime update of SSAS cube when underlying data change

  

Hello All,

This is regarding the automatic update for SQL Server Analysis Service cube incremental update.

We have developed one cube which contains item details with several attributes.

And in our application, we have built search and to get result we are querying that cube. Now whenever new item is added or any of its details changed, we want to update the cube with changes.

I already know, that we can do it via scheduling cube processing at some small interval. But we want to have some real time optimal solution to update the cube.

If anyone has idea about any optimal method, please let me know. Its very urgent.

Thanks in advance.

 


Darshan Vyas

With Excel pivot table client using SSAS cube, how to change the measures to rows?

  
I want the measures as rows instead of columns in Excel pivot table on a SSAS 2008 cube. How do I do that? Thanks.

How to Localize Windows Forms and Change the Language at Runtime

  
Localization is the process of customizing your application to a particular language, culture or locale. Visual Studio provides support for localizing Windows Forms with much ease. In this article, we will see how to localize windows forms and give the user the ability to change to his preferred language at runtime.
When you run a localized application, the appearance is determined by two culture values. The UICulture property is used to specify which resource files will be loaded for the form. The Culture property, on the other hand, determines how strings such as dates, numerals, and currency amounts are formatted.
Let us see the steps required to create a localized form. You can then expand this example and adopt the same approach for the rest of the forms in your project

Selected to change the background color of the page

  

Hi,

As this site, http://www.borfin.com.tr/genel/Default.aspx, How can I change the background color selected pages.


Bug: Does not change column type from nvarchar to ntext

  

Scenario: If you create a table with a column of type nvarchar, populate it with some content and try to modify it using the WebMatrix editor, from nvarchar to ntext, it does not display any error message or warning that this is not possible. It silently saves and reverts the change, back to nvarchar. Wasted some hours on this issue as I thought my column was ntext, but in fact was still nvarchar.

Expected behavior: It should change to ntext, or if SQL CE doesn't support that, it should notify the user that no change was applied.


How to change the default page base class?

  

I've tried setting the <pages pageBaseType="DynamicWebPage" /> value in web.config, but when I response.write out the page type, I'm still getting Microsoft.WebPages.WebPage.

I'm simply trying to sub-class WebPage and add some additional functionality such as a dynamic PageData dictionary similar to Phil Haack's dynamic ViewData dictionary.

Thanks,

Adam


SqlDataSource how to change the stored procedures at run time

  

Hi

Is it possible to change the select, insert and update stored procedure of an SqlDataSource at run time. I don't mean to change the definition of the stored procedure, but I mean to change the assignment, i.e. To change the select stored procedure from "selectSP1" to "selectSP2" at run time. Is it possible?

Regards

Dimitris


Solution/project structure

  

Hello, I am working in a aspx web application that must be built in several separate "modules" with different functionality which will be partly developed by different teams.

However, I need the completed app to reside in ONE virtual directory. There will be a single startup page. I need session state to be preserved across pages in different modules.

I structured it as one solution with different Web Projects and one class library project with common functionalities.

Questions:

1) is this the right approach to do this? Or which one would be better?

2) each time I add a new web project to the solution, a new web.config gets created. What do I do and where do I put them?

VS 2010 + framework 4.0 + TFS

Regarding TFS and source control, I have a single Team project, the solution and web projects are inside it.

 

Thanks!


Change Button Text in Multi Language Website

  

Hi i developing multi language website

using Master pages

everything fine

Page_Load i set the Text property of Button Control from Resource file

like this

Button1.Text = GetLocalResourceObject("Button1")

then in the button click event i cnage the text of the Button control

Button1.Text = GetLocalResourceObject("Button1_new")

but the text doesn't change and no error messgae

what is the problem how to solve this

 


How to change text in columns in SSRS?

  

I need to create a complex report and export it to Excel. 

In the first column header, text is displayed as "Hide Daily Columns", but I need the text to change as "Unhide Daily columns" when I click on it and when the text changes the columns under "daily" header (I have 3 columns under this header) present in the report shud be hidden and only weekly columns shud be visible. Any ideas please. I am new to SSRS and tried out many ways but didn't get it.


dynamically change column names in Crystal reports

  

I need to develop 3 pages.

On the first page user defines atmost 7 column names to be displayed on the report. I'm saving these names in a Sql DB table 'Columns' with Column_Nm and Column_ID as Table columns.

On the second page I'm retrieving column_Nm from the table and displaying them on the page so that the user enters the data. This data is saved in another table 'Summary' with the Columns column1 through column7.

on the 3rd page I need to show a report of 'Summary' table.

How do I dynamically replace column1 through column7 names with that of 'Column_Nm' on the report?

Any help/suggestions would be appreciated.

 


change to lambda in linq

  

Hello my friends I tried to change this code to lambda but I could not pleaaaase help me:

 

  var inforeport = from m in db.Products where m.UnitPrice > info select new { unit=m.UnitPrice,name= m.ProductName };


 


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