Debbie Edwards (9/6/2012)

---

Oh no! 🙁

This has been my least favourite issue this year. Ive still not got my issue resolved at all.

Thanks for the extra advice. Ill get myself a...

Well, Debbie, I must have had some weird premonitiion as I now have the exact same problem. Oh boy!

Sounds like we do things in a similar fashion. IBIDS...

I may have found a way around the cube being offline - when you go to process, check the options for ignoring errors. It's maybe not the best thing...

oh, and it never hurts to ask for a reboot of the server!

happy to help! I'm not such an old pro at this myself so I know how frustrating it can be!

The script is the second step in my SQL Agent...

Not sure I can be much help, but "stuck for months" got to me.

When I get a cube processing error, I usually can fix it by processing each dimension separately...

script component would be the only other way I'd consider, since you can have 2 outputs and shoot records out the desired pipeline.

The null check in there is slightly different...

You could use a derived column to create a clone field of only the size appropriate so there would be no truncation.

Just use substring, start at 1 and create a...

sqlvogel (8/7/2012)

---

Low market share? That's a difficult thing to quantify in a useful way....

Check the filter. If you are filtering out records from the underlying database, then you would not see all records in the dsv. I must be missing something...

Adam Bean (8/10/2012)

---

Hey all,

Sadly, I know close to nothing about SSAS. I recently joined a new company and we're working on some environment architecture. They're currently targeting the utilization of...

herladygeekedness (8/2/2012)

---

We are trying to get more visibility into what tasks inside a dataflow take the longest, vary by time of day, etc. Event handlers are in place to...

Phil Parkin (8/2/2012)

---

herladygeekedness (8/2/2012)

---

Not talking about the result, talking about the length argument.

I created a simple expression using -2 as length and was unable to save the expression...

Not talking about the result, talking about the length argument.

I created a simple expression using -2 as length and was unable to save the expression due to "length...

Devesh_Srivastava (8/1/2012)

---

substring ("Archive_Full_20120731200002",1, (FINDSTRING( "Archive_Full_20120731200002","Full_", 1)-2))

Then how come the above expression is working where the exact string is used instead of a variable and still negative value is accepted!!! Does...