Vantage Data Warehousing

Yahoo Archive
1
I have MSSQL. I don't have a big budget. I also have an IT staff of two (including me), and building cubes is something I don't know much about.

The process of building OLAP cubes, ETL workflows, and reports seems like a pretty big task. Realistically I have probably a half-dozen critical views that we'd need to build to satisfy most of the needs.

Sounds like CorVu is a bad idea though. That's good to know.

Anyone know anything about WhereScape Red? Basically they have a tool that automates the building of the data warehouse - you design it and then it does the code generation and scheduling behind the scenes for you. Looks pretty slick, but I have no idea of the cost.

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Vic Drecchio
Sent: Friday, September 04, 2009 9:47 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] (unknown)

CorVu is garbage. IMHO. Stay away from it. It's clunky, convoluted
and not intuitive for users.

Cognos is good.

Both require a lot of setup and initial expense.

If you have $$ budgeted for BI software, my 2 cents, is to use that
money and upgrade your database to SQL (assuming you are Progress).
Then you can do all the BI yourself and still use Crystal Reports,
excel, etc by building complex SQL queries and turning them into Views
for users to safely hit.

Either way you have to build cubes ("views") and construct everything
anyway. With this route at least you get the added benefit and freedom
of SQL.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian W. Spolarich
Sent: Friday, September 04, 2009 9:37 AM
To: vantage
Subject: [Vantage] (unknown)

We are on 8.03.4xx and are thinking about BI/reporting need beyond
BAQ, etc.

Epicor has CorVu for 8.x and EPM if we want to wait until we upgrade
to 9.0.

I am also looking at other alternatives including hosted services
(PivotLink) and commercial open source.

Do folks have particular success stories or other wisdom to share?
Our need are I think pretty typical.

Sent from my (br)iPhone


------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links





------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
2
We are on 8.03.4xx and are thinking about BI/reporting need beyond
BAQ, etc.

Epicor has CorVu for 8.x and EPM if we want to wait until we upgrade
to 9.0.

I am also looking at other alternatives including hosted services
(PivotLink) and commercial open source.

Do folks have particular success stories or other wisdom to share?
Our need are I think pretty typical.

Sent from my (br)iPhone
3
CorVu is garbage. IMHO. Stay away from it. It's clunky, convoluted
and not intuitive for users.

Cognos is good.

Both require a lot of setup and initial expense.

If you have $$ budgeted for BI software, my 2 cents, is to use that
money and upgrade your database to SQL (assuming you are Progress).
Then you can do all the BI yourself and still use Crystal Reports,
excel, etc by building complex SQL queries and turning them into Views
for users to safely hit.

Either way you have to build cubes ("views") and construct everything
anyway. With this route at least you get the added benefit and freedom
of SQL.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian W. Spolarich
Sent: Friday, September 04, 2009 9:37 AM
To: vantage
Subject: [Vantage] (unknown)

We are on 8.03.4xx and are thinking about BI/reporting need beyond
BAQ, etc.

Epicor has CorVu for 8.x and EPM if we want to wait until we upgrade
to 9.0.

I am also looking at other alternatives including hosted services
(PivotLink) and commercial open source.

Do folks have particular success stories or other wisdom to share?
Our need are I think pretty typical.

Sent from my (br)iPhone


------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
4
Ill more than second Vic's recommendation, and assessment of Corvu.



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Vic Drecchio
Sent: Friday, September 04, 2009 8:47 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] (unknown)





CorVu is garbage. IMHO. Stay away from it. It's clunky, convoluted
and not intuitive for users.

Cognos is good.

Both require a lot of setup and initial expense.

If you have $$ budgeted for BI software, my 2 cents, is to use that
money and upgrade your database to SQL (assuming you are Progress).
Then you can do all the BI yourself and still use Crystal Reports,
excel, etc by building complex SQL queries and turning them into Views
for users to safely hit.

Either way you have to build cubes ("views") and construct everything
anyway. With this route at least you get the added benefit and freedom
of SQL.

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Brian W. Spolarich
Sent: Friday, September 04, 2009 9:37 AM
To: vantage
Subject: [Vantage] (unknown)

We are on 8.03.4xx and are thinking about BI/reporting need beyond
BAQ, etc.

Epicor has CorVu for 8.x and EPM if we want to wait until we upgrade
to 9.0.

I am also looking at other alternatives including hosted services
(PivotLink) and commercial open source.

Do folks have particular success stories or other wisdom to share?
Our need are I think pretty typical.

Sent from my (br)iPhone

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links





[Non-text portions of this message have been removed]
5
I spent very little time looking at corvu after installing it and didn't like what I saw. Instead I chose to do the sql views route like Vic mentioned. I'd like to add that you can do sql views in progress, through you are limited because (as far as my experience goes) you can't do triggers, stored procedures and functions in dml/sql. From what I understand you could do this in 4gl or java, but I would prefer the sql server route as well.

--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> CorVu is garbage. IMHO. Stay away from it. It's clunky, convoluted
> and not intuitive for users.
>
> Cognos is good.
>
> Both require a lot of setup and initial expense.
>
> If you have $$ budgeted for BI software, my 2 cents, is to use that
> money and upgrade your database to SQL (assuming you are Progress).
> Then you can do all the BI yourself and still use Crystal Reports,
> excel, etc by building complex SQL queries and turning them into Views
> for users to safely hit.
>
> Either way you have to build cubes ("views") and construct everything
> anyway. With this route at least you get the added benefit and freedom
> of SQL.
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Brian W. Spolarich
> Sent: Friday, September 04, 2009 9:37 AM
> To: vantage
> Subject: [Vantage] (unknown)
>
> We are on 8.03.4xx and are thinking about BI/reporting need beyond
> BAQ, etc.
>
> Epicor has CorVu for 8.x and EPM if we want to wait until we upgrade
> to 9.0.
>
> I am also looking at other alternatives including hosted services
> (PivotLink) and commercial open source.
>
> Do folks have particular success stories or other wisdom to share?
> Our need are I think pretty typical.
>
> Sent from my (br)iPhone
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>