If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Strange behavior in elist item

Started by cogplan, 09 Jan 2011 11:13:15 AM

Previous topic - Next topic

cogplan

Hi techies
             I am populating analyst data to contributor application. But for only one version and one elist item say one BU . only the data is not getting populated even though I have done multiple A-> Ctransfers.
After reconcilliations are done the data is not reflecting in Contributor Web.

            Access tables also are ok.. Need to just populate one missing cell item eg taxi expenditure .which's not getting populated in that BU .. Can you please help me in this..


Regards
Cogplan

Rutulian

Hi Cogplan,

I'd log this one with Support.  With 8.2 and 8.3 there were a couple of undocumented features around A/Cs, but if you're on 8.4 FP2 or later they should have been ironed out.  If all your mappings are OK then the behaviour will replicate on a support testbox, just send in a deployment of app & library and screenshots of the cells you hope to populate.

If you're moving any significant amount of data, consider using something other than A<>Cs... in my opinion they're really only useful to give a one-shot quick to build way of bouncing data between the two for tests etc, a publish/import loop will run quicker and parallelise elegantly if this is a load which will be running frequently.

Cheers,
Alexis

anandmoholkar

Hi Cogplan,

I would like to check the Access Table settings again.
If you have mentioned NO DATA settings at the beginning of the Access Table and eventually the E-List item to which you are transferring data is not  covered in the Access Table, then that might cause the problem in loading the data.

Please check and let us know !!

Regards,
Anand

cogplan

Thanks Rutulian and Anand
                I tried removing executing certain dlinks associated with the Cube and did a sync and GTP then it did work for me. The data flowed from A to C app. We have two libraries associated with an app. one as a staging library and other as deployment library.. Problem was solved.

Rutulian
      our company still uses 8.1 and we are asking for an upgrade.
All
Which one do you techies suggest in terms of cost ,ease of migration and also form factor.Currently they think TM1 cost is not viable for the company and sometimes 8.1 has lot of bugs and I tend to be lost . As I was working in 8.4 earlier.

Please rush your suggestions as cost is certainly a concern nowadays. IT is not treated as an asset .. its a liability to the company but features which IT provides probably one other division can provide. IT has made life simpler for so many . in the world.. yet its a liability

Rutulian

Hi Cogplan,

Glad to hear you've got it working - remember, Contributor automatically runs all the d-links in the 'update' list when a cube is opened, instead of waiting for you to run them the way Analyst does.  Sounds like this might be coming into play, though I'd have thought it would affect other cells/cubes too.

If you're on 8.1 release-to-market, go to 8.1 MR1 as soon as you can.  It fixes defects and is the most stable release you will see until 8.4FP2.  As long as your libraries are all consistent, which you can check with a rebuild/refresh, an in-place upgrade should be viable.  There's no cost associated as it's a fix pack on top of a version you already have.

Definitely skip 8.2 and 8.3.  Be aware that 8.4 has a different licensing structure, if you have a lot of Analyst users it could get pricey... the main benefits are the deployment functionality (sell this as a massive win for business-critical environments, it makes it much easier to have dev/test/prod environments and safely propagate changes between them, anyone responsible for business continuity planning would be an ally here) and the integration with the BI platform (eg links from FM that actually work, automatically generated FM models on top of publish containers).  Analyst itself doesn't change much, and Contributor gets a few performance tweaks and minor feature tweaks, validations and admin link A-Tables come to mind.

I can't personally comment on 10.1 yet, from an EP perspective it should be a fairly safe release as it's a performance rather than features upgrade, but with 8.4 you're binding to a very solid BI release too - I'd be delighted to hear about people's experiences.

The move from 8.1 is also an opportunity to reengineer your security - you can continue to use Access Manager to administer your S7 namespace and link to that, or you can link to your corporate AD/LDAP which might make your security teams happy.