Alternate Drill Down messed up after migartion to C8

[zaco]

Hi Guys,
We are migrating our existing CRN environment to Cognos8
CRN reports were migrated seamlessly

The problem is with the tansformer cubes.
When we publish the cube from Framework Manager to Cognos Connection & open it in Analysis Studio the Alternate hierarchy is messed up. When we were using PPES it worked fine.
We are having serious problems with Drill through Reports as we are not being able to define the Scope & Prompts correctly as the levels are not appearing.
Any idea why this is happening  ::)
Thanks in advance

ZACO

[COGNOiSe administrator]

What is the C8 version?

[shaadi007]

Can you be specific with the version which you used for powerplay(before & after migration),this will help us to understand the problem.

[johnpenna]

We had this problem also..Cognos sugestion was to upgrade the cubes using their cube swap utility

If you want to rebuild the PowerCubes you can use the cubeswap utility.
As stated on the Admin and Security Guide:

Update a PowerCube Connection

If a PowerCube has been rebuilt, you can update the connection information without affecting
current users. To do this, you must first update the connection information to the rebuilt
PowerCube, and then refresh the report servers to use the rebuilt PowerCube for new connections.
The updated PowerCube will be used for all new sessions referencing that data source. Any user
that has an active session against the data source may have to re-open their session. Old
PowerCubes can be removed only after all sessions using that PowerCube have ended.
When you rebuild the cube, we recommend that you use a new name for the PowerCube, such as
including the current date in the new name. You can then store the rebuilt PowerCube in the same
location as the old PowerCube. For convenience, Cognos provides the sample script cubeswap.bat
or cubeswap.sh that is located in the c8_location/webapps/utilities/cubeSwap directory. You can
get more information about the script syntax by running the script without any parameters.


Tip: You can automate this task using the Cognos 8 SDK to hot swap PowerCubes. For more
information, see the SDK Developer Guide.
Steps
1. On the portal toolbar, click Tools, Directory.
2. Click the Data Sources tab.
3. Click the data source representing the cube you want to update.
4. Click the set properties button for the connection you want to update.
5. Click the Connection tab.
6. Click the edit button for the connection string.
7. Change the file path and name to point to the rebuilt cube.
Tip: To test whether parameters are correct, click Test. If prompted, type a user ID and
password or select a signon, and then click OK.
8. Click OK, and OK again to return to the data sources page.
9. On the portal toolbar, click Tools, Server Administration.
10. Click the Configure tab.
11. Click the refresh report services connection button.
Any new connections to the PowerCube will use the updated cube.

You can also have a look at KB
http://support.cognos.com/knowledgebase/googlesearch?load_kb_document=1&dr=kbcdr&uniqueid=133222

[CGSALT]

Hi,

that didn´t really help me out.

I already use the cubeswap.bat but get the following phenomenon:

the time-dimension shows like this in Transformer model:

Code Select Expand


year
-month
--date


and as an alternate drill down i have

Code Select Expand


year
-week
--date


what i want to get is a hierarchy that looks like this:

Code Select Expand


date
-by months
---2008
---2009
----mar/2008
----apr/2008
----may/2008
and so on
-by weeks            <--alternate drill down for weeks
---2008
---2009
---2010


(that´s also what i see if i use PowerPlay)

but what i actually get in Analysis Studio(same mdc!) is:

Code Select Expand


date
-by months
---2008
---2009
----mar/2008
----apr/2008
----may/2008
and so on
2008
-42/2008       <--week
-43/2008
2009
2010



can anyone help me?