Viewing 15 posts - 481 through 495 (of 893 total)
Not sure exactly how you are doing your lookups, but the Lookup transformation is case sensitive. It is possible that you are getting the same items but with different case,...
April 6, 2015 at 2:25 pm
Apologies for not responding yet, but I am struggling to find a suitable data set for testing. I'll hopefully get something done this week.
April 6, 2015 at 9:35 am
I'd try the url without the "WSDL"...that usually points to a file containing the structure of the expected output, and is typically not used in the url when trying to...
April 6, 2015 at 9:28 am
ttdeveloper (4/3/2015)
Nada🙁
Not sure what the problem is then. The only other thing I can suggest is that you check the dimension usage in your cube. Ensure that the fact table...
April 3, 2015 at 2:01 pm
What does the following query return?
with member [Measures].[Test]
as
(
settostr([Dim Date].[FSCL_YQM].currentmember)
)
select{
[Measures].[BEGIN_LIS]
,[Measures].[Test]
} on 0
,{
{[Dim Region].[REGION_HCY].[REGION_HCY]} -- or replace with the correct attribute name
} on 1
from[VESFINCUBE_TRA]
April 3, 2015 at 1:52 pm
ttdeveloper (4/3/2015)
The behaviour you described is spot on in that without a date dimension on the axo=is, nothing is displayed. The question now is how do I get the...
April 3, 2015 at 1:22 pm
Ok...I see what's going on here now. Took a while 🙂
The problem with your first query is that there is no dimensional scope. Without any dimension members on the axis,...
April 3, 2015 at 9:19 am
Interesting...I would start with capturing the query executed against your SSAS instance. See if it is different when connecting to PROD vs. DEV.
Also check for any differences in aggregations, dimension...
April 3, 2015 at 6:28 am
The cross joins are not the issue here. Your query from BIDS also uses cross joins, denoted by the "*".
You do not have control over the query generated by Excel,...
April 1, 2015 at 9:09 am
Marcus Farrugia (3/24/2015)
March 30, 2015 at 9:14 am
mchokshi 71349 (3/26/2015)
March 30, 2015 at 8:54 am
Phil Parkin (3/25/2015)
If I'm using SSIS to load a table with a clustered PK, will the data load...
March 26, 2015 at 2:24 pm
seaport (3/24/2015)
March 25, 2015 at 9:23 am
ran.ovadia (3/25/2015)
I'm syncing OLAP DB every day from the backend server which process the cube to the frontend.
The cube size is 100 Giga.
The problem is that sometimes the sync time...
March 25, 2015 at 9:18 am
zahid_mian (3/25/2015)
Thanks a lot for the suggestion. I have tried that but it did not work either.
It may have something to do with the way you are interjecting the variables....
March 25, 2015 at 9:11 am
Viewing 15 posts - 481 through 495 (of 893 total)