Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     MSOLAP + EXCL2K PIVOT. Is this possible?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
MSOLAP + EXCL2K PIVOT. Is this possible?
 Login/Join
 
Ingas
Gold member
posted
Hallo!

I've found a very strange thing - I can't use EXCL2K PIVOT with MSOLAP datasources.

I have a MSOLAP cube (MS Analysis Services 2K).
I can create synonym with dimensions and measures (using option "Inclusion Of System-Enabled Hierarchies")
I can create reports from this cube in every format except EXCL2K PIVOT.

In documentation:

1."Creating Reports With WebFOCUS Language > Choosing a Display Format > Using Excel Display Formats: Excel 2000, Excel 97, Excel"
I found that at least one field must be PRINT for EXCL2K PIVOT

But in :

2. "Adapter Administration for UNIX, Windows, OpenVMS, i5/OS, and z/OS V7.6.1 > Using the Adapter for Microsoft Analysis Services > Customizing the Microsoft Analysis Services Environment"

I found that I can't PRINT measures, I always must use SUM verb.
((FOC11243) PRINT VERB SHOULD NOT BE USED ON MEASURE ... WITH AGGREGATOR SUM)

And I can't PRINT dimensions
(FOC3256) EXL2K PIVOT TABLE: MULTIVERB REQUEST IS ILLEGAL)

So, is it possible to use EXCL2K PIVOT with MSOLAP?

Thanks in advance!


WF 7.6.2, WinNT/2K, MSSQL 2K, MSOLAP 2K, BID
 
Posts: 79 | Location: Moscow | Registered: April 27, 2007Report This Post
FrankDutch
Virtuoso
posted Hide Post
Can you do it in two steps, first put is in a hold file and then create the final report to put in the pivot.




Frank
prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Ingas
Gold member
posted Hide Post
Thanks, Frank

Yes it can be done through HOLD files, but only for small cubes.
It means sending thousands and million lines to Excel - not good.


WF 7.6.2, WinNT/2K, MSSQL 2K, MSOLAP 2K, BID
 
Posts: 79 | Location: Moscow | Registered: April 27, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     MSOLAP + EXCL2K PIVOT. Is this possible?

Copyright © 1996-2020 Information Builders