COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: DavidSmith on 09 Jul 2010 11:05:37 AM

Title: Text import from publish tables
Post by: DavidSmith on 09 Jul 2010 11:05:37 AM
I'm getting an analyst crash when trying to import text and data from an EV table
An example of the d-list dimension for publish is:
Customer(text), product(formatted d-list), Amount(numeric) etc....

I have tried isolating just the text items from the OBDC SQL query and it still crashes.

What I don't get is that I have other cubes with similar Publish dimensions (i.e. a mix of text and numeric) and those links are fine and I haven't needed to split the links

I even tried substituting the dimension for one that does work and it still fails

Ideas?

Title: Re: Text import from publish tables
Post by: DavidSmith on 09 Jul 2010 11:53:40 AM
sorted it

The link was trying to populate detail lines that were formatted as %s