Who is online?  0 guests and 1 members
Home  »  search results

Search Results: fiscal

67 results found
  • Create Date Dimension with Fiscal and Time
    Here are three scripts that create and Date and Time Dimension and can add the fiscal columns too. First run the Dim Date script first to create the DimDate table. Make sure you change the start date and end date on the script to your preference. Then run
    Author: MikeDavis MikeDavis     Date: 2/4/2011     Section: Blog
  • Script to load Dim Date and Dim Time
    Here is a script to create a Dim Date and Dim Time table in a data warehouse. I did not write this script but it is a popular request and seems to be hard for people to find on other sites. So I thought I would post it here to make it easier for people to
    Author: MikeDavis MikeDavis     Date: 1/4/2011     Section: Blog
  • Average question
    Alright, well you made me write some MDX to get this to work ;) but here ya go. WITH //Gets a Summation of the Orders in the Fiscal period MEMBER [Measures].[Sum] AS SUM([Date].[Fiscal].CHILDREN,[Measures].[Internet Order Count]) //Counts the days in the
    Author: DustinRyan DustinRyan     Date: 8/5/2011     Section: Forum
  • Error in calculated measure in SSAS 2008
    If you're writing an MDX query for a report, I would use a cell calculation to handle this. A cell calculation will allow you to specify the scope as well as the MDX expression that should be evaluated over the tuples you specified. Here is an example I p
    Author: DustinRyan DustinRyan     Date: 11/4/2011     Section: Forum
  • Calcualtions In Excel
    http://www.bidn.com/articles/mdx-and-dmx/169/mdx-time-calculations-done-the-right-way . As per the article by Devin, I have created the calculations and they works great when accessed via Excel. However, I have a small problem while looking at the data. O
    Author: aganatraDNB aganatraDNB     Date: 12/1/2010     Section: Forum
  • Rolling average by fiscal week and another dimension, help needed.
    I am having an issues with a sales cube that I am building. The idea is to have one dimension that has employee organizational data and another dimension that has our fiscal calendar. The twist here is that at the leaf level of the organizational hierarch
    Author: skerr skerr     Date: 4/23/2012     Section: Forum
  • Current Period of Fiscal Calendar
    I n Visual Studio 2005 I'm trying to get the current fiscal period from my fiscal calendar. In a previous report where my results for my year and week were: [Time].[Fiscal Year].&[2011] and [Time].[Fiscal Week].&[1] I was able to use this expressi
    Author: jholston jholston     Date: 2/17/2011     Section: Forum
  • Current Fiscal Period ...
    Hi all, I need to create a calculated member to keep track of the current fiscal period. How could I achive this? My time dimension includes the following attributes - Fiscal - Fiscal Quarter - Fiscal Period Should I add a new attribute that would let me
    Author: ebaiwa ebaiwa     Date: 2/5/2010     Section: Forum
  • Limiting the Available Values in a date Parameter by Editing the MDX in the Dataset
    While at a client site this week I was helping to build several reports against a cube with a date parameter. This parameter was to return only the fiscal year, and the customer only had data going back to 2008, yet their date dimension had fiscal year va
    Author: TomLannen TomLannen     Date: 10/4/2010     Section: Blog
  • How to create Day,Month,yearwise Cube in SSAS
    about time dimension, there is some posts about it. take a look at: Mike's post in2bi's post In SSAS, there is this link with a good tutorial on how to build time dimension in your as cube. If this helps you, mark post as answered please. Best regards.
    Author: marcoadf marcoadf     Date: 2/10/2012     Section: Forum
  • SSAS YTD Issue - Calendar vs. Fiscal
    Hi All, I've recently been using the following white paper to re-work my SSAS date calculations manually rather than using those created by the time intelligence wizard: A Different Approach to Implementing Time Calculations in SSAS It has all been workin
    Author: Trav Trav     Date: 2/23/2012     Section: Forum
    tags : HIERARCHY, YTD
  • MDX parameter syntax
    Hello, I have a dataset I am trying to pass an MDX value to. My value is: = "[DimDate].[Fiscal_Year].[Fiscal Year Name].&[" & Parameters!DimDateFiscalYearName.Value & "]" I have also tried: = "[DimDate].[Fiscal_Year].[Fiscal Year Name].&["
    Author: JohnCHill JohnCHill     Date: 1/17/2012     Section: Forum
  • T SQL dim_day
    This should help. More here: http://www.ipcdesigns.com/dim_date/dim_day_fiscal_sql.txt and here: http://www.ipcdesigns.com/dim_date/ -- populate fiscal day number of year update common.dim_date set fiscal_day = -- Assumes first year in dim_day begins Janu
    Author: MMilligan MMilligan     Date: 5/3/2012     Section: Forum
  • MDX using now()
    My Fiscal Period is formatted as YYYY-MM. How do I add the dash "-" the the MDX query below to return the current Fiscal Period? WITH SET [CurrentFiscalPeriod] AS { StrToMember("[Date].[Fiscal Hierarchy].[Fiscal Period].&[" + Format(now(), "yyyy")+"]&
    Author: seanthare seanthare     Date: 1/10/2013     Section: Forum
  • Calculated Member to sum YTD has stopped working but sum "All time to Date" is still fine.
    Hi, I posted to the forum a month ago about how to build a sum for all time to date rather than something like YTD. The code I settled on was SUM(PERIODSTODATE([Time].[Fiscal Year Period].[(All)], [Time].[Fiscal Year Period]),[Measures].[Act]) I have made
    Author: robbie robbie     Date: 5/19/2010     Section: Forum
  • MDX YTD calculations
    Hi All, I have the following Fiscal Time dimension: Fiscal Year --> Fiscal Quarter ----> Fiscal period *** This Fiscal Time dimension includes the beginning balance in Period 0 Using the following MDX Calculation: SCOPE ([Relative Time].[By Relative
    Author: ebaiwa ebaiwa     Date: 11/22/2010     Section: Forum
  • MDX for Calculated Member to sum "All Time to date" not YTD
    Hi Robbie, Then you definitely want the more advanced example. This will be your MDX Script (cube code) (Don't forget the semicolon on the end): CREATE MEMBER CURRENTCUBE.[Measures].[ActToDate] AS SUM({NULL:[Dim Time].[Fiscal Year Period].currentmember},[
    Author: CurrentMember CurrentMember     Date: 3/29/2010     Section: Forum
  • Current Fiscal Period ...
    The BI wizard does add some nice functionality, but comes with some security issues and inflexibilities that can cause some problems in certain environments. Your best bet here is to use the currentmember function in your fiscal period hierarchy. Somethin
    Author: AdamJorgensen AdamJorgensen     Date: 2/20/2010     Section: Forum
  • MDX for Calculated Member to sum "All Time to date" not YTD
    Many thanks Luke for your reply. I imagine that it does represent the correct code but my knowledge of MDX is very sparse currently. Here is your code but with the variable names changed for my Cube My Cube is named [Profit and Loss] My Time dimension is
    Author: robbie robbie     Date: 3/29/2010     Section: Forum
  • MDX and Parameters??
    Here is what my current query looks like. I am using the [Current Teams] in a subselect because since it is dynamic I have SSRS can't doesn't allow me to use the dimension value in my chart because there is no metadata. The reason I am using date in a sub
    Author: skerr skerr     Date: 5/23/2012     Section: Forum
  • Date Range in SSRS
    Still a bit unclear. Your new date range is 13 months. Does your fiscal year start on 6/1 and end on 5/31? When you run the report do you ALWAYS want to show the previous complete fiscal year? Or, will there be times when you want to show the current fisc
    Author: Daniel Daniel     Date: 10/1/2012     Section: Forum
  • MDX parameter syntax
    Hello, First of all what's parameter xxx? Is that supposed to reference the DimDateFiscalYearName? The expression looks correct to me have you tried to use the label instead of the value? My last recommendation would be to go back and confirm how this "[D
    Author: ChrisAlbrektson ChrisAlbrektson     Date: 1/17/2012     Section: Forum
  • Current Period of Fiscal Calendar
    Unfortunately, I'm not aware of a function that finds current fiscal quarter or period since any given company can have whatever fiscal year they choose. What you may be able to use to help calculate the fiscal quarter or period is: Quarter: =DatePart(Dat
    Author: kylewalker kylewalker     Date: 3/11/2011     Section: Forum
  • mdx cube calculation that may need to use some type of subquery
    Here's an example of an MDX script that should help you get started: CREATE MEMBER CURRENTCUBE.[Measures].[Act] AS NULL, VISIBLE = 1; CREATE MEMBER CURRENTCUBE.[Measures].[SumMeasure] AS SUM(calculatewhatever here), VISIBLE = 1; SCOPE ([Measures].[Act]);
    Author: DustinRyan DustinRyan     Date: 7/20/2010     Section: Forum
  • Optimizing Prior Year Calculation
    We have a unique prior year calculation in which we only want to compare where we are in the current time period to the parallel period. For example if we are in the fixcal week hierarchy and it is wednesday, we only want to compare the first up to wednes
    Author: zwag20 zwag20     Date: 12/11/2011     Section: Forum