Focal Point
[CLOSED] Cube Designer for SQL Server Analysis Services

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4587062296

January 02, 2020, 04:05 PM
jw
[CLOSED] Cube Designer for SQL Server Analysis Services
Hi, I'm new to Webfocus - this is my first post. We are on version 8206. I'm trying to create a Meta for a SQL Server Analysis Services Cube. In help, I noticed there is a view called the Cube View - however when I add or edit an existing cube meta I only see the regular meta view (not the cube view). Not sure what I'm doing wrong - is it an adapter setting of some sort? Thanks in advance!

This message has been edited. Last edited by: FP Mod Chuck,


8207.13
January 02, 2020, 04:25 PM
BabakNYC
The only reference I've seen to Cube Views is related to DB2. I'm not familiar with SSAS but creating metadata for it should take into account the hierarchies you've defined in SSAS.

When you create the metadata do you see Measures and Dimensions with different level hierarchies? This is the link to the detailed steps documented for creating synonyms for SSAS. https://webfocusinfocenter.inf...adapteradmin7710.pdf

Starting at page 1466 it goes over an example that might be helpful.


WebFOCUS 8206, Unix, Windows
January 03, 2020, 08:13 AM
jw
OK, thanks for your input!


8207.13