Viewing 15 posts - 16 through 30 (of 354 total)
The source SQL data is int. Im thinking, go into the SSAS viewand do a convert to int over the value.
Its clutching at straws a bit but Ill have a...
February 11, 2015 at 6:10 am
The data source is definitely int.
One thing I can think of. I have a view in Anaylsis services data sources. I could specifically convertit again to int. that may help
Debbie
February 11, 2015 at 6:08 am
thank you. Ill get looking at that. i may have to get a bit of help from the DBA team but its defnitely a plan 🙂
Debbie
January 23, 2015 at 7:40 am
DONE IT!!
Im still not quite sure why and I had to use the Dimension health checker but here it is
I Have
•TimeID (Int)
•Date (Date Time)
•Financial Year (Int)
•Financial Month Number...
January 22, 2015 at 8:35 am
Great,
Ill do some testing with that, I can deninitely work on that. thankyou.
Im having trouble on report drill downs with hierachy data which is one of the reasons...
January 22, 2015 at 7:11 am
In your Key Columns collection what are the exact columns and data types being used?
For Financial Year, Just Financial Year
For Financial Month Financial Year then Financial Month
they are both Varchar...
January 22, 2015 at 6:42 am
Well thats interesting. i just created a test dimension. timeID, Date Financial Month and Financial Year based on a distinct view from my table.
I set the key up to be...
January 22, 2015 at 5:38 am
Im sorry Im not quite sure what you are wanting here?
Do you mean you want to know what data items are in my date time table?
TimeID
Date
AC_YEAR
Academic_Year
AC_TERM
Trimester
Month
Week
Day_Of_Year
Day_Of_Month
Standard Year
Standard_Month_Number
Financial Year
Financial Month
Academic Month
Weekday
Working_Day
For...
January 22, 2015 at 5:26 am
Well, Ive read the documentation and I remember using that to set up my keys.
Ive tried lots more things but still Financial Month just repeats. I set it to...
January 22, 2015 at 5:04 am
I can see alot more work on this for the future 🙁
Thanks for your help
Debbie
January 21, 2015 at 9:41 am
Ill have a look at that. I dont think there is a quater that could be causing the issue but Ill have a look.
I wish I could go back and...
January 21, 2015 at 9:29 am
great
I will have a read of that. Id love to get rid of the Financial Month outside of the hierarchy but Im wary because Im uessing a user has already...
January 21, 2015 at 8:59 am
Im faily sure its the same data source. We did a lot of work making sure that all the reports work the same and reference the correct data source in...
January 21, 2015 at 4:50 am
PB_BI (1/21/2015)
January 21, 2015 at 4:42 am
MAXDOP Settings? Im guessing that would be a question I should ask the DBA team? I wouldnt want to be messing with things that might cause issues. I will have...
January 21, 2015 at 3:23 am
Viewing 15 posts - 16 through 30 (of 354 total)