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


Top 5 Contributors of the Month
ASPEvil
david stephan
Santhakumar Munuswamy
Fauzul Azmi
Post New Web Links

Writeback: showing differences between old and new values

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :
 

I'm looking use writeback to display what if information on a cube. Putting the new values into the cube isn't a problem but having done so I would like to be able to see the difference between the old and new values.

As far as I can see from the documentation this isn't possible from a naive query, once the new value is there that's what you see. And searching here and elsewhere turns up nothing useful. Have I missed something?

Is there a recommended approach to achieve this? The sort of thing I'm envisaging is being able to an axis in pivot table view that shows : before, after, change.

Thanks,

Ian




View Complete Post


More Related Resource Links

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.  

Registry Values not showing up in RegEdit

  
I have a .Net VB app which uses:  {RegKey=Software\PEdge\Connect}

My.Computer.Registry.LocalMachine.CreateSubKey(RegKey)

to create a Key, then it adds a few Subkeys using: {Hive=HKEY_LOCAL_MACHINE; RegistryKeyPath=Software\Wow6432Node\PEdge\; RegKeyValue=Connect

My.Computer.Registry.SetValue(Hive & RegistryKeyPath & RegistryKeyValue, "Version", "12345")
My.Computer.Registry.SetValue(Hive & RegistryKeyPath & RegistryKeyValue, "SQLUser", "sa")
My.Computer.Registry.SetValue(Hive & RegistryKeyPath & RegistryKeyValue, "SQLPass", "9999")

This code worked fine on x86 machine, but now I am trying to get it to work on an x64 machine.  I have build the code for an x86 and it runs and I have other code which returns the values using:

txtSQLUser.Text = My.Computer.Registry.GetValue(Hive & RegistryKeyPath & RegistryKeyValue, "SQLUser", Nothing)

This works fine in the code and returns the proper value.  However, for the life of me, I cannot find these values in RegEdit.  I have looked under Software\PEdge\Connect and also Software\Wow6432Node\PEdge..  Nothing.  I have searche the registry for the value, again nothing.  SO the program is somehow finding the value, but I can not through RegEdit.

DataGrid not showing the values..from dataset

  
You cannot vote on your own post
0

Hello,

I have a DataSet which has some values. I try to assign it to datagrid's dataContext property . it does not displays the value.

i aslo checked the binding. it is proper. Can anybody suggest me what is to be done?.

 

Regards,

Kuldeep Gupta.


Regards Kuldeep Gupta

Regards Kuldeep Gupta

DataGrid not showing the values..

  

Hello,

I have a DataTable which has some values. I try to assign it to datagrid's dataContext property . it does not displays the value.

i aslo checked the binding. it is proper. Can anybody suggest me what is to be done?.

 

Regards,

Kuldeep Gupta.


Regards Kuldeep Gupta

Cube Writeback with weighted allocation working strangely - creating large negative values against f

  

Hi

 

I've got a cube (2008) with 2 MGs: Actuals and Budgets.

The Budgets partition is Write-Enabled.

 

On Excel 2010 the user will select the Actual Date for 2010-07, and will set the Budget date to 2011.

After seeing what the YTD actual figure looks like he enters the budget for 2011.

It is supposed to take that budget figure and split it between the funds that have actuals against them (using weighting).

 

Here's the problem:

 

SSAS allocates inflated figures against those funds, and then, so that the sum of those values will equal the originally entered amount, it puts a large negative value against the first Member in the fund dimension (I experimented with this by deleting the first member in that dimension. It just allocates the negative value against the new member!).

Why isn't it just allocating the values based on the ratio that it gets from that Actuals calc?

 

 

The UPDATE statement on the trace looked like this:

 

UPDATE CUBE [Forecasting]
SET  (
        [Actuals Date].[Year-Quarter-Month-Day Hierarchy].[Calendar Year Month].&[2010-07]
        , [Budget Date].[Year-Quarter-Month-Day Hierarchy].[Calendar Year].&[2011]

Web Part Custom Property Text Values Showing Up on Page

  

I've created a basic Web Part in a .wsp and defined two custom web properties.

However, whatever value I place in these text values when in the edit mode show up on the Page beneath the Web Part name.  Why?  How do I not show the value of Properties outside of the Modify Property window?


How to Pass Values Between Web Pages ASP.NET

  
You can pass information between pages in various ways, some of which depend on how the redirection occurs. The following options are available even if the source page is in a different ASP.NET Web application from the target page, or if the source page is not an ASP.NET Web page:

Use a query string.

Get HTTP POST information from the source page.

The following options are available only when the source and target pages are in the same ASP.NET Web application.

Use session state.

Create public properties in the source page and access the property values in the target page.

Get control information in the target page from controls in the source page.

How to Pass Values Between ASP.NET Web Pages

  
You can pass information between pages in various ways, some of which depend on how the redirection occurs. The following options are available even if the source page is in a different ASP.NET Web application from the target page, or if the source page is not an ASP.NET Web page:

Use a query string.

Get HTTP POST information from the source page.

The following options are available only when the source and target pages are in the same ASP.NET Web application.

Use session state.

Create public properties in the source page and access the property values in the target page.

Get control information in the target page from controls in the source page.

jquery autocomplete multiple values

  

i got some samples and i did autocomplete using jquery , its working well for single input values

but i need to pass multiples values after one by one in the textbox. Is it possible to pass multiple

values in the textbox for autocomplete in jquery in asp.net?

 


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

      </ContentTemplate>
   </asp:Up

JQGrid Loading deleted values

  

Hi,

This is quite strange. here is the issue:

Some Info:

1. I'm using a multi-select jqgrid.

2. I have my own delete button to delete multiple orders

The problem:

When i press the delete button on the pager of my jqgrid, the records are deleted from the database but JqGrid shows some records (4-5). On refreshing the grid, correct numbers of records are shown.


Here is the code:


function delorder() {
        var amg = $("#horder").getGridParam('selarrrow');
        var cont = amg.length;
        if (amg.length > 0) {

How to cast integer values as an array of enum values?

  

Hello all!

I'm working with VS2010 Beta2, ASP.NET and Dynamic Data. I'm using VB but will certainly be happy to receive a C# example if necessary. Laughing

I used a few of Steve's examples (Writing Attributes and Extension Methods for Dynamic Data and Dynamic Data - Hiding Columns in selected PageTemplates) to create a custom property attribute to be applied to a dynamic data column and want it to accept an array of enum values (each value will represent a dynamic data page template where this column should not be displayed).  My new attribute works fine when I hardcode it like this, meaning the HideColumnIn attribute is properly populated with the array of enum values:

<HideColumnIn(PageTemplate.List, PageTemplate.Edit)> _
Public Property My_DD_Column As Object

 

However, I want to store the values to be used for the HideColumnIn in the DB as integer values that correspond to the

Passing values in pages

  

Hi! Friends..

how to pass the value from one page to another page in asp.net  with out Using State Management Concepts?

Like 1. cookies

        2.Session

        3. QueryStrings

     With out using the above should pass the values...


how to bind Dropdownlist based on textbox values

  

hi

I have one drodownlist which show data based om textbox values...

Let us consider i have 

Select Name from table1 where Type IN(@typ)

here @typ is textbox values

here for example textbox will have some thing like this L1,L2,L3..

How to filter Name based and shown in drodownlist based on this L1,L2,L3(on textbox)..

Help me in this


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.


Unable to get all the values from a field

  

Am reading an XML from web service and storing in  a dataset. 
then in write to a DataTable as follows

 DataTable dtResult1 = dsSearch.Tables["RESULTSET"];    
 DataTable dtHIT = dsSearch.Tables["HIT"];     
 DataTable dtField = dsSearch.Tables["FIELD"]; 

The issue  is  in the DataTable dtField i can only see 3 columns FieldID,Name,HIT_ID

The corresponding values in the dataTable looks like this for the corresponding fileds

0,rank,0
1,internalid,0
2,contentid,0
3,contentids,0
4,collection,0 

I am unable to get the Field Name values 1,8799f4646b6ed9acde142581a84f75a6 ,234B5F5F-F247-4EB6-9E39-A7B64C7FE1BD,Yes...etc

What would be the cause for this...Any Help

Below is the structure of the XML-


- <RESULTSET FIRSTHIT="1" LASTHIT="10" HITS="10" TOTALHITS="46" MAXRANK="3159" TIME="0.0040"> 
- <HIT NO="1" RANK="2955" SITEID="0" MOREHITS="0" FCOCOUNT="0"> 
<FIELD NAME="rank">1</FIELD> 
<FIELD NAME="internalid">8799f4646b6ed9acde142581a84f75a6 </FIELD> 
<FIELD NAME="contentid">234B5F5F-F247-4EB6-9E39-A7B64C7FE1BD</FIELD> 
<FIELD NAME="contentids" /> 
<FIELD NAME="collection&
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