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


Top 5 Contributors of the Month
ffttt
Post New Web Links

Creating a default member on date hierarchy

Posted By:      Posted Date: November 25, 2010    Points: 0   Category :Sql Server
 

Hi,

I am trying to set a default member on a date dimension.

I have an attribute form the database of IsToday which is a boolean with the value of today eg 23/11/2010 showing as true.

When i go into the Date dimension and try to select [Date].[Is Today].&[True] in Choose a member to be the default I get the error below

DefaultMember(Date,Is Today) (1, 1) The level '[Date]' object was not found in the cube when the string, [Date].[Is Today].&[True], was parsed.

Does anyone have any ideas why this is?

Thanks




View Complete Post


More Related Resource Links

Default date dimension member

  

Hi All,

Is there a way to set a default member in the date dimension so that it will be automatically observed by Excel as a filter?

I have a stock cube which shows stock levels by day. At the moment, users have to change the day filter manually in the Pivot. I'd like it so that it refreshes automatically based on a cube setting so that it is centralised.

It appears I can set a default member for the date attribute, but without selecting date as a specific filter it shows the last non empty value (as defined by the cube structure). I need it to show the stock as per the specific date.

I've accomplished this before using vba in the Excel file, but wondered if there was a better method. Unfortunately named sets don't work in Excel as filters and I don't want to see the date on the rows/columns.

Many thanks,

Matt


From 3.5 to 2.0: No default member found for 'DataTable'

  

Hello!

I'm trying to change the framework of an application I made a while from 3.5 back down to 2.0 as it's not compatible with the new server we put in (we're don't have permission to install 3.5 framework).

So, I went into the project properties and under the Compile tab, changed the project to 2.0. When I tried to publish the project I got a lot of errors and warnings and the publish failed.

In the 3.5 code, I had SQLSelect statement in a Dim which was labeled 'As DataTable'. When switching to 2.0, an error appears on the Dim saying: "Class 'System.Data.DataTable' cannot be indexed because it has no default property". So I simply took DataTable out of the code. Now, when I try to run the project, I get "No default member found for 'DataTable'.

Here's the code:

Function DisplayName(ByVal LoginName)

     Dim tempname(2) As String
     Dim signon As String

     tempname = Split(CheckUser(LoginName), "\")
     singon = tempname(1)

     Dim rst 'As DataTable
     rst = ExecSQLSelect("SELECT given_name, surname FROM ... etc")

     If rst.Rows.Count = 0 Then
          
          DisplayName = "Unknown"

     Else
          
          'This is where the error is:
          DisplayName = rst(0)("giv

Not Null Date Default

  
I'm one of the people that try to avoid nulls when ever possible, usually using defaults.  This is especially important since my apps do a lot of data exchange with external entities often involving flat files.  A flat file can't distinguish between a null or an empty value so to ensure consistancy between data types in both systems I try to make sure every field has some value.  (E.g., If I have a null or empty string in a char field type a CSV flatfile shows ',,' for both.  The target system might interpret this as an empty string or a null; I have no direct control.  This could result in a null in one system and '' in another losing consistancy.  For charactor and number types this is rarely a problem if I communicate that there are no null fields in the data, but for dates it often becomes an issue. Is there a industry standard approach to managing "empty dates" so I can make date fields not null and empty? Thanks

How to create a calcuated member, which will always return the date one month before the currentmemb

  
I need to create a calculated member in the cube script, which will be subsequently used in various other script calculations.  It needs to return the date, which is 1 month before the currentmember of the Date dimension. I tried something like this: CREATE MEMBER CURRENTCUBE.[Measures].[LastPD]   AS           PARALLELPERIOD([Date].[Calendar].[Month], 1, [Date].[Calendar].currentMember) ,VISIBLE = 1; However when I then try to check the values with this query: SELECT [Measures].[LastPD] on 0, [Date].[Calendar].[Date].members on 1 FROM [TravCSAT] ; I only get NULLs for [LastPD].  Any idea what I am doing wrong?

Can the default member for the sql server analysis filter web part be a mdx expression or not

  
I have designed a dashboard , some parametrized reports ( on date and time) in my case with a cube as datasource, added an analysis services 2005 filter, connected it to the reports. The issue concerns the default value for the filter . I f I choose [Date Local].[Calendar Hierarchy].[All] it works well. But the business requirement is to use the last day where there have been registered a measurement which in my case looks like the following mdx expression: Tail( Filter ([Date Local].[Date Key].[Date Key].Members , ( ( [Advisor Organisation].[Advisor organisation].[Contact Center].&[Denmark]&[Kundelinjen], [Measures].[Calls Offered] , [Date Local].[DK Holiday].&[False] , [Date Local].[Week Day].&[True] ) > 0 ) ), 1).Item(0).Item(0) The expression is all right as I use it in my report as an mdx filter expression. But when I use apply it I get an invalid dafault member value. So the question is : Does the filter support an mdx expression ? If yes, is there another syntax or change in order to make it work ? Thank you a lot for your answer.

Change the Default Date in the Date Picker Control

  
Hi, I have a WPF Datagrid in which one of the columns is a Date Column. So i have used a DataTemplateColumn as Follows     <my:DataGridTemplateColumn CellTemplate="{StaticResource EffDateDateTimePickerControl}"   CellEditingTemplate="{StaticResource addrEffDate}" Header="Effective Date"/> And in my Resource File i have written the following code: Style   TargetType="{x:Type my:Calendar}" x:Key="CalenderControlTemplate">     <Setter Property="Template">     <Setter.Value>     <ControlTemplate TargetType="my:Calendar" >     <my:CalendarItem Name="myCalendarItem"   Background="White"   BorderBrush="Black"   BorderThickness="1"   VerticalAlignment="Center" />     </ControlTemplate>       </Setter.Value>     </Setter>     </Style>       <DataTemplate x:Key="EffDateDateTimePickerControl">     <Label x:Name="lblEffDate" Content="{Binding effectiveDate,Mode=TwoWay}" ></Label>     </DataTemplate>     <DataTemplate x:Ke

Allmembers function expects a hierarchy expression for the argument, a member expression is used" er

  
  Hi , I have a report that was working before.  After adding couple calculated mesaure, my report is throwing the error.  Here is the query I used.  Can you please help? this was a working prototype, now it is in trouble.  Need to fix it quickly.  thanks a million   SELECT NON EMPTY { [Measures].[sales], [Measures].[%of sales] } ON COLUMNS, NON EMPTY { ([region].[country].[country].ALLMEMBERS * [Fiscal Period].[Fiscal Year].[Fiscal Year].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM [sales] CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS      

Calc'd Member Specifically for JAN, FEB etc of Chosen Tran Date

  
Hi.  I'd like to display same year calc'd measures [January Completions], [February Completions] ...[December Completions] next to the [Actual Completions] measure for transaction year x, transaction month y. If y is January then [January Completions] thru [December Completions] need to be overridden with zeros.  If y is February, Feb thru Dec need to be overridden with zeros and so on. I started experimenting with the query you see below before transferring the logic to my cube.  I didnt even get to the if/then logic before I saw that April and beyond of each year's [January Completions] was null.  But the correct/same Jan amount showed next to the 1st 3 [Actual Completions] for 2009 and 2010 which are the only years I've loaded at this point. [Actual Completions] itself is a calc'd measure from two different measure groups that share most dims including transaction date.  I dragged the hierarchical month name to the "on rows" clause.  I had no luck mixing hierarchical names with the currentmember function in the "with" clause so I dragged the non hierarchical tran date names there.  What am I doing wrong? with member [Overall Jan Completions This Year] as ([Measures].[Actual Completions], [Date Transaction].[Year].   Currentmember,   select {([Measures].[Actual Com

Need Help in creating different sets within a same hierarchy (Period Hierarchy)

  
Hi, I have a period hierarchy which is set up like , Period -> All -> AllPeriod -> Then it has last 24 months (rolling) ie Period->All->All Period ->Jul08, Aug 08, ....Jun 10. So in all it has got last 24 months in it. Now I need to create a chart in SSRS which will show data for all the years ie in this case it will have 3 series in all, one for Year 2008 (it will contain Jul 08-Dec 08), the second series will contain data for 2009 (Jan 09-Dec 09) and the third will contain the data for year 2010 (Jan 10-Jun 10). In my cube there are no levels like year, half year etc..all the members are in the same level. Can someone guide me to write a proper MDX for this scenario ? What I have tried is this, with   // Getting the data for 2010, I have hard coded 6 for now in the below query as I know the currentmonth is June. set   [StartMonth] as ' bottomcount( {[PERIOD].Members}, 6)' member   [Measures].[SalesValue2010] as ' [Measures].[SalesValue]' member   [Measures].[PrevYearSalesGrowth2010] as '[MeasuresSalesGrowth]' select   non empty {[Measures].[SalesValue2010],[Measures].[PrevYearSalesGrowth2010]} on 0, non   empty {[StartMonth]} on 1   from [MyCube] where   [Condition] I ideally need three salesvalues on my columns . I guess this would be easy but I am very new to MDX and as of now d

MDX Date Range calculated member

  
Hi, I have [Sales Amount] and [Date]. How can I create a calculated member that will aggregate only the values from [Sales Amount] where month([Date]) is 'Jan' or 'Feb' and year is CurrentYear ? Then 'Mar' & 'Apr' and so on.... Thank you. D.

Set default member based on an attribute

  

Hi,

I have a time dimension which is based on a time_dimension table. This has a column called current period which can be set to 0 or 1. My requirement is that I want to set the default member of my Year attribute (which is also part of the time hierarchy) to that value in my dimension table that has current period set to 1. How do i do this?

 


Creating default SharePoint groups for upgraded sites

  

Hello,

I am doing some testing in preparation for a DB attach upgrade from MOSS 2007 to SharePoint Server 2010, and I've run across a bunch of old sites that do not have the default Owners, Members, and Visitors groups. Without those groups (specifically, without Members) we won't be able to take full advantage of the My Sites Memberships page. 

I noticed, though, that when I "Enable Enterprise Features" for all current sites from within Central Administration, sometimes those groups get created on a site that didn't have them before. I've done this on a few different environments and it doesn't seem to always create those groups. Now, I didn't think I had to run Enable Enterprise Features because our 2007 environment was Enterprise, but then I realized some of the sites were created back in SharePoint 2003 and enterprise features might never have been run on the sites when it was upgraded to MOSS 2007. 

So the question: is running Enable Enterprise Features for current sites supposed to create the default groups if they don't exist (along with everything else it does)? Is that the recommended way to get groups made for all sites so site admins/owners can add people to that new Members group which allows the users to visit their My Site page to view all the sites they are members of?

Thanks,
Aaron


MDX Calculations error - The 'Date Calculations' dimension contains more than one hierarchy, there

  

Hi all,

I am using http://www.obs3.com/pdf/A%20Different%20Approach%20to%20Time%20Calculations%20in%20SSAS.pdf to make a seperate dimension for the data calculations, which works in my Sales cube. But when I use the same dimension in an other cube (Called 'Procurement') and copy the MDX in the calculations tab, I am getting some errors:

Error    57    MdxScript(Procurement) (9, 8) The 'Date Calculations' dimension contains more than one hierarchy, therefore the hierarchy must be explicitly specified.        0    0   

But the 'Date Calculations' dimension does not have a hierarchy!

Now I don't know why I am getting these errors, could you guys help me out so I can understand them and fix the problem?

Thanks you in advance,

Daniel


Default date selection in SSRS with SSAS cube as a source

  

Hi,

 

I am fairly new to SSAS and I am hoping that someone can help me with an issue I am experiencing.  I am create a SSRS report that goes against a SSAS cube.  My cube has a Date dimension with a Fiscal Year - Fiscal Quarter - Fiscal Month hierarchy.  In my report I have created filters for a From Date and a To Date, which are populated with the hierarchy of the Date dimension.

 

I need to default the filters as follows:

 

To Date = current quarter (that is the last quarter with fact data)

From Date = the To Date quarter from the previous year (e.g. if To Date quarter = Q1 2008, then From Date quarter needs to be Q1 2007)

 

I found some SSAS code that allows me to get the index of the last quarter with data, but I am stuck at this point.  I am not sure how I can translate this into a default selection for the To Date SSRS report parameter.  I also realize that there may be a better approach.

 

CREATE MEMBER CURRENTCUBE

Is it possible to hide a useless node from a hierarchy by default

  

Hi,

I have a fact table that has a key column to which I basically connect 3 different dimension hierarchies. The hierarchies have some common keys but several keys that aren't common and are put under a "Not applicable" node in each hierarchy. When I'm browsing the cube I can easily hide the "Not applicable" node by deselecting it but is it possible to hide the node by default?


Error creating edit form for external list - Failed to find the default form for PAGETYPE PAGE_NEWFO

  

For the last few days we have been unable to create custom new/edit forms for External Lists in Sharepoint Designer.  When i try to create a form Sharepoint Designer show the message 'Could not save the list changes to the server'.  The corresponding message in the ULS log file is 'Failed to find the default form for PAGETYPE PAGE_NEWFORM'.  Does this mean i have somehow managed to break the form templates for External Lists?

I saw some other posts about the 'Could not save the list changes to the server' error and followed the suggested steps including removing all versions of the list and related content type, and recreatign htem but this didn't work.


how set the default value for date inSQL Server?

  

hi

i need to set a default value for a column of date

i need when the column dont get a date automatic set 1/1/1900 for it.

can you please help me?


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