Questions on My Data Sets

[CognosIsHard]

Hello wonderful community of Cognoise.com.

I have been a long time lurker, and this is my first time posting.

My client has recently upgraded from 10.2.1 to 10.2.2, and they are looking into utilizing the My Data Set feature. The excel file that I have has 3 sheets. My questions are the following:


1. Is there a way of creating a single package for all 3 sheets? Or do I have to create a package per sheet?

2. In the first sheet I have 2 foreign keys. By changing the Default Summary to None, I specify which columns are the FK. However, I'm receiving an error: (MSR-LOB-0013 Unable to read the data set object "storeID). This is problematic because, after importing the file this error doesn't allow me to edit the data set. Also, the reports break.

For the error what I've done that somewhat works is to remove one of the FKs from the original file. Obviously this will not be the optimal solution.

Please, please, let me know if I can provide more detail. Because I'd LOVE to. Not only to get my work done--duh!--but I'd really like to become more involved in this community.

Thank you!!