Viewing 15 posts - 31 through 45 (of 73 total)
MEMBER DayCount ASCOUNT(
EXCEPT(
Descendants([Date].[Fiscal].CurrentMember,5),
STRTOMEMBER('[Date].[Fiscal].[Date].&['+Format(Now(),'yyyyMMdd')+']')
:
STRTOMEMBER('[Date].[Fiscal].[Date].&[99991231]'))
,INCLUDEEMPTY)
I hope that helps 🙂
Thank you 🙂 !! I will try this in my freetime ...Now i need another help .I am trying to find the Distinct...
September 24, 2014 at 4:31 am
Hi PB_BI,
some what i was able to solve the problem..with other technique...i have defined a new column and assigned the value as 1 to it and declared...
September 24, 2014 at 3:50 am
When you say it's dynamic, is it consuming a parameter? If so you can use the StrToMember function to make that work, like so:
STRTOMEMBER("[Date].[Calendar].[Date].&["+your parameter+"]").Parent.Children
That did the Trick Sorry...
September 24, 2014 at 12:39 am
Yes, i thought the same and i have implemented that with Date only..but the problem is with Members ...The member selection of Date is dynamic here so i have added...
September 16, 2014 at 3:35 am
Hi Jeff Moden,
I am really gladful that the query was useful but i need an MDX expression as it is the one which i can use...
September 15, 2014 at 11:55 pm
its Sunday
September 15, 2014 at 11:22 pm
Hi,
Yes i think i am nearer but i am struck somewhere like " .Parent.Children " was used on a Member.
As in my scenario the Members...
September 15, 2014 at 10:48 pm
Hi Bro,
Thanks for your reply .. i hope it can guide me but when i have checked this on the AdventureWorks i am getting the output for...
September 15, 2014 at 8:16 am
sateeshcvtly (9/2/2014)
I think below one will be the easiest way to query your data
SELECT <Col_Name>,CASE WHEN PATINDEX('%[0-9]%',REVERSE(<Col_Name>))>0
THEN RTRIM(SUBSTRING(<Col_Name>,1,LEN(<Col_Name>)-(PATINDEX('%[0-9]%',REVERSE(<Col_Name>)))-2)) -- Please note, we have considered 3 numeric digits in this...
September 4, 2014 at 3:57 am
Eirikur Eiriksson (9/1/2014)
Here is another method, find the last character which is not space or numeric😎
Hi Eiriksson,
There are also quite records like 'ABC DEF 210 '...
September 1, 2014 at 3:24 am
Hi ALL,
Thanks for your Replies . I will try the Methods which are necessary and will let you know
September 1, 2014 at 3:12 am
Could you please explain that a bit please
August 7, 2014 at 4:18 am
For some Tables
Yes they are some Big Tables and for some other Tables the insert and update may be huge
July 28, 2014 at 5:28 am
Actually i am inserting and updating into the Staging table only from Oracle and then we are building a Dimensional Data warehouse upon that ..
But here i am Inserting and...
July 28, 2014 at 1:30 am
So if you have Database1 and Database2 (for example) and want to create Database3 you type Database3 in the "To Database" box on the general tab of the restore options.
Yes,...
June 19, 2014 at 7:34 am
Viewing 15 posts - 31 through 45 (of 73 total)