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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
-
Creating local cube slices.
The error "No members found..." usually comes when you have an empty dimension table (no rows) 1. Either you enter some rows in the dimension (and remember to PROCESS it!). If you do have rows, process the dimension individually from OLAP mmc console. OR 2. Edit the cube and... -
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-) -
OLAP Drill down in Microsoft OLAP server.
The OLAP cube is only supposed to contain aggregates. For getting down to the transactional data, query your datamart database directly AND NOT the cube. -
'Truncate log on checkpoint' setting is changing
Somewhere inside stored procedures/sql scripts/etc... there is code (probably) that says... sp_dboption 'db_name', trunc. log on chkpt.', 'true' Check for it!- SQLUser
- Post #3
- Forum: Microsoft SQL Server: Programming
-
More about publishing a Microsoft OLAP cube
If you're a developer and you're writing ASP... The LastProcessed property of the MDStore interface contains the date and time when an MDStore object was last processed. See SQL online books for programming details. Search on the keyword "LastProcessed". -
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... -
How do I set my reprocessing off automatically?
1. Download Service Pack 2 for SQL Server<br>2. Download Service Pack 2 for SQL OLAP Services<br>3. Download the add-ins...<br> <A HREF="http://www.microsoft.com/sql/downloads/DTSKit.htm" TARGET="_new">http://www.microsoft.com/sql/downloads/DTSKit.htm</A><br> <A... -
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...
