Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
To "Excel" or not to "Excel"?
Hi, Can anyone tell me where Excel lacks as an OLAP reporting tool? What are the major show-stoppers? I know for sure that Excel is very popular among users and requires minimal training. I have a project coming up and I'm contemplating on using Excel. Thanks! X-)- SQLUser
- Thread
- Replies: 2
- Forum: Data Warehousing/Big Data
-
To "Excel" or not to "Excel"?
Hi, Can anyone tell me where Excel lacks as an OLAP reporting tool? What are the major show-stoppers? I know for sure that Excel is very popular among users and requires minimal training. I have a project coming up and I'm contemplating on using Excel. Thanks! X-) -
What is a STOVEPIPE Datamart???
Hi, I have observed a lot of OLAP gurus throw in terms like Stovepipe datamart, stovepipe application, etc. WHAT IS A STOVEPIPE Datamart?? or a Stovepipe *whatever*? Stovepiped, SQLUser p.s. I know the dictionary meaning of stovepipe (pipe coming out of stove..going into chimney), so please... -
Tricky Time Dimension Problem (Need expert's opinion)
Hi!<br><br>I haven't been able to figure out an effective method for designing the time dimension for my cube (Microsoft OLAP).<br><br>I have two DateTime columns in my fact table OriginDate and DropOutDate, that need to be represented as dimensions.<br><br>Can I create a single shared(?)... -
How to have two Time Dimensions without creating two different tables?
Hi,<br><br><b>Tool(s): Microsoft OLAP Server (SP2), Knosys Proclarity, HOLAP structure for cube</b><br><br>I have a scenario, where I have 2 time columns in my fact table and they both contain different values for each fact row. <i>For example, OriginDate and DropOutDate.</i><br><br>The client...
