Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Time intelligence connection formula Expand / Collapse
Author
Message
Posted Monday, October 24, 2011 10:19 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 10:41 AM
Points: 12, Visits: 94
look at this:

[url=http://s1120.photobucket.com/albums/l499/tekkaman75/?action=view¤t=ppoint_problem.jpg][/url]

I have use this connection formula:


year-2:year, yeartodate


In Calendar 2011 (green cell) I have the right value (function "year"), but in Calendar 2011 to Date by Day (red cell) I have the wrong value given by "yeartodate" formula
Post #1195350
Posted Monday, October 24, 2011 10:22 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 10:41 AM
Points: 12, Visits: 94
Sorry, I didn't saw your previous reply when I public my last post.

So I have to use an MDX function like periodsToDate in my connection formula? Is it possible using a BI time intelligence post formula filter?

what is Profiler trace?
Post #1195352
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse