I have column in table that contains values such as:
I would like to use a query that could get this values and then multiply them out for example
5D7 wouble 5 *7 + 8M7 would be 8 * 7 + 9M7 would be 9 * 7 = total and so on.
Can someone guide me in the right direction.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes. We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…