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


Post New Web Links

How to update Cube.Measure "DESCRIPTION"

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

Hi,

How to update DESCRIPTION from $System.MDSCHEMA_MEASURES without re-deploying and re-processing the cube.

I'm using the Cube.Measure DESCRIPTION propertie to let the end user know what the measure meens, I update this propertie offen, How to do this without needing to redeploy en reporcess the entire cube ?

many thanks,




View Complete Post


More Related Resource Links

MSAS 2005 vs 2008 - different results of an UPDATE CUBE instruction

  
Hi ALL!   When moving from SSAS2005 to SSAS2008 I have a problem with write enabled cubes. On SSAS2005 UPDATE CUBE instruction occures almost instantaneously but on SSAS 2008 this takes few seconds. I created a cube with one dimension and one measure for testing. No aggregations, fact table initially empty, measure has 3 elements. Profiler shows that SSAS2008 UPDATE CUBE instruction initiates cube processing, but SSAS2005 doesn’t do this. What's wrong? Please, help! SSAS2005 Profiler: http://savepic.ru/1593644.jpg SSAS2008 Profiler: http://savepic.ru/1584428.jpg   Thnx!

Improving performance of UPDATE CUBE by executing preceding CREATE CACHE for the same cell / subcube

  
Hi All, Recently I came across one of suggestions by Microsoft Advisory consultant regarding optimization data write-back pattern for the SSAS cubes. It was recommended issuing CREATE CACHE command following by UPDATE CUBE for the same cell/subcube definition: CREATE CACHE FOR [MYCUBE] AS ("Cross join of all the dimension members defining subcube to be updated") UPDATE CUBE [MYCUBE] SET ("Cell") = 100, ("Another Cell") = 200,... etc. for every cell. This seems quite weird, but based on our benchmark the entire process (CREATE CACHE and UPDATE CUBE) takes less time than just UPDATE CACHE. Folks, can someone advice on the insights of the process? Shell this approach to be suggested for an enterprise-level planning application? Regards, -h

Cannot see the Dimension description while using Local Cube with Excel

  
Hi everyone, I'm new to the world of Analysis Services, so I might make a stupid question.
I searched over the web, but I haven't found an answer.

I'm using:
- Microsoft SQL Server Analysis Server 9.00.4035.00
- Microsoft Office Excel 2003 Sp3 (i have the Excel Add-in for SQL Analysis Services version 1.5.0166.0)

I created a cube in Microsoft Visual Studio 2005 with a fact table and only one dimension.
In the 'KeyColumns' DimensionAttribute properties i have the Dimension key and in 'NameColumn' the description.

When I browse the cube with Excel (olap driver 9.0) I can see the description of the Dimension without problem.

The problem starts when I create the local cube with the excel procedure (create offline cube) and I connect to It using Excel; in this case, the description ('NameColumn') disappears and i can see only the Dimension code ('KeyColumns').
When I connect again to the server Cube, leaving the local cube connection, i can see again the description.
It seems that the Local cube does not contain the description of the Dimension, but only the key.

I did the same thing using Microsoft SQL Server Analysis Server 2000, and when I connect to the local cube created with Excel I have no problem viewing the description of the Dimension.

Where am I doing wrong? Am i fo

Alter measure group: Impact on cube processing?

  
Hi All,

I have a XMLA script to alter source column (<ColumnID>) of a measure. I would like to know
following regarding the script:

1 - Do I have to 'Process Full' the cube or other processing options are applicable?
2 - The cube takes 2 hrs to process. Will there be reduction in process time processing the cube
    after running the script or will it take the whole 2 hrs?
   
It running cube on production so I would like to minimize the impact of the alter script.

Thanks in advance for any help.

same measure total differs in same cube

  

Hi.  Folks at http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/4dad8e33-315e-4d36-a781-94448ce7e7ad seemed anxious to mark my finding "answered" so I'm posting here for an explanation of what seems to be a bug in ssas.

I am getting different totals in one measure group depending on whether the ssas db is first deleted before processing.  The total is incorrect if the db isnt first deleted prior to a "process full" on this measure group.  The measure involved is sourced from a money column that uses (all) 4 decimal places not just 2.  For over 300 million facts, I havent seen the error amount to more than $1.15.  But that is unacceptable in this app.

To some extent we've exhausted the money vs currency display argument.  This doesnt seem to matter if we do a full deployment after the ssas db is deleted. 

Is this a bug?  Does it only affect measures sourced by money columns?  Only if they go past 2 decimal places?  Only after a large number of deletions and a few inserts in the source star table?

Normally, this measure group processes Add.  Will I find that isnt working either?   The star source row deletio

Measure Error in Cube

  

Hi All,

One of our cubes has one measure showing #Error in SSMS and #value! in Browser. This is not a calculation and is coming straight form the fact table. The value shows up correctly in fact table and the cube processes without any errors. Any ideas?

 

Thanks in advance.


how to create calculated measure in cube that always gives value on Year level in Date hierarchy

  

Hello,

I'm using SQL 2008 standarrd. Probably a simple question,

But I want to creata a calculated measure in a cube that always displays a measure(e.g. total sales) on the year level of the Date-dimension-hierachy.

So wether I choose Year, Quarter, Month or Day, it always shows the measure value  (sales) on the Year level. How to do that?

Regards, Hennie


how to create calculated measure in cube that always gives value on Year level in Date hierarchy

  

Hello,

I'm using SQL 2008 standarrd. Probably a simple question,

But I want to creata a calculated measure in a cube that always displays a measure(e.g. total sales) on the year level of the Date-dimension-hierachy.

So wether I choose Year, Quarter, Month or Day, it always shows the measure value  (sales) on the Year level. How to do that?

Regards, Hennie


Obect reference error when using "Last Value" cube measure

  

Hi, I'm getting a pretty sweet object reference error when I change one of my measure from "sum" to "Last Value":

"Object reference not set to an instance of an object"

I get it when I try to process the cube from VS (SSAS 2008).  Once I change it back to "sum" the cube processes fine.  I have another cube, all else equal, that processes fine with a last value measure. I also tried "Last non-empty value" but that also failed.  Any thoughts?


What is best way to create a measure that applies to 2 or more measure groups in a cube?

  

I'm designing an SSAS cube with 2 measure groups, each representing a business process related to Orders.  The fact table for the first measure group (Order Fact) is loaded when an Order is placed, and the fact table for the 2nd measure group (Order Check Fact) is loaded when a Check is cut to pay for the Order.  In addition, a third measure group (using Order Fact) has been created to calculate a Distinct Count of Orders (the measure name is [Number of Orders]).

Here is what the Dimension Usage tab looks like (all Regular relationships):

 

Order_Check_Fact

Order_Fact

Distinct Count Orders

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

Issue with Report Model on a Cube (multiple measure groups)

  

Hi All, 

I have was asked to built a report model on the cube for some users and being new to report builder 3.0. 

I am having a weird issue. Lets Say I have following DIMS and FACTS. I have a cube built on top this Dimensional model. 

Two measure Groups/mearsures  : ClassFact/ClassHours and FacilitatorFact/FacilitatorHours.

used Many to Many relationship for FacilitatorDIM and ClassFact measuregoup. I now browse the cube it works excellent. 

The problem Starts

Now a report model is built on top of it, then in the query wizard when I pull both groups and then FName the Classhours(measure) Disappears. 

Does Report Modes supports Many to Many or am I missing something? Any help will be appreciated. 

Thanks

 

Dims

ClassDIM (ClassID, ClassName) 

FacilitatorDIM ( FID, FName) 

Facts

ClassFact( ClassID, Classhours) 

FacilitatorFACT(FID, ClassID, FacilitatorHours)

 

Sample Data: 

 

 

SELECT     ClassID = 1 , ClassDurationHours = 100.0

FROM       ClassFact

UNION 

SELECT     ClassID = 2 , ClassDurationHour

ASP.Net Gridview Edit Update Cancel Commands

  
In ASP.Net 2.0, GridView Control also provides the functionality to edit and update the data retrieved from the database using CommandField template. You can cancel the action using Cancel Command of the CommandField. GridView consists of events that can be used to perform the actions like edit, update and cancel upon the Data items displayed in the ASP.Net GridView Data Control.

How to format and update GridView and DataGrid rows using JQuery

  
The behavior described in this question is as expected. When you set text of a cell in grid, it directly affects HTML that is going to be rendered. When you set text value of a cell, it means that you are setting innerText of the cell. The column that GridView creates for command fields (Edit, Delete and Select) are a (anchor) or button elements. So you can see what will happen if you set text value in that cell. It will wipe out those link or button controls and replace them with simple text string.

Update Vs SystemUpdate

  
Many of you might noticed that share point ListItem has Update() method as well as SystemUpdate().

What is the difference between these two methods and why MOSS has two different APIs for updating an ListItem

SqlCommand.ExecuteNonQuery() returns -1 when doing Insert / Update / Delete

  
Sometimes you end up with a return value of -1 when using the SqlClient.SqlCommand.ExecuteNonQuery method.

Why is that?



Well, the ExecuteNonQuery method is there for statements for changing data, ie. DELETE / UPDATE /INSERT, and the returned value are the number of rows affected by that statement.

When checking the documentation we can see that there are some conditions that return -1.



For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command.

When a trigger exists on a table being inserted or updated, the return value includes the number of rows affected by both the insert or update operation and the number of

rows affected by the trigger or triggers. For all other types of statements, the return value is -1. If a rollback occurs, the return value is also -1.
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