Creating a default member on date hierarchy

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

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

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

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?

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.

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

  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      

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

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

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.

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?

 

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

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

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