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


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

Cube is showing empty values.

Posted By:      Posted Date: September 13, 2010    Points: 0   Category :Sql Server
 
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.  


View Complete Post


More Related Resource Links

Values in user control fields empty when AutoEventWireup=true ?

  
As a BizTalk developer I'm trying to build a ASP.NET website so some obvious things might be new to me (so please be gentle). I have a web form and I have a user control on it. This user control contains a panel with some user properties that are to be stored in a database. So far nothing fancy. The user control itself contains a panel and is working fine (all code to retrieve and store the values is working). I used the default settings of creating a user control and one of them was AutoEventWireup=true. This works fine because I also have some dropdown boxes (and other fields) that need to be filled with values from the database and that happens in the Page_load event. The panel specifies the 'DefaultButton' which calls a method when clicked to save the values after the user has changed them. On this click the code of the method is called, I confirmed that, but I found out that the values of my controls on the user control (for example the Textbox control) are empty. As a non-ASP.NET developer I couldn't figure out why. So I changed some settings like AutoEventWireup to false. Off course this resulted in my dropdown boxes no longer to be initially filled, but my surprise was big to find out my controls actually contained the values the user typed in. Logically I need both the values and th

Line chart with no breaks over empty values

  
I'm sure that I'm just missing a property but I can't find it.  I have a line chart with a contiguous range of dates on the X-axis.  If the series field has an empty value, I'd like to see the line plotted from the previous non-empty point to the next non-empty point rather than seeing a break in the line for that date.  Thanks in advance.Paul Turley, MVP [Hitachi Consulting] SQLServerBIBlog.com

spgridview RowDataBound event returning cell values as empty

  
Hi.

i am working with SPGridView to display Announcements. User should be able to edit his own created Announcements.Remaining Items shouldnt be having edit option.

i created SPGridView Columns :

                SPBoundField Title = new SPBoundField();
                Title.HeaderText = "Title";
                Title.HeaderStyle.Font.Bold = true;
                Title.DataField = "Title";
               grdAnnouncements.Columns.Add(Title);


                SPBoundField Description = new SPBoundField();
                Description.HeaderText = "Description";
                Description.DataField = "Description";
                grdAnnouncements.Columns.Add(Description);

          

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

  

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?

 

Thanks


Jagannathan Santhanam

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.

Value in cube not showing in SSRS report

  

Hello,

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.


 

 


How to send filter values to a PivotTable filter when using SSAS cube as data source?

  

Hi,

I have created a custom filter web part that implements IWebPartParameters. I'm able to send values from this web part to and Excel Web Access web part and get it to set a pivottable filter based on this value.

Now, I want to do the same for an Excel Pivottable that's connected to an SSAS cube. However, I can't get the parameter value to set the filter. Is there some special format that I need to send the values in to be able to set a pivottable filter for a SSAS cube?

Thanks,
Chris


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?


Writeback: showing differences between old and new values

  

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


Webpart causing authentication error when cache is empty - showing just fine, when a lokal admin has

  

Hi

I'm having some trouble with a webpart and some rights, I think.

I have created a webpart, showing some data from at database. Based on which Active Directory group the user is in, some part of the webpart is either show or hidden.

My problem is now, that every morning, the webpart causes an error, saying you need to logon. When I open the same page from the local machine with a local admin, the webpart shows up, and the webpart is now show as it should for everyone.
This behaviour happens next morning.

The webpart is deployed to the GAC.
I also sometimes se the problem when a user, who is in a group that enables them to se the "add comment" part of my webpart, they get the error, but the user, which are NOT allowed to se the "add comment" part see the webpart just fine.

I hope it is clear, what my problem is, but I will gladly try to explain deeper, what the issue is.

 


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.


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