Viewing 15 posts - 496 through 510 (of 893 total)
zahid_mian (3/24/2015)
I am trying to pass two parameters. The following command works fine but when I add an other variable it gives me error.
%dtexecPath% /F %dtsxpath% /set "\Package.Variables[User::Parm_Ind].Properties.Value";"%parm_ind"...
March 24, 2015 at 3:26 pm
It really depends on what you're trying to do. The first 2 you have on your list are really the same...by default, if you create a calculated member it will...
March 24, 2015 at 3:20 pm
seaport (3/24/2015)
1. With Member Test1 as ....
2. With Member Measures.Test1 as ...
3. With Member DimensionName.HierarchyName.Test1 as ....
As far as I see...
March 24, 2015 at 12:05 pm
with member [Measures].[Last Sibling]
as
(
[D Movimientos].[Elemento - Movimiento].currentmember.parent.lastchild.name
)
select{
[Measures].[H Movimientos Count]
,[Measures].[Last Sibling]
} on 0
,{
[D Movimientos].[Elemento - Movimiento].[Id Elemento]
} on 1
from[Test]
March 23, 2015 at 5:06 pm
maretix (3/20/2015)
I attach dimension structure and image about Role User FullStore and Role SelectedSpecificStore
Stat_Resp_Age_Cli is dimension like Customer
Analisys is about customer...
March 23, 2015 at 10:05 am
With all due respect, I think you're doing something wrong. There is no need for scope assignments here...
The attached images show two exact queries, one executed with a role that...
March 20, 2015 at 3:45 pm
maretix (3/19/2015)
SUM ([Stores].[Stores].[Cod Store],[Measures].[Sales Amount])
But the result works good only if i browse cube with a role that can work with all stores.
The syntax of your calculated measure is incorrect....
March 20, 2015 at 9:12 am
There is a LastChild() function you can use for that. Syntax can be found here: https://msdn.microsoft.com/en-us/library/ms145576.aspx
March 20, 2015 at 9:08 am
TWH (3/19/2015)
Thanks. I actually just solved it this week using help from Chris Webb's blog:
Perfect, I would have pointed you in that direction as well.
March 19, 2015 at 2:08 pm
Not sure if you still need help with this. If you do, could you please post your query?
March 19, 2015 at 11:46 am
There should be no need to create a calculated measure in my opinion.
Have a look at the attached image. By default, if you select a dimension member to allow access...
March 19, 2015 at 9:51 am
VALEK (3/18/2015)
It freezes on DBSCHEMA_TABLES command.
Yes we have dimension and cube security.
Do you think this is do to with the custom security?>
Could be. According to TechNet that command...
March 19, 2015 at 9:35 am
sroberts 84045 (3/19/2015)
- Yes. "FISCAL_YEAR"...
March 19, 2015 at 9:17 am
Something like this would work:
aggregate
(
{[Date].[Fiscal Date Hierarchy].currentmember : [Date].[Fiscal Date Hierarchy].currentmember.lead(11)}
,[Measures].[Sales]
)
Note that this would include the current month, and the next 11 months...making it 12 in total.
If you need to...
March 18, 2015 at 4:57 pm
I do think there is some caching (or cache warming) going on the first time you connect, but I don't think all the calculations have to be verified individually. Do...
March 18, 2015 at 4:20 pm
Viewing 15 posts - 496 through 510 (of 893 total)